I have two tables, ProjectLog and OrderHeader.  There are address
fields in both and I need to update the address fields in ProjectLog
where they are blank with the data held in OrderHeader.  There is one
record per Project in ProjectLog and potentially multiple OrderHeader

I have a form where 9 different names (there are over 150 names) are entered
into 1 record.  Each name would have a date and a memo box associtated with
it.   Each name is associated with a different team (there are over 20
teams).  I would like to have a query where you would be ...

Thank you for looking at my question,
I have created a crosstab query with a date row.  I would like to make a
“between” statement in the criteria but every time I run it it tells me “The
Microsoft Jet database engine does not recognize ‘[Enter Start Date]’ as a

I have multiple records per client in my table and would like to reduce it to
ONE record per client.  However, I would like to capture information from
each of the records.  
For example:

I have two queries and I need to combine all the data in one query with all
the data in the other query.  Query 1 is qrySalesPreviousPeriod.  Query 2 is
qrySalesCurrentPeriod.  The queries are joined by CustomerCode.  The query
joined by CustomerCode only returns data for those ...

NEED TO DISPLAY stdid AND TOPPER IF TOPPER (upper case)IN CLASS(Q1)
and topper in any 1 subject(Q2)   ELSE IT SHOULD DISPLAY( lower case)
topper and id

Good afternoon-
I am trying to create a report that is based upon several tables.  In the
main table, tblMain, I have the following fields:
MainID  

I am trying to sort an MS Access 2003 database with a text field:
ApproxDTE with entries like
5-72
8-58

Hi Folks - I am tracking criminal cases. Each case has two combo-box
disposition fields: DISP1 and DISP2. Both dispositions "lookup" the same
list of dispositions, such as guilty, not guilty, waived and dismissed. I
need to run a report that counts the COMBINED values of both ...

This is what I have:
Table1 contains two fields for Team names and players last names. There are
3 different fields for last names (LN1, LN2 and LN3). Not all of them are
filled (a team only has two members).

I posted this before and thought I had a solution. Unfortunately, it became
too large and I received a "Query is too complex" error, so now I'd like to
try a different approach...
I have created a Union Query to consolidate results from separate queries,

I'm trying to create a query for a report that will answer a parameter, but,
I want the user to be able to select the parameter criteria from a dropdown
instead of entering the information in each of the parameter windows.  Can
this be done?

Good morning,
I have a graph that runs from a query. Recipients of a group wanted data
shown in weeks so I entered:
Week No: (Format([DateIR],"ww""  '""yy"))

Wonder if anyone can help. Need to write a queryto pull out 7 random records
from a table, sounds easy but is it?
Many thanks

Have the following fields in a table: Date,Name,JobNo,Hours.
I need a SQL query to count the number of days each Name appears over a
period of days.
Any Name can appear more than once on any Date.