Access prints more than 1page

[Mksmall]

In my report I have 6 columns of information that is totaled at the bottomed of the report. The report gets a date range from a form, so the totals will vary depending on the dates you select. The report will always be contained on one page. But when you open the report the total number of pages in the report is the same number that appears in my first column total. And Access wants to print that many if you print. The number of pages will change depending on the dates selected, so the total of the first column always equals the number of pages in the report. The pages are all the same except for the report header. I've checked properties on just about everything I can think of( the report, it's query, and table) to find how Access is picking up this number. The expression in this text box is a simple =Count. Does anyone know what might be causing this???

 

[redheadgeek]

Without seeing your code, if any I would have to say (not assume, you what they say about that) is that are you using a reserved word.

Please include your code if possible

Kris Maly
Di Graphics
800-4DECALS
kmaly@decalsinc.com

TV Repairman syndrome does exist!