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

Yes, you can...but the data will not be relevant unless your tables are linked somehow...

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