Greetings. Don't have a label printer, but on 3 column, 10 row (Avery type) label sheet, would like to start print labels at specific column and row, say 3rd...

I have one column that I would like the grand total to print in the footer section of the report. Can you tell me the correct expression to use and if I can...

I am creating a report in desing view. Is there a way to have each field that I add to the report match the current field's format? I don't want to have to...

I have a report created from Excel to record employee’s time. I am new to writing SQL so I need some assistance in creating this, if this is the solution....

Hi guys, I have in my Access database a field that shows multiple values per record. For example, AAAA~BBBB~CCCC~DDDD. In a good database, AAAA, BBBB, CCCC...

How to inport Access report in Word document as it is (with all headers, data, colors, etc.)?

Hello, I have a main report that needs to add a field from a sub report. I keep getting #error. This is what I have on the Main Report to test for...

Hi I have a report which works as a letter to an individual inviting them to training. I have a page break at the end of the standard text. Our company...

Hi, I am trying to run a report with a filter on the data using the property window. The data is coming from a query named PCI. The Record Source SQL is:...

Hi, I am a n00b in building reports in Access and have the following question. I have created several reports, which in some instances have different headings...

Dear all, I preview a report, the I press icon Analyze It With Ms Excel, but it doesn't work. Please guide me to solve it. Thanks. Vensia

I want to have my code send the focust to a new record in code. When running "DoCmd.RunCommand (acCmdRecordsGoToNew)" it does not know what form I am...

I have two y/n fields that need to trigger printing on a report. I am using the following, but i keep getting a syntax error. If first Y/N=true the test...

I now have my start and end dates in my report but if there is no data entered between the start and end date it shows error not the dates how do I always...

I have a report that contains a customer listing with phone numbers. I want to filter out all of the customers who do NOT have a phone number. Do I need to...

Wonder if anyone can please help. I want to print only selected records from a subform. My main form contains individuals name, address etc. The subform ...

When I run a report, is there a way to use the "Microsoft Date and Time Picker Control, Version 6"? To Pick My start and ending date for the report I have a...

I believe the behaviour of Sorting and Grouping has changed from Access 2000 to Access 2003. I have a report with a Sub-Report in the Page Footer of the main...

In a report I have certain records tagged as true or false, if a record is true I want to include it in a calculation if it is false I want to ignore it in...

In a detail section I have a listbox whose rowsource needs to be updated by a query string in the OnFormat event. The query selects records based on the...