I am currently creating quries based on collector's name. for example:
qrySam, qryJane, qryBob. These are exported out to excel spreadsheet in
different tabs. Is there a way to somehow in code create queries based on
name so that if there are new names added to the main table, I wouldn't have
to create queries for each new name? any suggestions? I maybe be making it
harder than it should.
thank you!