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 (1) |
Please zip all files prior to uploading to Files section.
.
__,_._,___
Tidak ada komentar:
Posting Komentar