I have an MS Access database that was developed using Access97; I have
subsequently upgraded my system and am using Access2003--the database is
working flawlessly except for an error that has arisen with one of the
Reports which uses a series of check boxes to add specific data ...

How would I capture a certain value. For example, I only want values above 12
in a field, then I want to calculate the value above 12. If the field had 20
I want to calculate 8.

how can i get them in access2000? help me, please!

Hell
I have a table which among other fields, there ar
mont
cours

I have a report with 6 subreports. On the Main report in a group footer, I
want to calculate a % based on totals (calculated controls) in the
subreports. I keep getting the #Error on the report. There are instances
where a subreport may have no records for the group. Do I need to ...

I created a VBA routine to output a number of Access
reports into a .snp format. The routine ouputs 4 reports
and then gives me an error that I don't have enough
temporary space to finish writing the snapshot reports. Is

I know this question must have come up in this group before: can I direct a
report to a particular printer with a VBA command?  By some other method?  
Thanks.
David Habercom

I would like to produce a folding Pamphlet with dynamic information
utilizing access reporting if possible.
Can anyone point me in the right direction?  Will I need to use word merge
instead?

Hi. I was getting some help from AlCamp on this but we
seem to have disconnected our conversation.
I wonder if anyone else can help me modify some On Format
code I have in a Reports section. The following code

I have two PC's.  One PC has Access, a slow printer and no communications
line. The other PC has WORD and a fast printer.  I can read/write CD's on
both.   I want to create an access report on the one PC and print it on the
other one. I tried exporting the report, burning it on a ...

Rookie post.
I am under the impression that when creating a report in Access 2003,
you can use only one "record source" (query or table) to provide data
(acknowledging that several tables or queries may may be used to create

How ?
To make the report display only the top 20 of each of all
categories in that value field.  And, Yes at the footer
I 'd like to have the sum of value of not the top 20 but

I am having a heck of a time trying to create several nested subreports in a
main report.  I think my main problem may be because I have two nested
queries because of a “many to many” relationship in my database.  Let me
describe my tables and their relationships.

I have a report based on a query that uses other queries that use other
queries.  I am making changes in the base query that trickle to the main
query.  I have SAVED queries every step along the way and tested the main
query which would run fine.   It was only when I opened the ...

If I set the [enter date][end date] criteria in a query and would like to
print the report it is asking me for every customer [Enter date] [end date].
I just wanted to give a criteria for display items in a period of time for
all customers. Why do I have to enter it for each ...