I have created a Report that has totals and within it is a Subreport
that has its own total.
What i want to do now is to add these two sets of totals together to
create a Grand Total but i really do not know how to go about it.

Does anyone remember if and how to reset previously autonumbered records?
Thanks.

How does one make sure that a query result table opens at maximum window
size, or at least at the size that maximizes the contents? One of my tables
insists on opening at a minimum size. I use a form to display the query
results.

Hi.  I have originally posted this question and got the answer but I cannot
seem to find the original post.  so sorry, I am posting again.  My question
was, I wanted to created a combo box or dropdown list with such values : "10,
15, 20, 25" or simply a text box for user to enter ...

Looking at the possibility of using Excel 2000 to send out email through
Lotus Notes.  I use the spreadsheet to track project and would like to use
the spreadsheet to send out emails of any changes to the members of that
project team automatically

I'm fairly new to Access.  Have a spreadsheet I am trying to copy / import
that has a date field.  This date field is in a Month-Year format, i.e.
Apr-06.  I have entered the data in Excel as 4/1/06.  I have months that go
back to 2003.  However, after importing, all of the ...

I have a form frmClntsAgents for which the Record Source is qryAgents which
filters the table tblGlobalClnts for the value “agent” in the ClientType
field in a related table tblClientType  -  tblClientType has two fields:
ClientTypeID and ClientType.

Anyone have any good links to info on how general accounting databases are
set up ? I am putting something together in Access to link my inventory and
invoicing system with but would like an idea of the general layout of the
various Tables etc used in accounts systems.

I am a VERY new Access user...
I have 15+ tables, each with identical field names (linked sprdshts from
Excel), and each containing schedule information for a specific project.
I am trying to create an interface that would allow each project manager to

I am very new to this but so far have managed to create a small database
with a few tables linked together and a few queries.
I have also created some reports and forms.
Using the switch board I would like to open a form, which has been filtered

I would like users to print, using a print button shown on my forms. I
already have the buttons created and properly labeled, and I have reports
already made for each of my forms. What VBA code do I enter in order to make
a print button actually print the report? Thanks.

Hello, I deleted a lot of records in the db. Now I have 85 records, with
addressid's in the 500's. Is there a way to reorder the addressid's so they
reflect the current records in the db.
Records increment by 1 as well as the addressid, but record # 55 may reflect

I have a database containing table "tblCustomers" and
table "tblPayments".
Now, I want to run a query to Insert new payments for certain
customer that have some criteria. That is, if the customer has

I'm pretty new to access, but not so new to DB's.  Alas - I'm slightly
more proficient with SQL than with Access 2003's GUI tools like
expression builder, and specific microsoft things like VB Script.
</preamble>

Can you move words in a drop down box to another call.