I'm running a query that totals MTD sales for a
particular time frame and by a sales district.  The query
lists sales by district and then ranks the districts.  If
there are no sales in a district how can I get the query

I've managed to write the code to open up an excel workbook from within
access and then go to a specified named range. However, once that has
happened, I need some specific data to be automatically input into the excel
workbook.

I have a form that asks how many children a person has (text box).  I would
like the number of rows in a subform (linking to the children table) to
equal the number of rows specified by the user.  e.g. 4 children would allow
4 rows for their ages.

I need to create a report or field that will show the difference between a
customer's balance on two different dates for every customer in our
database (for example, see below: I need the difference between customer
001's balance on 1/1/03 and their balance on 2/1/03). I have the ...

I have a cbo which allows the user to select an enquiry
type on a form. The cbo is based on a query with Date of
Enquiry from tblEnquirer and Enquiry type from
tblEnquiryType, as I wish to limit the date range in the

My hat goes off to you if you can help.
I created a form for users to make selections that will
query the database and have written a procedure to execute
the query. I want to give the user the option to make

I have a report that contains multiple columns of numbers. I want to provide
a running total (not a page total) at the bottom of each page.
I have managed to get a running total at the end of each group(by month),
but sometimes, like when a  month is broken over 2 pages, I would ...

Graphical objects cause the database to become unmanageably large very
quickly.
Is there a way to "Link" to objects outside of the database and thereby
better control it's size?

In the following code:
EndDate = rsCompleteEpisodes![End]
rsCompleteEpisodes.MovePrevious
rsCompleteEpisodes![End] = EndDate

I am now battling to pass the result of a SQL string to a variable.
I can access the result that I need through the Dlookup function, but I
would like to get this right in SQL. Is this possible?
I have pasted the SQL string generated

Hi,
I'm wondering if anyone knows of a free tutorial on
learning Access.  I think I have Access 2000 but a later
version would probably be OK.  Thanks.

Using Access 2000, I have an .xls (which is listing of 7600 Items)
I've imported, which I'm *trying* to normalize.  But it seems I've
been chasing myself in query circles that go nowhere :(
Each record has the following fields:

I have a SQL string here that is intended to add the contents of a textbox
into an unrelated table at the click of a button(the table is the rowsource
for the textbox).
DoCmd.RunSQL "INSERT INTO tblLetdownplaces([Place]) VALUES( " & Place.Value