I want to build a query that gives me a list of   TODAYS'S  orders where that
same customer has placed another order in the past 3 weeks.
I built 2 queries one that shows todays orders, and one that shows trailing
3 weeks orders.   I can't seem to figure out how to show only ...

I am trying to figure out the 2 simple formulas, but am drawing a blank.  I
need to find the total number of years/month/days from a start date to and
end date.  I need to have the yr.,mo.,day in one cell.  Does anyone know the
formula to do that?

I have data in an Access 2003 query that lists each month's sales for a year
for each customer.  When I run a crosstab query on this query, if there are
no sales for a particular month for a customer a null is returned.
Can I somehow force a zero into this field in the crosstab ...

Hi. I am a new user of Access 2003.
Here I have a problem. I have thought it for 2 days. So far I did not
sort it out.
The question is how to extract the nearst matched data from a table.

I would like my query to look at an employee table that has a value if the
employee is in or not. This query will clock an employee into a particular
job, but I want it to evaluate if the employee is in or not, if not in I want
the query to generate a message box that says he is ...

Okay!  Heres the deal.  I have tried both of these in my query criteria.  The
dates coming in are 10/01/2005 and 10/31/2005.  The results show 10/01/2005
to 10/30/2005.  I am missing 10/31/2005.  I have Access 2003.  Yes, I have
checked and the data is there in my database, it ...

I have a query that add lines into a table, but I want that this same query
also changes the data in the table when is necessary. Right now the query is
giving me a new line with the same id and the new data. The problem with that
is that I have calculation queries link to that ...

The problem that I am trying to solve is the following,
I have a query that is composed of two other querys.  One of these queries
shows data for the last 3 months, so the fields would look something like
this if the current month is november for example:

I built a date dialog box form interface to allow the customer to
select a date that is currently selected in the calendar control for
the start date and end date and the values are then passed to a query
field (install_date O when_discovered_date) using the strWhere that is

I am trying to create a new query using the Simple Query wizard.  When I
attempt to select a table, I get an error message that the On Got Focus
expression produced the following error:  The text you entered is not an item
in the list.

I have a report that is based of the a query.  The query is a combination of
15 other queries, which a main query that drives the others.  I set the
parameters in the main query.  
When I am running my report, I have to type the same parameter about 4 times

I have a rather involved append query that I need to run from a form's
Command Button on click event procedure.  The SQL statement has many string
expressions and the syntax is tough to get right using the DoCmd.RunSQL
Method.  

If I am running a Mke Table query (INSERT .... INTO), how can I add another
field to the resulting table and set its datatype to TRUE/FALSE?
I know you cant say (Field:) Contact:"" and change the format to True/False,
but this does not seem to work because you are not changing the ...

I have a crosstab query that has dates going across and times going down.
Is their a way to group the time going down into 2hr intervals or even 1 hr
intervals.
Any help would be great

I'm currently trying(?) to learn Access, and have hit a snag.  I have a
database made up for a furniture production company, and need to show only
the records for 3 fields in a query.  I have tried many times,
(unsuccessfully) to do this, so can anyone help?