C
Cary Bishop
My question is can wildcards be used in the parameter of a query. I have
tried using wildcards but have had no luck.
I have a form which uses queries to populate three controls, cboState,
cboCounty, and cboJurisdiction. These controls must be filled out in the
order stated. The problem is that some jurisdictions send out bills that do
not refer to the county they are situated in. I thought that I could create
a query that users could call from the form to find the county that the
jurisdiction was in by using wildcards. In my tblJurisdictions I refer to
countys as XXX County or YYY County, all other jurisdictions are City of AAA
or Village of BBB. Was it a mistake to not have a field in my table such as
jurisdiction type and should I add it now.
Thanks
Cary
tried using wildcards but have had no luck.
I have a form which uses queries to populate three controls, cboState,
cboCounty, and cboJurisdiction. These controls must be filled out in the
order stated. The problem is that some jurisdictions send out bills that do
not refer to the county they are situated in. I thought that I could create
a query that users could call from the form to find the county that the
jurisdiction was in by using wildcards. In my tblJurisdictions I refer to
countys as XXX County or YYY County, all other jurisdictions are City of AAA
or Village of BBB. Was it a mistake to not have a field in my table such as
jurisdiction type and should I add it now.
Thanks
Cary