Unbound text box in my report, control: =Format((IIf(="Other" Or "Withdrawn by Petitioner",,0)),"Currency") But, it does not work. I puts the in every row...

I am trying to write a report with a string: ="Milage (" & & " @ " & & " per mile)" This should come out on the report as: Mileage (49,000 @ .31 per...

In my Access 2000 mdb I am trying to create a report that must choose the correct mailing address to send the letter to... The database holds 3 sets of...

Hello, I am trying to make a chart for each item's sales and link to a form which will have the item number to look for. My query has each items information...

Hello I am creating an Interview schedule report for the Faculty of Medicine Admissions. Before this year they did it by hand...but now that we have more info...

I have set up an address list in Table format and am trying to print each of the fields on different lines on Avery J8159 address labels using the Label Wizard...

My query displays records of individuals with the same last name (i.e., Lucy Smith and Evan Smith); however, my report will only display Lucy Smith. The...

Every time I try to print a report into pdf format, access 2003 crashes. any help? thanks

Hi, I have to send bytes generated within VBA Code directly to a printer. Actually I am using code like this: .... Open "LPT1:" For Binary Access Write As...

I want to find the name of the current report and use it to select a record from a table which contains one record for each available report, so I can...

Is there a way to turn off zeros (0) on data labels when working with charts in access. I have zero value and it seems to clutter up the chart. Thanks for...

I received good advise from Albert to be able to print the lookup value on my labels report rather than just the ID number of the lookup fields. In the query,...

I have a table set up with Group Name Q1 Q2 Q3 Group 1 Yes No No Group 2 No ...

Have a problem where I have created lots of queries and have several reports based on the queries. I would like to total the number of records which are...

Hi, I have packaged an access database with the packaging wizard. When I print a report on the computer I used to package the application everything is fine....

I am trying to get a report to give me the sum of a field on an "IF" condition: All records have an field. All records have a field. I want the report to...

Want to print "Continued from previous page" when overflow occurs. I set up a label with the wording and made it non visible. In the detail setting I used an...

I have an Access table with many tables. I want some of the information grouped. For instances, instead of having three different text boxes for "City",...

Is there any way to send a text string from Access VB straight to a generic printer?

I have 3 tables. GrantsTbl, LkUpAgency, LkUpFacility. The GrantsTbl has 2 fields AgencyCode which comes from LkUpAgency and the other is Facility which has...