I have a report grouped on one field which has four different values.
The total data should fit on to a one page report. It prints each
group on to a separate sheet.
I have the report property:

I have my database split on the server.  Front end is in a Read Only folder,
accessible to many.  Back end is inaccessible to all but me.  When I split
the DB, the table icons changed their appearance.  Do they become like
shortcuts so that, if I delete them, the back end tables ...

I have a table that lists a serial number and a date.  There ar
multiple lines for one serial number, signifying a transaction, fo
example:
SN                 Date

How do I do this?  I want my ofrm to look at something in the query, but it
is not available in hte tabs.

I have an A2002 database, split Front End (FE) and Back End (BE) with Tony
Toews'FE Updater.  Database is working extremely well on a shared server.  I
would like to place the FE and BE and auto updater on a Citrix Server for
user's outside of the shared server firewall.  I've ...

I have a table with a record telephone number where I have to concatenate an
extra digit depending on a condition. I have succeeded to make the
expression.
expr2:<dbname>.<phonenr>

I just upgraded to Office 2003.  One of my pet peaves has always been
that there is no zoom in the design view for Reports and Forms.  Sure
there are kludgy work-arounds like using a magnifier, but, wtf???  Is
there are particular reason MS has decided not to make this view

In my Table (and my Input Form) I have the SSNs formatted so they'll show the
dashes:  123-45-6789.  I am running a Query to export the data into an Excel
spreadsheet, and I need to lose the dashes (123456789).  I've tried changing
the properties of the SSN field in the Query, ...

Hi..
Im new to this and I have a question:
I made a simple Database and a Data entry form.  
How do I make it so that when it opens up, ONLY the data entry form pops up

I have been trying to create a crosstab query which will display a daily
total, monthly total and the yearly totals of our ordered sales.  I have a
daily total query and another query to determine monthly totals for the year.
Both of these work fine, but when I try to add them ...

I have a control from a query that gives me #Error when there are no
records,  I need it to be 0 if the there are no records,  I tried this
but to no avail.
=Nz([NT],0)

I have multi user queries set up on our server that return student
standardized test results to inquiring teachers.  Each query contains
information for all grade levels.  I'm accustomed, when using Excel, to be
able to sort by multiple columns but I'm not seeing how to do this ...

I am trying to develop a data control application that will have to switch on
and off some relays in the real wold! i anticipat this to be with the com
port or printer port!
dos any one know how to make MS Access conect to these ports and control

i'm trying to organize my children's days. on my old pc which i no longer
own, it had a format for it, i can't seem to find anything on this laptop, i
have windows xp.  helllllp please

Hi All, I know it sounds like a normalisation nightmare but it's not
(honest)
I have generated a query from access to select  rows from a table.  I would
like to copy these rows to another table by code ( code run by clicking