Recent content by hascet

JHB, The report in question is called rptProposalItems and the record source is qryProposalReportItems. If you look at the database, you'll see the sample data. There are two different records and they should have different sales prices, but for some reason both records show the same sales...

I think I'm understanding you, in the record source query I created a new expression called 'Price' which calculates the same value as the 'Sales Price' field. I placed the 'Price' expression on my report and it calculates the value I want, but still the value for 'Price' is the same for every...

JHB, Thanks fro the quick reply. I have tried that, attached below is my attempt at including the calculation in my report source query. I am getting the same result as when the control source is set to reference the subform field.

I have been trying to figure out why my subreport is only showing sales price for only one of the records on my subform. Everything else works as it should, but it only displays the sales price for the record which is active on the subform. Attached is the database with the subreport called...

Ah, got it! My record source query for the main report had a relationship in it to my subreport record source table. Once I removed that relationship the report operates as I want it to!

Hello, I have a form which has a sub form data sheet on it. On my report I have a sub report which contains the data sheet information. For some reason my report is generating a report for each record in my sub data sheet report. For example, let's say my report is 1 page. If I have one record...