MS Access database query

  • Thread starter Thread starter Henrietta
  • Start date Start date
H

Henrietta

In my database I have non-automatic reference numbers (entered manually).
How do I say in a query that I would like all the numbers NOT currently used?
Thanks in advance.
 
Henrietta

There are (at least) a couple ways to approach this.

One uses the query design window, one uses SQL.

Using the query design window, create a query that finds all the numbers
used. Then build a second query of the original table using the "unmatched"
query (wizard) against the first query.

The SQL approach uses an embedded sub-select.

I have more experience with the former, but maybe another poster could offer
more specifics on the sub-select approach...

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Brilliant !
I used your unmatched theory & it works. I made a "dummy" table with just
references listed on Excel & pasted appended into the new table. 1 query
based on the original data & a 2nd based on the dummy data, with the
unmatched query to pull them together. Works perfectly.
Thank you Jeff !
 
Henrietta

If you created an extra dummy table, you worked too hard!

You can use a query to find all the records in one set of data (e.g.,
Excel), then refer to that query in a second query.

Glad you found a workable solution, though!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Back
Top