What do I need?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Ok,

I don't really know how to accomplish what i want.

I have a query that returns results based on an audit.

The query returns results of the last three audits in a form Like this
AUDIT REP Primary # Date COMPLETED
Chuck 82690 9/22/2005
Susan 82690 10/19/2006
Bill 82690 9/22/2005

Audit Rep = The name of the auditor that did the audit
Primary # = is the number of the place where the audit took place
Date completed = When the audit was done

Now what i want to do is,
I want some code that makes variable1 = Chuck (auditrep of the
first record of that query)
variable2 = Susan
(auditrep of the Second record of that query)
variable3 = Bill
(auditrep of the third record of that query)

I need this because i need to send a new audit rep that has not been
there one of the
last 3 times. I want to then run another query That schudles a UNIQUE
audit rep that has not been used in one of the last 3 audits

Hence i will not be able to send Chuck, Susan or Bill to the place with
Primary # 82690

.

Relevant Pages

  • Re: Populating a text box from query results
    ... We do an audit process of every area so there are numerous audits ... I also have a query called qrySection that calculates the average of each ... I can't seem to figure out how to get the values of avgSection1, ...
    (microsoft.public.access.forms)
  • Re: What do I need?
    ... I have a query that returns results based on an audit. ... I want some code that makes variable1 = Chuck (auditrep of the ...
    (microsoft.public.access.queries)
  • RE: Random selection - multiple criteria
    ... tremendous amount of work to the audit. ... "KARL DEWEY" wrote: ... Then the next query -- ... I have a query that I am using to generate a random selection of customer ...
    (microsoft.public.access.queries)
  • Re: Form Result Source ->Query/Table (Or)
    ... is stored in the tag property for a form based on a query ... field I need to store as part of the audit trail. ... >i think the best is to store primary key fields name also ...
    (microsoft.public.access.modulesdaovba)
  • Re: Determining if a form has a table or query recordset source
    ... Not just any query. ... used the Products Table as the .RecordSource property. ... how to obtain the primary key of a query? ... >> I have an audit routine that monitors all user activity ...
    (microsoft.public.access.security)