Select with Conditions
I would like to query my table to output [Name] and [Location] based upon the presense of multiple entries in [Location]. In my example below, "Jones" and "Smith" will output in my query since they were in [Location] in different entries (Seattle and Cleveland). To compare: Lawson has two entries too but they... 29 Mar 2010 11:22
Could any one help me i have to make a crosstab to build a report from its results the problem is i have a table which the data will be taken from named Employee timesheet all the employee's fills the field in so i have many fields and rows which consist of the following data employee - task - project name- ... 30 Mar 2010 11:39
Using Access query data lookup values
Hi, I have a data base with names and address. The street addresses are stored in two fields [AddrHouseNum] and [AddrRoadCode] the [AddRoadCode] field is stored as a three character code, for example Locust Lane is LOC. When I display the fields separately, they show correctly as i.e. "1234" and "Locust Lane".... 29 Mar 2010 10:15
Query on or before date
I have a table for files in our office. There is a field for date files are received and a field for date files are completed. I would like to make a parameter query to show files which were current at a particular time period - i.e. files that were received on or before a certain date (to be entered) AND fil... 29 Mar 2010 09:08
Module "CarryOver" from Mr. Allen Browne
I copies and followed the instructions and installed the module from the site below: http://allenbrowne.com/ser-24.html It is not working and hangs at the very first 'Dim' statement which is Dim rs As DAO.Recordset Am I expected the modify the code here and anywhere else in the module? Please help. Tha... 29 Mar 2010 02:36
IF statement in a query....
I am fairly new to using Access and I need some assistance in working with an expression.... Working with Access 2007 I have a table that has a column (Name) with several clients names in it and I would like to write an expression that isolates Bank of America and labels all other clients as "Misc". Example... 29 Mar 2010 00:28
columnA ColumnB ColumnC columnD 12345 23 78956 10.00 12345 23 89153 15.00 56780 23 15687 20.00 56780 23 15890 20.00 12345 23 78853 30.00 12345 23 87568 30.00 I am importing a table from an ... 27 Mar 2010 19:58
Running a stored parameter query from a form without pop up boxes.
I know that you can create a query with sSQL = some SQL statment me.recordsource = sSQL I have looked at other threads that have talked about using forms!myform!mycontrol as a parameter this is good but limits the query to one form. I remember that there was a way of calling a stored parameter with some... 29 Mar 2010 11:22
Hi, I have 2 tables, tbBaby and tbVaccineInjection. tbBaby stores the babies' personal data like Name, BirthDate etc., tbVaccine stores VaccineName, DoseNumber (1st, 2nd, 3rd, etc.) and InjectionDate, etc. These 2 tables are one to many in relation, because each baby may have several vaccinations on different ... 1 Apr 2010 09:03
I am kind of beating my head over this problem. I am trying to create a rule by where the user cannot enter data if todays date is greater than a function date - max time given in a query So lets say the user has 72 hrs to respond before an event date lets say Jan 1, 2010. I tried this so far but its not w... 26 Mar 2010 19:15