Hi everyone,
So I've used this syntax before on many union queries and it has worked. Yet for some reason it now refuses to work on my new queries.
I know that some of you will be annoying with my naming conventions for this (but unless that is where the problem actually lies, you don't need to tell me). I can't find anything wrong with what I have here, so I'm not sure where to go with it. Though they appear to be the same, they are actually very different tables with some common information. What I need is to be able to sum the two sets of data so that I have values based on:
Employee-Jobtype-month- with all other values being summed.
Select [Employee], [fldMonth], [fldYear], [Jobtype], [fldHours], [Overtime], [labour], [Overtime Pay], [Call Out Pay], [Standby Pay], [Total Pay]
from qryAll1/2
UNION Select [Employee], [fldMonth], [fldYear], [Job], [fldHours], [Overtime], [labour], [Overtime Pay], [Call Out Pay], [Standby Pay], [Total Pay]
from qryAll1/3;
Hope this makes sense.
Thanks,
ConfusedA
So I've used this syntax before on many union queries and it has worked. Yet for some reason it now refuses to work on my new queries.
I know that some of you will be annoying with my naming conventions for this (but unless that is where the problem actually lies, you don't need to tell me). I can't find anything wrong with what I have here, so I'm not sure where to go with it. Though they appear to be the same, they are actually very different tables with some common information. What I need is to be able to sum the two sets of data so that I have values based on:
Employee-Jobtype-month- with all other values being summed.
Select [Employee], [fldMonth], [fldYear], [Jobtype], [fldHours], [Overtime], [labour], [Overtime Pay], [Call Out Pay], [Standby Pay], [Total Pay]
from qryAll1/2
UNION Select [Employee], [fldMonth], [fldYear], [Job], [fldHours], [Overtime], [labour], [Overtime Pay], [Call Out Pay], [Standby Pay], [Total Pay]
from qryAll1/3;
Hope this makes sense.
Thanks,
ConfusedA