Hi There.  I have set up a query with a parameter field to print labels (full
page of the one).  As the first and last name are in different fields, the
last name field appears then the first name SEPARATELY.  is there any way a
paramater field can be a drop down box where the ...

If I have 2 unbound controls on a form, ie. num_no and types, how do I limit
the types to only those types that are related to the num_no and pass these
to a report. (i.e. if num_no=1, then the only available types=A,B; if
num_no=2, available types=A,B,C).  Currently, the tables ...

I made a report from a query. Query has a field which is longinteger. I
didn't add a counter with the wizard. How or where do I add it now? I want
to count all records and print on report footer.
I kind of remember adding in query as a new field?

I created a catalog in Access 2003. Data to the left of the page lists the
name of the product and it's main properties (dimensions, content, and
price). The subreport simply lists all the varieties of each product. How do
I repeat the product name or the word "continued" if the ...

I'm trying to display an estimated gross profit percentage on a report, but I
keep getting syntax error messages and have tried a variety of expressions.  
I'm wondering if anyone could offer some help in creating the correct
expression.

I have a formula that works fine in the report footer (with the
addition of the Sum Fx where appropriate) but bombs by showing #Error
when it is in the detail of the report.
The formula is: =IIf([Minutes]\60>=1,[Minutes]\60 & " Hr " & [Minutes]

I can use a filter equation in another field such as: [Name] like "A*" and
the filter works fine. However I need to do the same thing on a yes/no field
but can't figure out the correct equation. Can anyone help?

Please help.
I have 2 tables: the 1st one contains a field named "Subject Area" with a
combo box listing values in the 2nd table (which has only the subject ID and
the subject names). I created a report based on the 1st table with a bound

I know many people ask this but I still am having trouble understanding
how I can do what I need to do.  Basically, it comes down to the idea
of grouping by one field and sorting by another.
I have tblClients and tblCommissions.  There is a one-to-many

I'm getting a blank line in report text output files: one blank line for
every three report lines, consistently.  I assume it has something to do with
the font size etc., even though I've crammed each line's object up against
one another.  Is there something I'm missing in a ...

I use social security numbers in my database.  I want to show only the last 4
digits of the number on my reports for security reasons.  How do I?

I have a text box and in the control source I have the following:=[AFS Bank
Number] & "-" & [Customer Number]. How would I format this control source so
all numbers show up in the report (ie 03-0000555555)? It's dropping the zeros
in customer number (only printing 03-555555). ...

Please help anyone if you can.
I need to print a report, results of students from a dance school.  I need
to print their results one person per page.  Need to get the information from
tables and queries, but having a problem printing one person per page.  Any

I was wondering if anyone has an idea on how I can create a percentag
automatically.  I have a field with the following as a contro
scource:
=([ReportTotal]/[query!totalpeople!Expr1]) wnen I run the report,

I have an MDE application which tested fine on a test machine and is
installed in several locations without any problems.  We recently installed
it at a client site and they are receiving a "Enter Parameter value Replace"
any time they run a report which uses "=Replace(....)" in ...