G
Guest
I have a query that sums payroll deductions entered into a table. Each item
is it's own field (i.e. FedTax, StateTax, ICMA) by payroll date. I want to
take the information from this query and append it into a new table where
there are 3 fields, Date, DeductionCode, Amount. All of the deductions (i.e.
FedTax, StateTax, ICMA) would then be listed with a date and amount.
I can't figure out how to take the multiple fields in the first query and
have them now all as one field named DeductionCode. Any help is appreciated!
is it's own field (i.e. FedTax, StateTax, ICMA) by payroll date. I want to
take the information from this query and append it into a new table where
there are 3 fields, Date, DeductionCode, Amount. All of the deductions (i.e.
FedTax, StateTax, ICMA) would then be listed with a date and amount.
I can't figure out how to take the multiple fields in the first query and
have them now all as one field named DeductionCode. Any help is appreciated!