Table Query
- From: Ryan Mcbee <RyanMcbee@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 29 Oct 2007 19:06:01 -0700
I have a table that has the following three fields and values that I am
trying to build a query on;
Column name-FEDERAL, FICA1, FICA2
Values- 1 , 100 , 200
2 , 300 , 400
How can I get a query to look like this?;
Column- TaxCode, Value
Values- FEDERAL , 1
FEDERAL, 2
FICA1, 100
FICA1, 300
FICA2, 200
FICA2, 400
I am doing this because I am trying to build a payroll report. The other
table that I am working with is structered like this.
Thanks,
Ryan
.
- Follow-Ups:
- Re: Table Query
- From: Russell Fields
- Re: Table Query
- Prev by Date: Re: Pulling data that could be in one of 2 tables
- Next by Date: Re: Table Query
- Previous by thread: Re: Select Formatted Text From Table
- Next by thread: Re: Table Query
- Index(es):