Hi, I want to make a report of the sales on the month, so I have this:
 Date           Sale
12/08/05      2345
12/08/05       6667

I have a beginning date, an ending date and need a return date.  I can use a
formula to add one day to the ending date, but I need the return date to be a
business day (Monday thru Friday).
Beginning 3/21/05, ending 3/25/05, return 3/28/05.  The ending date isn't

I have searched many posting, and I have not found an answer.
I have a flag on a form.  In my report, if the flag is True, I want to print
a field from another table.  I am using the following in the Control Source:
=IIf(IsNull([RSVP1]),[BadgeText1],"NO RSVP")

I am trying to make an envelope in reports.
I tried the trim function to make the words come together, that didn't work.
Now what?
I want everything to flow together like in MS Word.

Using Access 2000
I have a form (scanned and posted at
http://home.new.rr.com/nelliott/access_problem.htm )
I wonder if there is anyway I can create a access report with this data. All

How do i limit the dates i want to be displayed in the report?
I want to only be able to display entries in the last week/ last month....etc.

I have created a pie chart that have gender VS count of gender.  However,
whenever the pie chart has the first value as null (e.g., total # of female
is 0), the legend "Slice 1" appears.  Is there anyways that I can eliminate
the "Slice 1" legend even the value is null?

Where can I find good newsgroup for developing crystal reports ?
Thanks :)

Hi, I know this must be easy, however I am stumped on this after working at
it for an hour.
I have a main report. With 3 subreports.  There are labels on the main
report showing what each subreport represents.

I maintain an Access database of Volunteers for our elementary school.  Last
year I kept everything in a flat file to make things quick and simple.
This year I have a database with three tables.  Teachers, Students and
Parents.  There is a one to many relationship from teachers to ...

I have a report set up that shows a grouping of a field called
EventDate for each Employee. So in the EventDate footer
numerous dates will show up for each employee.
How can I show in a text box, further on in the report,

I have several labels in my report, check1, check2, check3, etc...  I need to
hide these labels if the [Type] field does not equal "Module".  How can I
write code that will hide them if [Type] <> "Module"?  I already have a macro
in the OnOpen event of the report so I'm not sure ...

I have a series of reports I use for a directory listing for a trade show.  
When I put the directory together, I print one copy of each report, export
the report to Excel so that I can use the data in a Word merge (which is how
it goes to the printer), then proof the Word merge ...

hi - is there a way to import a PDF document (a fillable form) into msAccess
to build a report - to avoid having to manually create a replica of the
form?

I have a report that is taking about 8 minutes to run. The query that the
report runs off of is running quickly. I dont have anything other then simple
sum calculations in the report so I am a little stumped