Hi, I’m using Access 2007 and would appreciate any suggestions to speed up some reports. I have a Report with a Crosstab Query as a “Record Source�. ...

I have a report with 2 columns consisting of 6 fields each in the detail of a report. I want a total at the bottom of the columns counting only the fields...

I am trying to add a 2nd column in a Access 2007 Report. I have gone to page setup and changed the columns to 2 but it didn't change anything. Thank you in...

Nobody answered my previous question, so I'll take a moment to elaborate and see if it will get someone to help me with my issue. We are an office of 75...

I have a customer who has used Adobe Illustrator to create a example label which she wants me to print using Access. She has specified the color name of...

I am trying to create a report that shows daily, weekly, monthly totals by dtmCreationDate. So far it does calculate daily totals by the sorting and grouping...

I have a database to track employees production, quality, and calls. Employee names, etc are tracked in one table, calls are in another table, and quality &...

I have a letter set up in a report that has three sub reports. These sub reports vary in size and have the grow/shrink properties set to yes. After the sub...

Is there a way when doing a docmd.openreport in preview mode, to tell it what size percentage to use? Thanks.

I have the following expression in a report control's Control Source: =Sum(Iif(=11,0,)) I need to expand that so that anything with CBDCodeID = 15 and 16...

I import 300 tables from a sql database to Access, trying to figure out how those tables link to each other. I use Tools--Relationships, try to get their...

Hello all, I have a very challenging problem I hope someone can help with. I am going to convert our current non-standard database over to a standard one...

Im a report I have several columns. Two of them are for dates. I need to count how many times any date appears in each column. I have tried =Count(), but it...

I use Access 2003. I have an "Envelope" report which is printed from a command button on my Form - to print an envelope as needed. When database was first...

I am trying to set up a report (so far unsuccessfully....). 3 tables: company, contacts, policies with company name as primary key. I want the report to...

I'm looking to sort my report according to the values in a lookup column. But, there isn't an option in the report wizard to sort the report by column, only...

I've created a report which currently is comprised on 3 charts in which I have maximized each chart to take up a full page and then placed a page break after...

I know this simple but I have a query. The query has 2 fields: 3-digit zip & Zip I want 2 things. I want to count the number of records in each 3-digit zip...

I have a text box with numbers and words. I am trying to format the numbers to currency and it will not allow me to because the output can also be a...

Sorry for re-posting this but I though maybe my title - typo was putting people off. I'm running Access 2003 on Win XP Pro. On the category axis the source...