Creating a query on things that are not there.......

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jurrasicway - 22 May 2006 13:44 GMT

I want to produce a set of results on where there is no data between two dates.
I use a database to record visits to locations, but I want to know what
locations have not been visited between two dates. The query I use now has
two peramiters, [Start Date] and [End Date]. This produces a list of visits
in the date field for that period. Each location has a number called
[UnitNumber]. I need to know the unit numbers that have not been visited.

Can anyone help?

Graeme.

Reply to this Message

Ofer Cohen - 22 May 2006 14:58 GMT

Try something like

Select * From TaleName Where UnitNumber Not In(Select UnitNumber From
TableName Where DateFieldName Between [Start Date] and [End Date])

Signature

Good Luck
BS"D

> I want to produce a set of results on where there is no data between two dates.
> I use a database to record visits to locations, but I want to know what
[quoted text clipped - 6 lines]
>
> Graeme.

Reply to this Message