Query to table

  • Thread starter Thread starter Guest
  • Start date Start date
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!
 
One way is to use one make-table query and two append queries for the other
fields.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Table Join Issue 3
PAYROLL PUZZLE - LOOKUP WITHHOLDING TAXES 2
Summing multiple input records into one output rcd query 2
How do I determine calendar quarters in Access ? 11
Number to Number "Data Type Mismatch in Expression" in Join 1
Have 4 Queries and need to combine results 3
Does not include the specified expression as part of an aggregatefunction 2
converting excel columns data 3

Back
Top