My task is to identify duplicate records in 2 tables that each located in
different Access database. These tables have exactly the same structure. My
immediate solution is to create two datasets from each table and loop
through one and compare it with another one, but I'm sure ...

In a query, how can you calculate the difference between 2 dates (Date1 and
Date2) but exclude weekends.
I am trying to return the number of working days between 2 dates.
I know DateDiff only works for all days and includes weekends.

I want to run a query from code to count matching records in a table.
How can I achieve this?
I then want to use this same code again within an IF statement, so IF the
count generated by the query is > than xyz then do something else do

I have an Access 2000 stored query that I am trying to set criteria for in
VBA before running. I know I can create the whole query and criteria in VBA
using SQL statements but because of the number of fields involved I'm hoping
I can do this by making it a stored query instead. ...

the following SQL is obvisouly not working I simply wrote for viewing
What I want is for to generate a crosstab based on StartDate and EndDate (at
runtime)
so for example if a person enter 5/10/04(StartDate) and 6/10/05(EndDate) it

pls help me answer this question.

I have two fields, one called OrdDate and another ShippedDate.  I want to
retrieve data from date ordered to 10 days after the ship date.

<=[ShippedDate] in the criteria field under ShippedDate

Anyone can tell me how to append a query to another query?
Thanks in advance.
Kennykee

Can i append lookup field?
I try to append lookup field but error on key violations
Any solutions or alternative for this method?
Thanks in advance

I've got a table linked to Excel where every three consecutive columns are for a
specific calendar month, ie. F4, F5 & F6 are for July, F7 to F9 represent August
etc etc. I'm setting this up for the next f/y and thought it'd be cute to be
able to automatically pull stats out of ...

I have an Access 2003 (Cross-Tab) Query result I need to send within an
(Outlook or OE) email BODY.
The DoCmd.SendObject will only export it as an attachment and I don't want
to use an html template (not too sure if that works either!).

I am having trouble creating a join between a one-to-many-to-one table
structure.  I thought it was possible, but I just cannot figure out what to
do.
Table A - many

To the group:
When I run the following delete query:
DELETE tblStrJobs.*, tblServiceJunction.OrderNum
FROM tblServiceJunction RIGHT JOIN tblStrJobs ON tblServiceJunction.OrderNum

I have a list of hours flown by different pilots, and what I need is to do a
query that shows me the last time a pilot flew.  Such as below:
A1234     3/2/2005
A1234     3/30/2005

Wondering if anyone knows how to do a date difference calc from a table that
looks like the following:
Date                   PurchaseName
28/01/2005          John