I developed a database that has internal macros to assist in query
executions.  This database was then compiled using the Microsoft Access 2003
Professional Tools into an *.mde module.  The *.mde module was then
distributed to a few people at work along with the Microsoft Access ...

I'm trying to format a report using certian condition in the table. I was
giving code example that uses detail on format event. it looks like this
Private Sub Detail_OnFormat (Cancel As Integer, FormatCount as Integer)
code

Hello. I have a question regarding calculations in a report.
Here is my situation: I have a table named User that contains all of my
User information (User_ID, Name, ..., Marital_status). A user can be
single, married, ... I have created (with the help of some good people,

I need to produce a report with output based on a field entry in the table.
ie if field has content then substitue value with the word "Supplied", if no
content then leave it blank

Is there an easy way to select a portion of fields in a row or column without
having to select one at a time.

General question. Is it possible to link to an excell file ,import the data
and makes reports from this data?

I am trying to make a simple chart but the wizard will not work for me.  All
I want is:
Xaxis - Date
Yaxis - Score

Please help!  I am trying to do something that I thought was very simple but
quickly found out that it is not so simple.  
My report's RecordSource is based on a table but there are many textboxes on
the report that are Unbound.  On the OnOpen procedure, I want the user to

how can i design a report in down across col. layout in the style...

I am making an export function that uses the dbpath and the name of the open
object. It prompts the user only for the kind of "Outputformat".
DoCmd.OutputTo acReport, "", , strExportfile, True
It prompts the user for the sort of output, *.xls or *.rtf. Can you fetch

I had posted this in the query forum, but I think it is really a report
problem, so I am posting it here.  Sorry for the double-post.  :(
I have a database that has a table/form with property information with a
linked subform with all the past owners of that property.

I have a Count(status) in my query grouped on custID, Status.  My detail
displays the Status description, and the count column.  In the customer
group footer I want the total of all the status items within that group.
I have seen running total but that doesn't seem to do I want.

Ive made a report from two tables that are linked by an autonumber which is
also the primary key in one table to a text box in another. When i try to
preview the report it says there is a mismatch error and pressing help says
that i have a mismatch  in the join expression. Now im ...

I need some help creating a report. I have a table named User that
contains all of my User information (User_ID, Name, ...,
Marital_status). A user can be single, married,... Now I want to create
a report that will count and display the number of singel users, number

I'm new to Access VBA and I would like to know whether it is possible to
include a print button IN a report, i.e. the user will see the preview of the
report and if he wants to print it then he will hit the Print button not at
the toolbar but on the report! (of course the print ...