I need to know if it is possible to use the content of a single record in a table as the criteria for a query.
Here's what I got. The database is a reporting database for an older version of remedy. The reporting database is an Access 2000 database.
The table containing the data for the query is tblDefault1stLevelSupportGroup
The table has the following fields
strDefault1stLevelSupportGroup - Support Group Name
strQueryOptions - These are the 1st set of options that I need as criteria for downloading data from the remedy database. This includes variations on the name of the Support Group name. Example (Like "psw it" or Like "PSW IT" or like "pswit"
strTechNames - These are the names of the technican's in the Support group. I also want to use these as criteria in querys.
I have another table with the all of the support groups in it. I use this table to seed the tblDefault1stLevelSupportGroup table via a form and update query.
The tblDefault1stLevelSupportGroup table only has the 1 record that gets updated when the user changes the support group via a form.
I have tried to reference the field containing the record in a query but it returns nothing.
If there is another way to do this let me know. I am not that familiar with vba coding. If you have a suggestion that requires coding please be very detailed and include the code, please.
Thanks in advance!
Here's what I got. The database is a reporting database for an older version of remedy. The reporting database is an Access 2000 database.
The table containing the data for the query is tblDefault1stLevelSupportGroup
The table has the following fields
strDefault1stLevelSupportGroup - Support Group Name
strQueryOptions - These are the 1st set of options that I need as criteria for downloading data from the remedy database. This includes variations on the name of the Support Group name. Example (Like "psw it" or Like "PSW IT" or like "pswit"
strTechNames - These are the names of the technican's in the Support group. I also want to use these as criteria in querys.
I have another table with the all of the support groups in it. I use this table to seed the tblDefault1stLevelSupportGroup table via a form and update query.
The tblDefault1stLevelSupportGroup table only has the 1 record that gets updated when the user changes the support group via a form.
I have tried to reference the field containing the record in a query but it returns nothing.
If there is another way to do this let me know. I am not that familiar with vba coding. If you have a suggestion that requires coding please be very detailed and include the code, please.
Thanks in advance!
