 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / January 2006Help with report with query using subform
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 >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 [quoted text clipped - 12 lines] >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 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.  SignatureMarsh MVP [MS Access] 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... > >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 [quoted text clipped - 26 lines] > with more details about that data and how it's supposed to > appear in the report. 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 ........ 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. > Just to be clear, is this roughly the format you are looking for? > [quoted text clipped - 16 lines] > > You know the saying: sometimes a picture ........ 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 >Actually, what I'm trying to do, it as if you where printing an invoice from >a store. [quoted text clipped - 5 lines] >other purchase per that invoice number they would also appear under the first >descpittion... 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. SignatureMarsh MVP [MS Access] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.