query problem
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
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
Last Comment
ASKER
Sorry, I tried, it doesn't seem working.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
unfortunately, I just realized that I have to use two different query in my case, but thank you so much for your helped!!!
Can you give a sample along with some more info...
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
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.