I have 9 fields in one table - key1, key2,key3 etc up to key9. I need to create a search that will search ALL these fields via the user entering a word and...

I have a table: idex name codequestion mark 1 A MS_HR_RI1 40 2 A MS_HR_RI2 20 3 A MS_HR_RI3 ...

Hello. How can I sum a total of hours. I'm having this problem. When the total of hours cross 24h it restart, like it was passing to another day. Exemple:...

Hi I have two tables. Table 1 has say HHID 1 to 1000 (1000 rows) and different fields. Table 2 has only intermittent HHIDs say 456, 12, 23..and 100 such HHID...

I Have a Hire Dates Table, and to keep things simple, the car has hire dates booked between 01/01/07 to 10/01/07 and another between 20/01/07 to 30/01/07....

Hi this is a repost actually. I'm not sure if this can be done in a query by creating a function first. Here's an example: I need to find NICKJM in the...

I have a field in my database that i built the expression to divide by 2 other fields to give me my answer. The only problem i am having is that it will NOT...

I'm trying to use a select query to select matching information on a subform within a form, and can't seem to get it just right. An example of my query is...

Hello: I have been helping someone with a database. I am stumped and would like some suggestions on what to try next to solve a stubborn problem. The...

Help, I have a card scanner that will create an Access database with the table called Contacts, I need to append / insert this information into my...

I am trying to identify whenever x (in this case 5) sequential values in a field occur in a table and write these values to another table in the same...

Counting 1 total of 4 fields (not summing). I’m not sure how to set up the SQL for the query I need. I have 2 tables: 1. including fields: Size,...

I have a table named tblBatchHeader with a primary key called idsBatchHeaderID. It is linked to the primary key lngzBatchHeaderID in eight other tables named...

I have a table named "Employee" whih lists all our employee's names, their department (Transportation, Maintenance, Dispatchers, etc.), and their Titles...

I am having a problem with using Duane Hookom's concatenation method for combining records and displaying them on separate lines. It appears that too many...

Okay, I have a table that contains the number of leads recieved by day. I need a query that will display the daily leads as a percentage of the total number...

Can anyone tell me if it is possible to use the top value (which is available on the menu in design view of the menu) and be able to enter it as a parameter...

Hi, I have a field in my database that is Date/Time. I want to return all records with a time value after 4:30 pm, grouped by date. Any ideas on how to do...

Kinda of new sor sorry for my term., but is there a way to dictate the sort order within a field. Example I have a several fund #'s 01, 02, 33, 34, 35, 90...

Hopefully the last time I will have to bug everyone! Within the BMP database I am working on, I am trying to find a way to calculate the next inspection date...