I have three tables, Entries, Jobs and Parts. These three tables are related
with one-to-many relationships, from left to right.
i.e. one entry - many jobs
one job - many parts

I have a report with 2 sub reports on them,
Main Report
Sub Report1  contains Fee Totals (A textbox contains this information)
Sub Report2  Contains Payment totals (A textbox contains this information)

I have a rather complex crosstab query which goes down three levels. In
other words, I have two base queries that are combined into an intermediate
query, and then the crosstab query is based on the intermediate query. I
then use this crosstab query in a report.

I am building a report that identifies corrections needed to records. The
form has 30 questions and 1= Need Correction 2= No correction. HERE is my
code =IIf([Correction]="1",[Text]).  With this expression when correction is
needed my report prints a blank in the text field. Is ...

I cannot change the format in a report to a fixed format for a calculated
control on my report, and when I change the decimal place it does not change
on the report.  The decimal place option is required but does not work for a
calculated control.  The decimal place setting in ...

How can I round to the nearest 5000 in an Access report?
I have a text box where I caclulate a number and I want to round my
calculated result to the nearest 5000. I was expecting to find a function in
Access similar to MROUND in Excel.

I am wanting to change the Primary Key value for data entries after it
has already been set.  I have one main table (tblManpower) that has
every employee in the Facility, with their clock number as the Primary
Key.  Linked to tblManpower are two other tables (tblDutyHistory and

In Access Reports, How to draw a rounded rectangle?
...as in Excel's Autoshapes

Is there a bit of VB Coding i can use on the onclick event of a report
button that will only only show the filtered results what are shown on
the form.
I know i could have various query's and Buttons, But its just to long

Is there a quick and easy way to copy a report from one database to another?

I have a multicolumn report which looks like one below. This report takes
data from the table. I created this report using report wizard.
Now, lets say for activity A  there is no activity for  customer in "column
a"  I would like the "column b" the  aautomatically move forward.

Here is my code
Private Sub Report_Activate()
If Me![rptCReDriving Licence].Report.Recordset.RecordCount = 0 Then
   Me.lblnoinfo.Visible = False

I created a report from a query of a table that uses list boxes. When the
report prints all the field from the list boxes are white print on a black
background. I can't find how to fix it and leaving it that way will consume a
lot of ink.

Dear friends,
I am confronting with an error and I do not know why it appears and how I
can get rid of it.
The error comes when I write a code in ANY of the event methods of the

I tried =([Lastname] & ", " & [Firstname])
and it did not like it.