Access 97.  
Table lists trailers associates worked on and how long it took each to work
the trailer.  There could be as many as 5 people working one trailer.  Thus
the table will have up to five records for each trailer.  I need to calculate

this is the my query:
Select "All Clients" as ClientName from Client
UNION SELECT Client.CLientName
FROM Client

Hello~
  I am building a form where a user should choose a category from a
dropdown menu populated from the "categories" table, and then a second
dropdown menu should appear if there are any subcategories available

I created a query with two tables but it does not allow me to change the data
in the spreadsheet.  I am not sure why?

I created a query to check for duplicate records so I could send the user a
message by way of a form I created.  The sql is:
SELECT [ALL Policies].CustomerNo, [ALL Policies].ApplicationNo, [ALL
Policies].Carrier

I have a text field in a table containing ID's.  The ID's look like this -
1234
R25466
RMA987456

I am new to this and appreciate any help that you can give me.  I have a
table that I need to get a total responsibility accounting for broken down by
Responsible party. The following SQL gives me the count of appeals by
responsibility:

We have multiple users using one Access database to log bugs. Sometimes after
I run some queries, a lot of records disappear when viewing the form.
However, I can see all the records are still in the table where all the data
restored. Compact&repair database doesn't help. To have ...

i have a db with employees and their traveling. the traveling table has a
departure and arrival date. All im trying to do is to make a query for
finding  all the employees which were on travelling at specific date. My
problem is that the arrival date and departure date appears ...

I'm using Sql 2000 and Access 2003.
I have a work order form with a check box. When the work order is completed
the user checks the box and moves to the next work order.
The problem I'm having is when the user checks the box the following error

I know I'm missing something obvious, but I need help.  I have calculated
fields msg1, msg2, and msg3.  I want msg3 to equal msg2 if it exists (ie, not
null or ""),  otherwise I want msg3 to equal msg1, regardless of its value.  
What's a nice way to do this?

I am under-going a college project that involves a supermarket
delivery system.
One of the fields in my tables looks up a date from another table.
However, when this value is looked up access seems to change the data

I HAVE FOUR FIELDS FIELD1,FIELD2,FIELD3,FIELD4 AS SHOWN BELOW
FIELD1    FIELD2    FIELD3    FIELD4
PRG    000000    003000    003000
PRO    002600        000030

I'm trying to run a query as part of a VBA procedure, and what I want
it to do is to grab the value for a parameter (the current month) from
another part of the procedure.  I clearly am missing something,
however.  Here's what I have:

I have an access table which I need to update the school names
The school codes(SchCode) are codes are consistent from year to year but the
school names(SchName) are spelled differently year to year.
Since I am doing reports with pivot tables I need to be sure the names are