Blank Spaces in Report

[camaroltd82]

I know this is very simple, but I am new to the program. I have an Access 97 database with three four reports that will be used on a regular basis. One of these reports is named "Count Sheets" It is a item by item listing of all the items in the storeroom. My problem is, at the beginning of the report, I get about 10 blank lines.. I know this is because there are 10 records that do not have any of the fields that I am displaying, but I don't know how to fix it. Thanks

Also.... I have to create a report that will tell me the total value of all the items in the storeroom.... sorted into respected categories. I don't even see an addition type function in a report, so how is this possible? I am trying to improve on the old program (Works 3.0) but am unfortunately having a difficult time doing it.

 

[ColinEssex]

Is the report based on a query?

Col

 

[camaroltd82]

No, it is based directly from my table... Should I be using a base query to make it? Thanks

Mike

 

[ColinEssex]

If you base it on a query you can add the criteria
Is Not Null

to the offending field that gives you blanks. Then you'll only get records where the field has data in it.

Col

 

[gblack]

try this

Go into the properties of your detail section and each of the properties of your field boxes and set the can shrink properties to yes.

Make sure they all can shrink and the blank lines should disappear from your report. However if any object isn't set to can shrink, then you will get the blank lines for it.

 

[ddmcn]

camaroltd,

You also asked:

Also.... I have to create a report that will tell me the total value of all the items in the storeroom.... sorted into respected categories. I don't even see an addition type function in a report, so how is this possible? I am trying to improve on the old program (Works 3.0) but am unfortunately having a difficult time doing it.

To total the items in stock you will need to create an unbound text field and use the:

=sum([fieldname])

function in the report or group footer.

Hope this helps...