datediff???

[wardy]

hello all,
would really appreciate some extra help with this,
many thanks,, the story is as follows,,,,,,,

hello all,
i have a very simple databse with two table in it,, both table share a lot of common information, including a primary key called jobcard number,, i want to know if there is a simple query i can run that will find any differences in the start date fields that are found in both tables
any help would be much appreciated
cheers
wardy
---------------------------------------------------------------------
Look at DateDiff function in the help for the time differences.

Thus for example in a new column in your query you can type:
DifferenceInDays: DateDiff("d",[Table 1 Name].[DateField Name], [Table 2 Name].[DateField Name])
--------------------------------------------------------------------
thank you DrSnuggles,
could you explain in idiot proof instructions?
do i enter the diffdate code in the criteria row of the select query? also, what do i need in the field and table rows? is it the table and filed i'm comparing the data against?
once again
many thanks

 

[Brianwarnock]

The query will have both tables joined on primary key.
Select the primary key into the first field of the query grid, I would select the datefield from both tables into fields 2 and 3 , then enter the difference etc as per Dr Snuggles into field 4

Brian