Thank you Duane. That was exactly what I was looking for. I was able to compare the master table to the table where the codes are already used and come up with codes available using the Unmatched Query Wizard. I then modified the query by adding an expression like this: Expr1: Rnd([MasterCode]) and then sorted the resulting table by Expr1. That Randomized my results, which I was looking for. Then on the report, I added a field to Zero Fill the MasterCode and that is the field that I printed out for the operator to have a page of available five digit codes.
It worked super, and I learned a few things in the process. Thanks again.
Jeanie
Palm Coast, FL
--- In AccessDevelopers@yahoogroups.com, Duane Hookom wrote:
>
> I think you can use the Unmatched query wizard to get the results you need.
>
> Duane Hookom MVP
> MS Access
> ________________________________
> > From: CaptJeanie@...
> >
> >
> > 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 (3) |
Please zip all files prior to uploading to Files section.
Tidak ada komentar:
Posting Komentar