M
mark r
JOHN,
I HOPE YOU WILL RESPOND AS YOUR LAST ADVICE WORKED GREAT AND I WAS ABLE TO
UNDERSTAND YOUR STYLE OF EXPlANATION.
I have a query now that outputs the records I am interested in. However,
the query will not let me update any of the fields. Specifically, I wish to
"mark TRE" the PRINTFLAG field so that I can run a report and print of only
the records I am interested in.
I assume there is no way to allow me to just point and click. So, perhaps
there is a way i could write another query which will eliminate duplicate
records from my output file. One way might be to select the first record from
any duplicated last names.
Another approach I thought of was to use SET in an currentdb.Execute
where somehow I match the lastnames of the query output to the original
source table and SET printflag to TRUE on Match . However, the wource table
is keyed on IDfield and my query "duplicates " are identified by lastname.
printflag lastname dateofappointment
alton 11/01/2007
alton 03/02/2007
alton 05/01/2006
I want to print only one of these into a label using REPORT.
I cannot seem to click on printflag. I donot know of a filter or query
function
FIRST.
please reference your previews reply on how to do a MATCH using Join.
I HOPE YOU WILL RESPOND AS YOUR LAST ADVICE WORKED GREAT AND I WAS ABLE TO
UNDERSTAND YOUR STYLE OF EXPlANATION.
I have a query now that outputs the records I am interested in. However,
the query will not let me update any of the fields. Specifically, I wish to
"mark TRE" the PRINTFLAG field so that I can run a report and print of only
the records I am interested in.
I assume there is no way to allow me to just point and click. So, perhaps
there is a way i could write another query which will eliminate duplicate
records from my output file. One way might be to select the first record from
any duplicated last names.
Another approach I thought of was to use SET in an currentdb.Execute
where somehow I match the lastnames of the query output to the original
source table and SET printflag to TRUE on Match . However, the wource table
is keyed on IDfield and my query "duplicates " are identified by lastname.
printflag lastname dateofappointment
alton 11/01/2007
alton 03/02/2007
alton 05/01/2006
I want to print only one of these into a label using REPORT.
I cannot seem to click on printflag. I donot know of a filter or query
function
FIRST.
please reference your previews reply on how to do a MATCH using Join.