I have a report in which I need to have the the services for the listed
account(s) in one field.  I was provided the function from The Access Web for
concatenating the info into one field.  The query and report are completed
with the exception of the one field.  And this is where ...

I am trying to check that a date is between a range and is also in a
particular month, this one being january. I know this syntax is wrong but i
cant begin to think how to look at only the month part of the date. The
current formula is shown below.

i want to open my reports in the same format in execl as i see in access...i
want same kind of allignment ,headings,...exactly the same way..(horizontal
and vertical wise).. is it possible? i hope u understood my problem plz help
me out..waiting for rply

Howdy, i would like a traffic light system on TOTAL_PERCENT so if the result
is between 0 and 56 the colour will be red etc. i have this code on the open
action of the report but it comes up with a compile error else without if.
Please help i am not a code monkey, please help.

Hi,
I have a control on a report which looks like this:
=IIf([Gender]="m" And [age]="4",Sum(Abs([Age])),"0")
...but Access gives me an error msg telling me that this is either typed

How do you turn off the box that comes up when you prin that says...
Printing Page 1 etc.....
Thanks
DS

I downloaded Albert Kallal's WordMerge22 db
and liked his custom report menu bar that allows
printing to default or specific printer (thank you Albert).
I just could not figure out how he associates the

Hello,
I have a report in which I would like to change the record source using
visual basic. That is, in a specific form, if the user presses button1 then
the report would open with Table1 as it's recordSource, and if the user

Hey folks,
I have two separate reports:
1: bound report with header/footer and Detail.
2: Unbound, just graphics.

This is the SQL from my Accounts Aging Report.  I am able to get a grand
total for Current, 31-60 Days, 61-90 Days and Balance. But NOT for 91+ Days.
I have checked to see if the field if visible, and it is.  I do not see why
it will not work.  I have deleted that field and ...

I wnat to know about how to print a report in multiple pages i.e. I have
created a report and I want to view one reocrd in this report but its display
me 3 pages, on the first page the label captioned "original", on the second
page "duplicate" and on the third page "triplicate"?

I have a form and a report.  I want the record that I am viewing on the form
to be the record that is displayed on the report.
I have found a similar question in the discussions and have tried that the
coding suggested but cannot get it to work.  The coding in question is:-

Hi there!  I've been looking at Duane H's calendar db.  I still don't know
what I'm doing!
I've created a query that brings back the fields I need.  Here's the
concept: There are on-going volunteering opportunities (VolunteerName)

I have a report which has a subreport in the detail section. In the report
footer, I would like to print a count of all records printed in the
subreport. To do this, I created a variable which I increment in the Print
Event of the detail section of the subreport. I then print ...

I'm trtying to run a report from a Crosstab query.
Some fields on the crosstab field are empty because no figures are available.
When i try to run a report adding the different field I do not get a total
becasue some fields are empty.