Expression help

K

KrispyData

I’m trying to combine two fields from a table using query in access
Example:
FY Q
2009 4


Expression: FY & Q
Result: 20094
I want the result to be: 200904

I can’t update the design of the table bc I don’t have access to the linked
source
How can I get the result I need?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top