I am trying to create a report that has 5 columns (M Tu W Tu F) with corresponding data underneath. I'd like each day to appear in a different column. The...

can I do =Count() ? How do I write a statement to count all answers to Q6 where option=1 in a report? Please help! TIA.

I have a form with multiple search boxes to filter on one or more different fields on the form. When any of the search boxes are changed, I make up an SQL...

I need to show a date in the Report Header part of my report. Currently the criteria to print the report asks you to choose a specific day. I want the date...

When I try to ODBC an access database, I can't ODBC and keep the format of a custom number. So, instead of 4.00 its reading 400. I formatted the column to...

Dear anyone, Can the Access do the shift from printing the first column to the next column as we needed, in place of its printing to the bottom and...

You guys rule...! I am getting it done here better than anywhere I have tried. Next problem: I have a form open with all the information filled in to a...

Hi All! My fax is setup. I can fax from my computer to the fax machine. I can fax from any application. My problem is faxing from Access. When I fax the...

Hi all, I have a report (or possibly multiple reports) which I would like to be automatically sent to a list of people through Lotus Notes. Does anyone know...

Ok i have 2 reports that are related. I need to take the total per page that i have set up on my main report and put it in to my other report. The first...

I am trying to automate emailing of access report as the message body of the mail but not as an attachment. All that I know now is sending them as an...

I have a report with two columns. I have an image for each record. I want to make the image switch sides of the column in the second column. How do I do...

Hi Hope you can help me. I have a report that builds on a crosstab query that shows employee number as row and course name as culomns and a expression (If...

Hi all, on my report, I display a combination of clientname/year/indicator, and I only want to display comment at the first line of a year like...

I want to set the caption value in a report to the value in a control on the same report, or Form, Or Quirey. Iv'e tryed a Macro and a formula in the caption...

Okay, I have a report, with a subreport. Everything is working perfectly except one thing. If the subreport shows more then one entry, the report (which...

When I publish an Access report in MS Excel some of the information is not displayed in the cells as there is too much. How can I expand the cell size to...

2 of the columns in my report have textboxes, say txtA and txtB, of exactly the same size. txtA contains numbers while txtB is either a string or "". I was...

When I select a network printer (with an IP address) as my default printer I cannot open or print reports. All other printers, even shared on the network,...

I created a report and have the following problem..... The report has a huge amount of white space between the detail section & the page footer. Note: The...