I would like to create a report from a form based on certain criteria found
within the form.  I would also like for this report to automatically generate
when the database is opened.  Basically, what I would like to do is to pull
records from a form whose information has expired ...

I am using access 2003. I am looking for a way to export report to PDF but
found no answer. I hope the group would help giving some advice.
SF

I am trying to build a report, rptCodeReview, based on a crosstab query,
qCodeReviewRequestID, with one parameter.  I am trying to follow the advice
in KB article 328320, however, when I enter my query as the report's
RecordSource, I get the message "The Microsoft Jet database ...

Is there a way to create a report that lists all tables in the database and
what the record could is for each table?
Thank you for your help.

i enter data into a form and 2 of my fields in the form
our calculated.  when i go into the table these fields are
blank but they do appear in the form and the report. but
when i try and sort using this field it goes all wacko  

I am trying to produce a telephone directory.  Each directory entry may have
an e-mail address but it is not required.  The first line of textboxes
include name, number, agency code and city.  The email text box is directly
below the other textboxes and can shrink if the field is ...

I would like to group my report on current year's transactions only.  But I
do want in the group's footer I would like to have the previous years total.  
I have used the below iif statement in the transactiondate text box control
source.

welcome every one,
i create a programme for my employee so when each user open his form to
select his name a macro reade the date and print it in a report
so my report now contain 2 columnes (the names of employees and other is the

I thought I had read someplace that you can play an audio file while
displaying a report or form.  Is this possible?? I've looked thru the Help
online and found nothing under Audio or music.   Thanx

Help I'm going round in circles!
I have a check box on a form and depending on whether it is ticked or not I
want to display one of 2 controls on my report - but I cannot seem to get the
right "test" - Access keeps telling me "Invalid use of null".

Is there a format or formula for aligning decimals, - particularly if using
the percent sign?
Like so:
 1.34%

Is there another way to write nested if ?  I have used 9 nested Ifs in my
formula and the tenth or more prompted: formula is too complex.
Thank you,
jrcruzr@hotmail.com

hi i am trying to do a simple graph, but i can't get it to gice me a second x
axis along the top.
can very easily get a second y axis
i want to show the corisponding value of the energy at the different angles

How can I distribute different pages (Statements) of a Report to
different recipients via e-mail.  They may be distributed either as
attachments or as the e-mail document themselves.
I could, I suppose, filter the report for each account and then create

Hello. I have a report based on a query which produces three fields [UNIT],
[DATE], [PRICE]. I have set up the report to group the records by the same
units. I have set up a text box in the group footer [=Max(IIf([DATE] Between
70604 And 80604,[PRICE],"")) ] I am attempting to ...