Hi All,
I have just registered so hope to become a bit of a regular on here as it seems like a great resource!
I am wondering if someone can help me out with the below.
I have a query which uses fields from multiple other queries. These columns are all made up of queries
Paid1 OS1 Paid2 OS2
Example column names in the query:
Key Paid1 OS1 Paid2 OS2 Total_Paid Total_OS Total_Total
Formula in each total column is as follows
Total_paid: [Paid1] + [Paid2]
Total_OS: [OS1] + [OS2]
Total_Total: [Total_Paid] + [Total_OS]
Example of what each field should show in a row when query is ran
Key Paid1 OS1 Paid2 OS2 Total_Paid Total_OS Total_Total 1 100 900 1500 500 1600 1400 3000 2 250 0 55 0 305 0 305
Example of what each field is actually showing!!
It seems to be concatenating the total_paid and total_os columns instead of adding them
Key Paid1 OS1 Paid2 OS2 Total_Paid Total_OS Total_Total 1 100 900 1500 500 1600 1400 16001400 2 250 0 55 0 305 0 3050
Any ideas why this would be happening?