Hi, I have a table that have about 5 thousand records. I just want to list all the records that code field (text data type) begin with CSCAS. I want to list...

I would like to set up the Margins on my report, by code. Not File/Page Setup/Margin Top margin 1" Left margin 3" I'll open this report with a command...

No headers or footers print on the blank pages. What specifically do I have to check? I cannot see what is wrong. My print area is very small compared to the...

Bit of an odd request probably, but I am sorting out some inconsistensies between an access report and a customers' software package. Some of the pages of the...

Hi, The DB was not designed efficiently to begin with - I am working with a set of existing tables to provide what the customer's expectation of their reports...

I have a client that uses an epson lq570 and i cannot figure out how to set my reports up to use the printer fonts instead of true type. True type prints as...

Hi, I have a report where I have added an unbound text box. In the text box I want to count the total number of 'Yes' values for records that match certain...

For the life of me I cannot get this to work! When I try to print to a generic text printer, Access does a page break after every label. I'm using 5/16 by 3.25...

Hi, I've upgraded Access 2000 to 2002. All was ok until we printed reports. Most printed ok but a 6 ot 7 reports lost their print setting and doubled the...

Scenario: Access 2002 (with an Access 2000 format db), Windows XP. I'm a new Access user with very little database experience (as may soon become obvious :-)...

Using VB or any other easy way, how do I update the title on a chart with the parameter from a parameter query? Just spell it out long please. I know nothing...

Hi, I need some help SELECT count(*) AS ReceiptMethodCount, FROM Correspondence WHERE =!! And =!! GROUP BY

Using Access 2000, I want to add a note to certain records of my database when they are printed so that duplicate prints are not made. Also serves as a log to...

I have a report with page header, page footer, and a VARIABLE number of lines with data in the detail zone of the report. How can I make the detail zone of the...

That is correct. It prints the entire report header and all of the page headers on one page and then it prints all of the page headers and the report footer...

Hello everyone: I have the following query set up and it works well so far: SELECT Count(.) AS , Min(.) AS , Max(.) AS , Avg(.) AS FROM I have 2 other...

I have a report that looks like this Main report header sub report1 sub report 2 a 1 b ...

Is it possible when I email a report as a snapshot for the recipient to open it and see just my report and NOT all the previous? We are using win2000 and...

Hello, I have a report with a group header. Whenever the group spans more than one page, the next group follows on the same page. I'd like the groups to...

I have a database in which I track sales results by individuals and type of sales. For performance reviews I have a pie chart that shows the results for a...