Search results for query: *

When you modify the query that your report is based on. Use a parameter(specified in the criteria section of the query) you want to use are based on the values you have diplayed in your form. Example: This one is used to pass in date parameters for recrods that fall between to seperate dates...

SYNTAX CORRECTION, sorry. The below is the correct syntax for your date problem. =Max([Date]) Current Date =Max([Date])-1 Previous Date =Max([Date])-2 The day berore the previous day Remember that this can be done on the report text box it self under the control source property.

=Max([Date]) Current Date =Max([Date]-1)Previous Date =Max([Date]-2) The day berore the previous day You can just do this in the text box on your form or report. Right click on the field and use the expression builder.

Yes. It is the properties of the section of the report. IE page footer, report header whatever sections and groupings you have.

I have similar reports built and I am having issues with the performance of the reports. The queries seem to run good as well as the subreports but when you run the master report it dogs down to a slow standstill. If you here of anything please let me know. -Michael-

I have built a report that contains 3 uniques sub reports all link by a unique keys(Parent/Child). The report works as it should but it runs extremely slow. I run each query individually and they run very quick including each subreport but the master report takes forever to format and display...

Properties of the text box might be set to something. Try changing the format or type in the properties of the text box.

Try compacting and reparing the database. The database seems little large for access but if it used extensively then I guess not. Have a databse that is 24 megs that contains no data seems a bit much. There should no limits to the number of reports that access can handle.