First, a big THANK YOU to everyone who helps out here.
I am running Access XP/2002, with a db in Access 2000 format.
I have created a report and am having troubles with the grouping. I am aware
of the "Force New Page", "Before" option.

I created a report to print labels but when I run it I get a popup box that
says "Enter Parameter Value" and the word "Trim" appears below along with a
section for me to enter a command or a value.
If I just click the OK button, the only thing that shows up in the report

Hello to all,
I would like to run 3 different queries from a list or drop down box.
However, I don't know how to code them to achieve this. What I would like is
for a user to be able to run a query for either "Calendars", "Cards" or

I'm trying to print an access report with a background pic and dtata fields
over the top, but it only prints the data fields?  I've checked the setup
dialogue and made sure the print data only check box is not selected, and
tried using the image in an image control and as a ...

I want to print single mailing labels from a database of orders. Right now I
can only figure out how to print a whole sheet of labels each time I print
from a report that  I created in the label wizard.  As orders for my product
come in randomly it would be better for me to be ...

I have a date/time control on a report and in one place I want to force the
month name into upper case. How do I do that using Format?
TIA
Tony Williams

I have the following two variables in query:
sterm (date format)
rdegree (text format, 1 reprent having obtained a degree and 2 having not
obtained a degree)

I have a field that containes data such as H, M, or S.  Is there a way that I
can change the data to Numbers such as  H =1 ;  M=2;  S=3.  I have a
crosstab query that counts that field.  When I have a student that has an H
and  M it creates 2 lines of data.  If I change them toa  ...

When i run a query as a query it works fine. When i try to create a graph
from this query it has an error stating that it does not accept the input
'Please enter a year' as a valid input. That input is from the column 'Year'.
Below is the sql it created.

I have 2 possible reports (reportA and reportB) that I want to preview using
a button on a form.  If there is data available for reportA I would like to
then be able to preview reportA and only reportA.  If there is no data
available for reportA I would like to be able to preview ...

  How to get the current login username to system and not the username of
database in Access2003. I do not want to use Application.CurrentUser because
it gives database login username which may be diff from system username.
cheers,

I am trying to find a way to draw vertical lines in my report. So far, the
object line has beed working great until I turn on the property CanGrow, the
object line does not grow my the detail section.
I tried a few examples I saw in the discussion group and none have worked.

Hello everyone, and happy Monday!
I'm trying to figure out if I can use a report's page footer section to
display summary data for each page on the report. Pretty basic stuff, just
counting and adding fields. I know the report footer does this for me, but

I am getting blank 2nd page in my report, how to get
rid of it?
Thank you,
-M

group number:1        group status:yes
        detail number:xxxx1
        detail number:xxxx2
        detail number:xxxx3