I'm using the Label Wizard to create mailing labels for Avery 5160. The labels are fine at initial set up -- three columns with ten rows per page. There's no...

I'll do my best to describe the problem without sounding like a bafoon. I have 2 tables: Properties and Units. Each one property has many units, hence a...

I am trying to print 1 of 7 reports depending upon the selection from my pop-up Dialog Box Form. This selection would be for the “Number of Payments�...

I use Access 2000. I used the label wizard to create standard mailing labels (3 columns by 10 rows). I thought by creating the "Label" report that I would...

I can't seem to get set the Filter property on a subreport using VBA. Here is my code in the open event of the subreport Select Case Parent.bytSrt Case 1 ...

Hello, I have a subreport that is supose to display the 1st three people in an inccident. I know how to filter so that it only prints the 1st three but...

Hello, I have a report for printing Security Incident Reports. On the first page there is a fixed three slots for up to three people. I need to have all...

I have a report with two subreports that are the same child report. I want to be able to tell, within a subreports open event, which subreport control it...

I have created a report from a query. In a text box in the summary area I need to calculate workdays. I have written a VB function to do this. How do I...

I am running Access 2002 and I have created a report from a query. I need to calculate workdays in a text boxe in the Job_No footer. I am summing some...

I have this very annoying thing happening in the Access 2003 report designer. When I change the caption of a label control, Access 2003 moves the control a...

Hello, I have a form call "Daily Reports" which the user fills out daily. I also have report that needs to be printed daily. I have a command button that...

Want to print "Continued from previous page" when overflow occurs. I set up a label with the wording and made it non visible. In the detail setting I used an...

I've got a table with an attachment field that I'm using to store images. I've got a report based on a query of that table plus others that works just fine...

Hello, I have two fields and is a text field with a list box (target, adjacent (N), adjacent (S), adjacent (E), adjacent (W)). is a check box with a...

PC replaced and apparently imaged successfully, but Snapshot Viewer control from old machine no longer works after user's PC was replaced - gives following...

Is there a way to generate an report in Access using a "pivot table" format ??

I have a report that involves a lot of groups, each includes up to 4 names. If a group only consists of 1, 2 or 3 names, I would like to block the other 3, 2,...

Here is my SQL statement SELECT Sum(.) AS , .DATE, .NAME, . FROM LEFT JOIN ON .ID = .ID GROUP BY .DATE, .NAME, . HAVING (((.DATE) Between #1/1/2007# And...

All of a sudden all my report dates don't work. It used to use NOW() for today's date. I've tried everything to insert today's date and nothing works. I...