Adding a second query to a report

[Guest]

Access2000
I've created a report where you enter the desired dates (based on a query
containing the hours, rates and exemptions) and it
calculates gross payroll .
I want to use the gross figure for each person to calculate a tax.
I created a second query (based on a tax table) that takes the gross and the
exemptions, finds the appropriate record and calculates the tax.
I can run the second query separately by entering parameters but I don't
know how to get the results into my report.
Any help would be appreciated.

 

[Arvin Meyer [MVP]]

After calculating totals in the first query, use it, just as you'd use a
table, to provide the gross figure data for the second query. Base your
report on the second query.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Access2000
I tried combining the two queries but I'm not getting the results I want and
thought I could reword my problem and see if that will lead me in another
direction.

I've created a report where I enter the desired dates worked for any given
period via a parameter. Its based on on a query containing the names, hours,
job, rates and exemptions, etc). When I run just my query I get a list of 59
records which is correct. The report subtotals for each person and for each
different job which is what I want and I end up with 8 paychecks
(subtotals). These subtotals are my gross payroll per person. I need to
look up the tax for each paycheck(subtotal) and print it out on the report.
I have a tax table that I need to use to look up this gross. The report
prints out just the way I need it two except for the tax.
This is where I get lost.
For example:
In the report the first subtotal yields a GROSS of $3000, MARITAL STATUS is
Single
A sample listing of the first 3 records of the tax table follows:

REC# MSTATUS FMINIMUM FMAXIMUM FPERCENT EXCESS
1 Single 0 2650
0 0
2 Single 2650 9700
10% 2650
3 Single 9700 30800
15% 9700

CRITERIA: MARITAL STATUS = MSTATUS AND GROSS IS BETWEEN FMINIMUM AND FMAXIMUM.
Nothing I've tried in the report gives me access to this table. I'm an
access novice so I'd appreciate any help. If I haven't provided enough info,
I'd be happy to provide more. I can't move forward at all.

Thanks