Subquery - 2 fields pulling from the same master field

T

Tim

This seems like it should be easy to do in one query rather than use
multiple queries, but I can't figure it out....

Data Source: TableX
FieldX is a number (amount) field.
FieldY is a date field

I'd like to create one query that displays FieldX, then another field
of FieldX where FieldY is between 1/1/04 and 12/31/04. Then another
where FieldY is in 2003.
So in this case I'd have 3 fields (plus any other data shown form
TableX), where the same data could show in more than one field if
FieldY is in one of the 2 years. Because the data would show in the
wide open version of FieldX as well as the filtered version of FieldX.

Thanks for any help / direction!
Tim
 
Top