How would you enter a record between existing records on a datasheet?

I have a complicated report the gets its data from a query, it works
well.  I now wish the use a copy of my report with a different query, ie
with a different Control source.  I know I can specify the query or
Table to be used in my report when it is first set up but how do I

I'm working on my first data base and I've run into a bit of a snag. I have
a few tables but i'm only really concentrating on 2 for this example. My one
table is called Job information which lists: a contract number(primary key),
a description of the job, and all the finacials ...

Why wouldn't the below query post the 2007 and 2008 Totals in a report?  I
get all the other information but I do not get the totals.  Can someone help?
SELECT DISTINCTROW tblMoneyManagerName.[Account Name],
Sum(qry2007Totals.[SumOfCommission Amount]) AS 2007,

I bothered everyone on launching a report from a Combo Box on Friday. That
did not give me exactly what I wanted but it did work. I would like to have
all of the reports which I have listed in a Table appear on the screen with
their description. *****Mission completed.*****

I want to be able to create a chart from some total boxes on my report. The
totals are not stored in any table, but I want to create a chart from them.
The problem is that chart wizard only uses tables or queries to make it's
graphs. Any way to do this?

Microsoft XP Pro - Access 2002
I have a form based on a query (which has calculated fields in it) and
which, in turn, is looking at a linked table ("orders")
From the open form I want to change the value of a checkbox

I went on the Internet with my New HP PC using Vista Home Premium, only to
have an attack from a program called "CLEANATOR" when asked if I wanted the
program I clicked NO!  However the program was down loaded without my
request. How can I get rid of this program?  It is taking ...

I have created a simple 4 table DB and I am now trying to set up a form to
enter data, I am having problems as when I select all the fields I can only
enter data in to some of the fields.... ie if I create a customer address
form it works and a product form that works and an ...

I apogize if there's a double post; first attempt browser said page not
available...
I actually solved that problem by figuring out how to use the
docmd.findrecord. So I was adding and removing controls to try to get the

I have a query with the following fields
Id     Staff Number    First Name     Surname
I need to save the query as a text file using the Tilde to separate the
fields, so it would look something like this.

Thank you in advance for your help! I have two Excel spreadsheets that I
successfully imported into Access 2003 and created tables for. I need to add
the field from one table to the other, but there is not a direct match in the
relationship. The large table uses the Employee ID ...

I have a query which includes the first name and surname
I would like only the persons initial in my query, so instead of
steve goodrich I would get s goodrich
Could anyone offer any advice on how to achieve this please

Hello, I was woundering if this is possible and if so how would I go about
doing it. I have a text box named txtEmployeeTime that we enter how many
hours in decimals an employee worked for the day (Never exceeds 8.00). I also
have a text box named txtDTRegular which we enter that ...

I've been using an Access 2000 (part of Office 2000) database for
several years now for my stamp collection with no problems; but
recently got a new computer using Vista and moved things over. Now,
for instance, get "function is not available in expression in table-