I need to get the date that only resides on a report(not in a query) and have
it on a report for the date that the Invoice(report) is FIRST PRINTED.  If
the invoice is pulled back up on a future date I need that same date to be on
the invoice.

I am working on a report that contains two subreports. Each subreport has a
list of numbers and then calculates a total. I am wanting to take the two
totals from the separate subreports and make a grand total at the bottom of
the report. Anytime I try to do it, it only pulls the ...

I have a pie chart whose data is based on a yes/no field. The legend displays
"0" and "-1" for yes/no, obviously. Is there a way to change the legend
labels so that they are more meaningful to my end user who won't know what -1
and 0 mean?

I throw this question out to the news group to see if anyone has or is using
Crystal Reports for the reporting mechanism for A2k? If so, do you have any
difficulties in its use? Any words of wisdom?
Even tho A2k has report capability, to export or put into Word, all the

I have a table with the date, payment amount and category which allows me to
generate a report with the sum of all payments that day.  Now I need to
generate a monthly report that gives me the sum of all payments for each day
, the sum of all payments(deposits) for the month and ...

I have a database that is on a LAN Server and when employees on the west
coast print it will print to the printer that is the default where the
database was created.  What can i do to get the database to print to the user
local printer?

I have access set up to print invoices which I then post to customers. I
then have to startup Word to print envelopes. Is it possible to setup Access
to print an envelope after I print the invoice. I have a separate printer
that I use to print envelopes.

I've got a query returning records and sorting first by lastname, and then
by first name... but when I open the report based on that query, the order
is lost.. anyone know why?

In an Access Report, I need the labels in a 90 degree direction. ...How do I
do that in Access?

I really need some help on this issue below:
Create a report that will include various field names (fieldname1,
fieldname2, fieldname3, etc.)that groups all of each fieldname1's data
together. I also need to include a function that will count the total

I have a report with two groups: Territory and Agent; and 4 fields like:
Client, Sold(Y/N), Average Days to Sold and Premium.
Users want to filter the report by Territory and Agent. (I have no problem
here. Users will be able to select a territory or an agent from two drop down

when I use =NOW() for date and time in my report it just
comes up as #name?  anyone know why.  Pls

I have report. On that report i have line which must shown on any page
header exept the last page which is summary page.
On the page header there are another objects that must be shown on each
header including the last page

Hi, can anyone help with a problem I have?
I have a report that I want to sort on an expression.
Here is an example of what I have. I have got three
Fields, which are,

I have a crosstab report based on a crosstab query that links "phases" to
projects.  Each project can have up to 20 phases scheduled.  The report
works fine if I filter on Phases where Phase.Complete = "false."  Where I
get into trouble is when I add a filter on Project where ...