Help with report with query using subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two tables, created a form using one table called tblCost, the other
call tlbRequisition. I am trying to use the form for the entry, and print a
report of that single record. The report is formated like our requisition at
work, and there may be multible descpitions, quanity, unit of measures, cost
and totals. These fields are in my tblCost and are also my subform fields. I
have linked the two tables by a field in both called PO. I have created a
query qreCost with all the information I need for the report, and when I try
to set it up, it keeps coming up with indivudal records rather than all the
the "subform" appearing one on record with the same Requisition information.
Example: on one report I would like to have the Name of the requester, the
Unit ID Number, and in the body the Quanity, Description, Unit of Measure,
cost and the Total. For the same requisition number there may be 3 or 4 items
requested for one Init ID number. When I try this I get the duplicate
information as single records. So the form shows I have 6 records, yet the
report prints out 8 records because 2 have multiple items in teh Description,
Quanity, So on and so fourth. Hoep some one can straighten me out. Thanks
 
Mike said:
I have two tables, created a form using one table called tblCost, the other
call tlbRequisition. I am trying to use the form for the entry, and print a
report of that single record. The report is formated like our requisition at
work, and there may be multible descpitions, quanity, unit of measures, cost
and totals. These fields are in my tblCost and are also my subform fields. I
have linked the two tables by a field in both called PO. I have created a
query qreCost with all the information I need for the report, and when I try
to set it up, it keeps coming up with indivudal records rather than all the
the "subform" appearing one on record with the same Requisition information.
Example: on one report I would like to have the Name of the requester, the
Unit ID Number, and in the body the Quanity, Description, Unit of Measure,
cost and the Total. For the same requisition number there may be 3 or 4 items
requested for one Init ID number. When I try this I get the duplicate
information as single records. So the form shows I have 6 records, yet the
report prints out 8 records because 2 have multiple items in teh Description,
Quanity, So on and so fourth. Hoep some one can straighten me out. Thanks
Click to expand...


Use the report's design view to specify how you want the
report's data records to be grouped (View menu - Sorting and
Grouping).

I think you want to group on the unit ID number field, with
Yes for the group header and footer sections. Place the
unit specific text boxes in the group header section and put
any totals text boxes in the group footer section.

I don't understand what you are saying about multiple
descriptions, so if the above is not sufficient, post back
with more details about that data and how it's supposed to
appear in the report.
 
Actually, what I'm trying to do, it as if you where printing an invoice from
a store.
All the data on top, Name address, and invoice number are on the top of the
report.
Yet in the middle of the report I need the Descriprtion of what was
purchased with the description of the items and the number of them the unit
price and the total of that one purchase on the same line. If there was any
other purchase per that invoice number they would also appear under the first
descpittion...
 
Just to be clear, is this roughly the format you are looking for?

Acme Plumbing Supply

SOLD TO:
John Doe
Street
City, State
Invoice 02332
Date 1/1/06
___________________________________
Item Qty Price
Kohler Toilet 1 $129.50
Kohler Pedestal 1 $99.00
____________________________________
Subtotal $238.50
Sales Tax $14.00
Total Sale $252.50

You know the saying: sometimes a picture ........
 
Mike said:
Actually, what I'm trying to do, it as if you where printing an invoice from
a store.
All the data on top, Name address, and invoice number are on the top of the
report.
Yet in the middle of the report I need the Descriprtion of what was
purchased with the description of the items and the number of them the unit
price and the total of that one purchase on the same line. If there was any
other purchase per that invoice number they would also appear under the first
descpittion...
Click to expand...


Sorry, but I still don't understand what problem you are
trying to deal with.

If it's just that some descriptions are too long to fit on
one line, then try setting the description text box's
CanGrow property to Yes.
 
Yes I'm sorry for not explaining it futher.
When I look at this report when it is created it looks like this. And this
is sort of the way I need it ot look, but I need it more space between the
values.


Department of Blagh, Blagh
Requisition Request
Name: Fred Mertz Unit MIS 054546

Quanity Description Unit of Measure Cost
Total
160 HP/CPI Consulting hrs
$113.75 $18,200
160 Consulting Network Expansion hrs $95.00
$15,200







Total $33,400

Possible Vendor: HP

Approved :

Unit Supervisor:_______________________ Date:___/___/___


I hope this helps. Thanks in advance.
 
Hi Mike,

ok, I'd do this with a main report and subreport. But since I don't know
anything about the structure of your tables, etc., I'll have to be very
general.

The record source for the main form only needs to pull only info like
Requester name, company, Requisition Num and/or unique ID for the
requisition (if not Requisition Num). All of the Requisition details would
go into your subreport.

subreport record source would be a totals query based on your requisition
detail table. make sure you include the foreign key to your main requisition
table

set your Master/child links the same as you would for form/subform.

Total dollar sum for the entire requisition, along with signature line and
date, you'd place in the page footer of the main report.

Is this what you are after? Post back with pertinent table and/or query
structures if you need a more involved response.

Brian
 
Back
Top