Exract Records with Nul value

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

Guest

I need a report to pull out records from a table that have not had and entry
recorded against them in a certain date range ie from 1st May to 30th June
show only blade numbers with no record for that time period.

Fiona
 
Presumably you have 2 tables:
- a Blade table, with a unique BladeID primary key.
- the table you describe, that may or may not have had an entry for a
particular BladeID in May/June.
We will call this one Table2.
So, Table2 has a BladeID field that related to the BladeID of your Blade
table.

If that's the idea, you can create a query using Table2, selecting the
distinct BladeIDs that do have an entry in the date range. Something like
this:
SELECT DISTINCT BladeID
FROM Table2
WHERE EntryDate Between #5/1/2007# And #6/30/2007#;

Save that query. Then use the Unmatched Query wizard to identify the records
in the Blade table that have no match in this query.

If you want to do it all in a single query, you could do that with a
subquery. For details, see:
Subquery Basics: Identifying what is NOT there
at:
http://allenbrowne.com/subquery-01.html#NotThere
 
Back
Top