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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Try something like

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