This is my code. I am getting this error message: The data type of an operand of an arithmetic function or operation "+" is invalid.

SELECT ...

Two of the four datasets I want to combine have two fields, the other two have one field.

It didn't take long. Next question already. Is this limited to the two datasets or can I do multiple? I have four datasets I'd like to combine...

Okay, I inserted the full queries into the brackets and it worked. I'm now gettting to total I need. I'm sure I'll have more questions. Sorry for...

I type my query names into the parentheses then click on Query Designer and it automatically changes it to this:

SELECT *

FROM ...

I'm not getting it to work. I'm getting an error that the name of my query is undefined.

This is my dilemna. The first dataset which I use for the report is doing a count of the ACCIDENT_NO based on a cirumstance. So, there could be...

What field would I join on? There are multiple fields in the first dataset and only one field in the second dataset.