MS Access Reports 4

[bene]

How do I add a count of values (records) to a report.<br>How do I get reports in single space.<br>Can I export Access reports to MS Word, if so how?<br><br>Thanks for any help.

 

[lhugh]

If you have a report already you can go Tools -&gt; Office Links and choose the application that you want Word or Excel

 

[DougP]

Getting a count:<br>=Count([SomeField])<br><br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[lhugh]

Doug can you do a calculation on a report ? Or you have to do it in a query, table first then create the report after ?? thanks

 

[DougP]

It's easier to do it in a report.<br>Usually people want to hold a paper in their hand.<br>So a report is the best way. it offers more flexibilty too.<br>You have a blank sheet that you can do anything with.<br><br>I start with a query then base a report off of it. <br>You can tweak it, total it, and so forth. Add Footers, Headers, Groups, whatever are all much easier on a report <br>Date Report was printed cahnge Headinga and data based on information on a form. None of that can be done in a query.<br><br>Plus the V.P. can have a pretty piece of paper to show off.<br>I also use Bar-Codes everywhere and a query will not print them. <br>Bottom line use a query to get your data and a report to print it. <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[lhugh]

What is bar-codes Doug ?

 

[DougP]

Did you ever buy anything at the store?<br>That set of black lines that the cashier scans is a bar-code?<br>Here look at my WEB site.<br><A HREF="

http://www.tomall.com/ttf.htm"

TARGET="_new">

http://www.tomall.com/ttf.htm</A>

<p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[lhugh]

thank you Doug, now I know

 

[bene]

Many thanks<br><br>bene

 

[bene]

Can you show me what the syntax is for getting a count of records i tried count=([field]) and kept getting &quot;syntax error&quot;.<br>Also how to get reports in single space?<br><br>Thanks again<br>&nbsp;

 

[elizabeth]

Oops! You've typed that in the wrong order. It's <br>=count([field]), not<br>count=([field]) <br><br>Also, the actual name of the field goes inside the [] brackets, not the word field. Or if your field is named field, rename it to something else. Not a good idea to use&nbsp;&nbsp;names that may actually be reserved words. <br><br>Please post each topic(question) to a separate thread in the future. It's easier for the people who answer. Don't know what you mean by &quot;single space&quot;. Maybe you could post in a new thread with a little more explanation of what the problem is.

 

[WoodLark]

Access text boxes usually contain a lot of &quot;white space&quot;.&nbsp;&nbsp;Resize your boxes to reduce white space at top and bottom of the box.&nbsp;&nbsp;Also, make sure you minimize the white space at the top and bottom of the Detail section in the report designer.&nbsp;&nbsp;While this isn't truly single-space, it will do a better job of simulating it.