When I run an access query linking two talbes, the query is only picking up
45 out of about 450 records. As yet I've selected no criteria in any of the
fields.... Going round and round here, please assist

Hi...thanks for your constant help in my Access queries.
I need some help in putting effective sequence in my reports.
I have a HISTORY table that captures all the history job data of an employees.
It contains the following fields : EmpID,

I need to setup a database query on all the items we stock in our warehouse.  
We have 88,000 part numbers and right now I just have everything in 2 tables,
but I know I will have to change that in order for a query to work.
What we use is a 3 digit code for the mfg., the part ...

How can I add an Access table to a Form or Report. I need to be able to
export the table to another program. If I export a "manufactured" table
built box by box, it looks good in Access but when I export it to Excell so
that I will be able to copy it and paste it into another ...

I have a crosstab query with a memo field used to store comments.  The
results of the memo field are odd characters rather than text.  A text field
works fiine.  Is there a way around this?

What I'm looking for is an average (Monthly) for payment methods. For
example what percentage of payments for this month are in Cash, Check,
Credit Card, Money Order etc.
The Tables this is on are:

I have been struggling with a way to combine these queries and wondered if
there was a way to Union them somehow.  As you can see, one of them is a
UNION query.
Query1 (crosstab):

For example, if I have a table with the foloowing 3 fields: ID, city, state.
There are no null values for the Id and city fields.  But there are some
null values in the state field.  If any record contains a null value in the
state field, I would like to populate it with the state ...

I want to add numbers of rows of same field.  I have two fields - Department
and Total Charges.  I want the total charges for one department.  Presently
there are many rows of same department with total charges.  I want to sum all
the charges in one cell for one department.

Can I use update and alter table together in a query?

I need to select the most current sales price from a table that has multiple
sales prices for the same item depending on the effective date of the sales
price.  For example XYZ Item was $1.50 as of 3/2/2001, $2.10 sa of 6/3/04 and
$2.30 as of 8/1/05.  I want to bring back only $2 ...

I am trying to update a record in VBA by using the DoCmd.RunSQL command.  The
string I am trying to use is:
"UPDATE tbl_building SET checkintime = " & me!checkintime & " WHERE building
= 'GG';"

I'm trying to have an open query automatically update after new records are
added to the table.
I created the query for a specific user. I then have the user open the query
on their pc. When I add new records to the table from another pc, the open

In an access 2000 format database that links to another access database
that has a table with about 30,000 records. When viewing the table in
datasheet mode the last record can be selected with in a few seconds.
On query that uses this base table and joins to about 8 other tables

I have 2 tables, and I want to combine the records from these tables in a
query, but I don't want to match on any field.  Instead, I want to just put
all records from both tables together in one query.  I know I could do this
using Append queries to put records from both tables ...