Expression help

  • Thread starter Thread starter KrispyData
  • Start date Start date
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?
 
Back
Top