Search results

The strSQL contains (from the immediate window): [inID] = "D4 Rec" But, this can contain loads of different things, as the criteria builder is used for lots of different reports. I am trying to get this to run with the simplest criteria first.

That is a typo I made as I typed on here, in the code it was correct lol I am learning to type so try to type as much as possible instead of copy/pasting :D

So on my form where I click to open the report - all the form does is allow me to select which report I want to open and select criteria - I add the following in the preview button routine: Reports![rptStatusDetailed]![rptStatusDetailed_Sub].Report.Filter = strSQL...

Sorry if I sound really stupid, but, I am very new to all this and really appreciate your help. I don't know how to set the filter on the sub report to the SQL from my button click code. Basically the button just sets the SQL string, and then displays the report, but, I don't know how to get...

Well, putting a subreport and not allowing it to grow almost works, the only problem is I use SQL to open the report based on selections on my reporting form. I use: DoCmd.OpenReport strReport, acViewPreview, , strSQL How can I get it to apply the SQL to the subreport? If I can get it to...

Sorry if I didn't explain clearly, but, as stated in my previous reply, there are calculations on the report based on the details in the query. So if I limit the query to the top 10 records it will only use those for the calculations on the report e.g. I have a field on a report that counts the...

Hi, I can't limit the number of records that come from the query because there are calculations on the report based on the whole of the query. i.e. count of records based on certain criteria. I had assumed - perhaps wrongly :confused: - there may be some code that will prevent other pages from...

Hi there, please can anyone tell me, if it is possible, how to limit my access report to to only show the first page. Many thanks.