We help IT Professionals succeed at work.

query problem

urjudo
urjudo asked
on
60 Views
Last Modified: 2019-01-29
Hi Experts,
Happy New Year!!!  I have a query question and do not know if this is possible to do, if it is then how?  I have a query that has two different fields, one is "case#" and other one is "File#", is any way I can combine this two fields into one field like an Expr field?  The reason I'm ask is because users need to enter either field to print out a same report, instead create two different queries,  I want to merge two fields into one field in one query, can anyone help?

Thanks
Comment
Watch Question

Dale FyeOwner, Dev-Soln LLC
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2010

Commented:
How about something like a parameter query:

Parameters [CaseOrFile] integer;
SELECT *
FROM yourTable
WHERE [Case#] = [CaseOrFile] OR [File#] = [CaseOrFile]

This would popup an inputbox when the user runs the query, and assumes that the values in the Case# and File# columns are numeric.

Author

Commented:
Sorry, I tried, it doesn't seem working.
Owner, Dev-Soln LLC
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2010
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
unfortunately, I just realized that I have to use two different query in my case, but thank you so much for your helped!!!
John TsioumprisSoftware & Systems Engineer
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
Can you give a sample along with some more info...
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.