Fill out report based on rank from query

N

NeoFax

I have a query:

SELECT a.workorderNum, a.workorderName, a.workorderMaterial,
a.workorderSerialNum, a.workorderComponent, a.ProductName,
a.Discrepancy, a.dateDisc, a.qualCNumber, a.qualFName, a.qualLName,
a.qualRole, (SELECT COUNT(*) FROM qryDiscrepancies AS b WHERE
b.workorderNum=a.workorderNum AND b.discID <= a.discID) AS
discrepancyNum, a.discID
FROM qryDiscrepancies AS a
GROUP BY a.workorderNum, a.workorderName, a.workorderMaterial,
a.workorderSerialNum, a.workorderComponent, a.ProductName,
a.Discrepancy, a.dateDisc, a.qualCNumber, a.qualFName, a.qualLName,
a.qualRole, a.discID;

That places a "rank" on the quality discrepancies found during
production of material. I need to place the discrepancies in order on
the report like so:

Disc# Discrepancy Corrective Action QCInsp Disc# Discrepancy
Corrective Action QCInsp
1 BlahBlahBlah More Blah Blank 5
BlahBlahBlah MoreBlah Blank
BlahBlahBlah More Blah Blank
BlahBlahBlah MoreBlah Blank
BlahBlahBlah More Blah Blank
BlahBlahBlah MoreBlah Blank
Disc# Discrepancy Corrective Action QCInsp Disc# Discrepancy
Corrective Action QCInsp
2 BlahBlahBlah More Blah Blank 6
BlahBlahBlah MoreBlah Blank
BlahBlahBlah More Blah Blank
BlahBlahBlah MoreBlah Blank
BlahBlahBlah More Blah Blank
BlahBlahBlah MoreBlah Blank
Disc# Discrepancy Corrective Action QCInsp Disc# Discrepancy
Corrective Action QCInsp
3 BlahBlahBlah More Blah Blank 7
BlahBlahBlah MoreBlah Blank
BlahBlahBlah More Blah Blank
BlahBlahBlah MoreBlah Blank
BlahBlahBlah More Blah Blank
BlahBlahBlah MoreBlah Blank
Disc# Discrepancy Corrective Action QCInsp Disc# Discrepancy
Corrective Action QCInsp
4 BlahBlahBlah More Blah Blank 8
BlahBlahBlah MoreBlah Blank
BlahBlahBlah More Blah Blank
BlahBlahBlah MoreBlah Blank
BlahBlahBlah More Blah Blank
BlahBlahBlah MoreBlah Blank

I cannot get the report to place the info in the blocks in this
format. I either get 1 page per discrepancy, or a subreport that has
1-8 on the left, with the right side blank. How would I go about
putting this info in the desired format? Second, if there are not
enough discrepancies to make 8, how do I generate enough blank blocks
to make 8? Third, if I have more than 8, how do I place the remainder
on a second and subsequent pages?
 

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

VBA Function to fill report text box 7
Group Discussion Fielded 3
Report based on query shows no data 1
How keep blank non-existent records from appearing in sub-report? 1
Specialized Column Breaks 2
Macro for form for collecting report parameters 21
Preventing blank fields from printing on report 1
Report creates a blank page when printing a long memo field 1

Top