I think you can use the Unmatched query wizard to get the results you need.
Duane Hookom MVP
MS Access
________________________________
> From: CaptJeanie@aol.com
>
>
> Hi all,
>
> I need to compare two tables. One (Table A) is the set of gate codes
> already issued. The other (Table B) is the list of codes, both used and
> not used (not necessarily sequential). How do I compare the two and
> obtain a list of available codes that we can use to issue an available
> code to the next person needing a gate code?
>
> I'm sure there is a simple exclusion comparison that will give me what
> I need, but I can't figure it out.
>
> I am sure that I can go to Table B and create a field that notes when
> the code is used, then query that table to exclude those, but is there
> a direct comparison option? We'd like to be able to just have the next
> gate code that is available show up on a form, or auto-fill.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Please zip all files prior to uploading to Files section.
Tidak ada komentar:
Posting Komentar