Patrick O'Dea
asked on
Referring to a form in sql but NOT by name
Hi,
I have a report called "rptShowCustomers" which is based on qry2014.
This report is called by TWO forms - "job1" and "job2"
See the SQL link below where I have hardcoded "job1" into my query.
http://screencast.com/t/N5xeKrwgUtf
Question: How do I remove the "job1" from the query so that it will work for both "job1" AND "job2".
(PS: I raised a query like this earlier but did not resolve it due to my mis-understanding)
I have a report called "rptShowCustomers" which is based on qry2014.
This report is called by TWO forms - "job1" and "job2"
See the SQL link below where I have hardcoded "job1" into my query.
http://screencast.com/t/N5xeKrwgUtf
Question: How do I remove the "job1" from the query so that it will work for both "job1" AND "job2".
(PS: I raised a query like this earlier but did not resolve it due to my mis-understanding)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Plenty to think about from Pat!
For the moment I opted for the neat solution from mbizup!