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?
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?