I have a table with customer information incl. as well the birth date of
each customer.
I would like to create a pop-up that reminds me 10 days before the customers
birthday that the customer has birthday.

Have two fields in access report. Field 1 is a date of birth field, field 2
needs to have the value that is either Date()-(field1+5844) or Date()-187,
which ever is the greater.
Trying to set a registration date where a candidate needs to be 16 years old

trying to set date field....
have a date of birth field, need to set second field on report to be date of
birth +5844 (16th birthday) or Date()-187 (six nonths), which ever is the
greater....

Problem is of this form: two tables, A and B.  A has primary key A.id,
B has primary key B.id and a foreign key reference B.Aref (one-to-many
relationship).  I want to be able to generate a report that will
essentially list each record in A and for each of these the ids of the

I have a table with 3 columnsas follows:
Type   Store  Qty
Dist    604A   2000
Copy  604A   100

I would like to make a subreport visible or not according to the content of a
field in the main report, but I get "You have entered an expression that has
an invalid reference to the property Dirty."  Here is the On Format code:
Select Case CoverAuthor

i'm a very basic user, so please excuse me if this sounds relatively
elementary.  I have a report based off of a crosstab query.  I would like to
create a sum in the middle.  I can't get it to work.  It looks like this.
Date  inv#  cust totalsold prod1 product2 product3 product4

I'm trying to do a statement with access but i'm having a problem. I did a
report that when opens a form pops asking for the begining and ending date,
do you know how can i put on the report the balance that i had on the
begining date of the report...

I'm trying to format a report with a sort order and a group footer.  Example
data:
WorkOrder      GroupID
     1                  1

I need to include a field from a List table which is not part of the original
report.
Do I need to do a whole new query and do the report all over again.  - I
hope not.

I am doing a report using the following query as a Record Source:
SELECT [Employment].[EEStartDate], [Employment].[Wage], [Employment].[EE],
[Employment].[JASID], [Employment].[Occupation], [Employment].[Employer]
FROM Employment

I am getting unexpected results when I apply conditional formatting to a
calculation for percentages.   I currently have "Field value is greater than
1" because the format is percent.  Any percentage that is nn.nn is being
ignored, as I wished; any value that is nnn.nn is being ...

I have a report in Access which was working until today perfectly.
Now, if I want to open that report, the message "SYSTEM RESOURCE EXEEDED" is
coming up.
Any clue what I can do to make this report working again?

Within the same text box on a report, I am trying to display multiple font
weights. Some text needs to be displayed normally; other text needs to be
displayed in bold.

I have a report that was designed using one query.  Now I want to include
data from antoher query....any way to acess a query from an existing report?
Thanks!