Process to modify multiple queries simultaneously

  • Thread starter Thread starter Guitarzann
  • Start date Start date
G

Guitarzann

Greetings,

I have 10 DELETE queries set to remove data based on the MONTH field. The
month to be deleted is stored in the Criteria. My question is, is there a
query function where I can change the criteria each month for the 10 queries
in a single step instead of having to manually go into each query and reset
the month?

Thanks for your help!
 
You've described a "how" (10 DELETE queries, ...) but not "what" (what data
structure are you working with?).

By the way, a field named "MONTH" will likely cause Access to get confused
.... "Month" is a reserved word.

If you'll describe your data structure a bit further, and provide an
example, folks here may be able to offer more relevant suggestions.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Thank you gentlemen for your input.
Dale, I found an idea inside what you were saying. Being I already have
hundreds of combo box references already in my end user form I simply added
one to my Admin form where I was able to create a pointer in the Criteria
that references that Combo box.

Jeff, you lost me on data structure. Sorry. I am dangerous enough with
Access to break things yet naive enough not to know that it was broken. :)
 
Access is a relational database product. In a database, it all starts with
the data.

If you were working with a (grossly oversimplified) registration database,
your table structure might look something like:

tblStudent
StudentID
FName
LName
DOB
... (other student-specific info)

tblClass
ClassID
ClassTitle
ClassDescription

trelRegistration
RegistrationID
StudentID
ClassID
RegistrationDate
...

What's your data structure look like?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Back
Top