I am generating a report from multiple queries (each of which have their own
[enter beginning date] and [enter end date] prompt).  Is there a way to have
a date prompt at the open of the report for a specific date range and tie
that back to all of the queries?   Right now I am ...

I looked around and I couldn't find out how to add a date parameter to a
report. I want to have a prompt that asks for a start date and one that asks
for an end date. Then display all records between those dates. Should I put
that in the query? If so, how do I do that?

Below is a post I put on here previously. It was answered by using a
Select.Distinct and it worked great. The 2 people also mention that I could
add a counter on the report. So if Joe Smith went to google 20 times a day it
would say:

I inhereted a db that has a number of reports.  Each report has several
subreports.  Many of the reports are no longer run.  I can easily delete them
but I am finding 'lonesome' subreports that are no longer needed.  Is there a
way to get a list of all the reports, that act as ...

I have the date field [Contact Date]. I have weekly report that counts the
not null data in [Contact Date], the report uses "Between [date1] and
[date2]" to create a count of this field in the report. A monthly report is
created using the same criteria of "between-and". No ...

I have set up a report which generates multiple pages (due to the amount of
data in the report), however every second page is blank. Note that all the
data that is supposed to be captured is being displayed. I want to eliminate
any blank pages from my reports so that No paper is ...

I am new to Access. But I have used Crystal Reports. I would like to be able
to specifically control where data is displayed on a report.
Perhaps I could use a text box and write an expression like "If
(Item#=AR0001 then

I have a report which I want to be able to change its title dynamically
(using VB) when the report is opened.
I tried to write on the report_open event:
If ....

I'm building a report and I need to have the Cumulative totals at the bottom
of each page. For example the first page would have a totals field for the
first page and the totals field for the second page would have totals for
the first page and the second page and so on. Can anyone ...

I am entering therapist visits to patients on a form. The form feeds a table
storing the patient visits for billing. The following code is working well
except when an error is made that requires the COid to be changed. The visit
rate (CurrRateAmt) remains the same, instead of ...

I'm trying to setup the Format property for a text control that displays a
Date/Time value and I can't get it to work the way I want.  I want the
Date/Time to display the hours and minutes with two digits each (as in 09:15
AM).  I try specifying mm/dd/yyyy hh:nn AMPM, but what ...

When I try to print a report it prints in portrait.
If I change the setting to landscape and save it like that it
reverts back to portrait the next time I try to print it.
I has always been printed in landscape antil now.

I have a subreport that runs from a query, in that query I have a field
called "ActiveInActive", I put "true" in the criteria so that any record
marked "true" would pull into the subreport.  This works fine.  Now I am
trying to calculate in the main report those records that ...

WHEN USING CHR(9) IN ACCESS MODULE: SUCH AS
X = "tHIS IS A SAMPLE" & CHR(9) & "OF ICE CREAM."
I GET A SQUARE BOX WHERE THE [TAB] IS SUPPOSED TO BE ON THE FINA
REPORT.

Hi Group,
If I try to download a SNP file using <a href> (<a
href="filename.snp">Test</a> ) IE asks me to -Open-, -Save- or -Cancel- I
select -Open- and then it asks me to -Save- the file to the local computer,