Query to calculate if item is overdue

[anna76]

Hi all,
I am trying to work out a query for if an item is overdue, but seem to have some strange join errors as I either get not enough results or I get literally thousands too many! (Is this the cartesian product?)

I have attatched a sample db of it and tried to recreate the structure (in the real one I have approx 100,000 records for completed forms)

Query i have tried to do in query builder was
IF [formcomplete] = False (and)

[form number of days to complete] + [date of randomisation] =< now()

Any help or ideas would be much appreciated,
Anna

Using Access 2010

 

[jdraw]

Not all can open accdb.

You may get wider audience with mdb format.

 

[vbaInet]

Not all can open accdb.

You may get wider audience with mdb format.

On that note, here's how:

http://office.microsoft.com/en-us/a...se-to-an-earlier-file-format-HA010230822.aspx

 

[anna76]

Thanks for the info jdraw. Have tried to save it as an earlier version in mdb format

 

[Brianwarnock]

I got an error when opening the mdb
see attached

Brian