I am trying to insert a word like "Green" if the value is 1 or red if the value is 2 but less 3 or Red if the value is 3. Can someone help? Thank...

I am looking for help, I can count the number of records in a report using count(*) but the result appears in the header which I knew, but I need the number...

TIA: I have a table with yes/no fld. I'm trying to generate a report to simply show "#_of_yes" OF "#_yes_and_no") and calculate the percentage eg (7 of...

Can someone suggest how i can put an image on a report (similar to a watermark) and have my text boxes on top of the image. then set the 'can grow' to YES on...

We have a client that sends us .snp files as email attachments. We have Office 2007 installed on new Windows XP PCs. We have the Snapshot Viewer installed....

Hi....if you are experienced with Access07 ; can you briefly explain the phenomena when one used the Report Design Wizard all the fields created are "bound"...

How to eliminate blanks in a report from the fields in the "detail section"

I had a "truncation of memo field" problem, similar to the ones I could see here, but with no solution, at least in my case. To be honest, I posted a similar...

i have a simple list of values (in a sub-report) that i would like to print across the page instead of down. when i produce a report for 1 project (cost...

I am cross posting this in both the Forms and the Reports forums. Let me apologize in advance because this is going to be somewhat scattered and somewhat...

i have a watermark image i want to put on a report. the problem is the report has a text box field with the CAN GROW property set to yes. as the txt box grows...

I hava a report with 3 subreports, I would like to sum the total as below : text1 = reporttotal + subreport1total + subreport2total + subreport3total I have...

I have a report with 3 subreports, I would like to sum each total value together. Details as below : report.text1 + subreport1.text2 + subreport2.text3 +...

I have a calculated field in a report I am running in Access 2003. The report shows attendance percentages for 3 shifts over 3 zones. However, only one shift...

Hello, I have a database lets the user search for provider by specialty and county. So, if i want to serach orthopedist in Manhattan, I would type in...

I seem to remember seeing a report that used indices to refer to the field header, and control. I have a table that has just a few fields, that may contain...

Hi everyone, I'am still experiencing some dificulties with my report's. I still need them to Look as a Calendar. What i did was, i crated a Query that...

How do i get the report to print only one. it does show as a duplicate in my queries, but not in the tables.

We use Access's built-in function for exporting reports to Excel quite a bit and have been very happy with it. However, there are a couple reports that we'd...

Hi How can i make it so i only get one record on a page? regrads alvin