I'm having difficulty with the DCount function, not getting the
results that I want.
Field1A and Field2A are fields in TableA matching Field1B and Field2B
in TableB

only example some records have $231.035, which shows when you click in it.
how can i fiilter these out to correct them?

I have a subform that totals a list of values, then
I place this sum in a form. The Control Source for the
field containing the sum is as follows.
Control Source:  =[subfrmBasis].Form!TotalShares

The query in question is linked with two tables. Table One has the route No.
(Primary Key)  while the child or table Two has the Action ID (Primary
Key) with the RouteId from table 1 as its foreign key.  
I want to see the routes which have not been updated from  date -30.  

Not sure why, but I have one table with ID, DOB.  2nd table ID, DOB.  
When I try to update table2, Table1 field is emptied but table 2 not updated.
Any ideas?
Thanks

I have a query that I want to select records based on two sets of criteria.  
I want to select if the ship date is less than two years OR there is a qty on
hand.  How would the query be setup?  Thanks for your assistance.

I have 5 tables in my database each with a donation amount field.  The
ultimate goal is to make a report that displays the total seperately from
each of the tables (based on a date range).
For example, Donation Amount in Table 1 for all donations between 01/01/05

I am using an access front end and sql backend, but my queries stop at
10,000 records although I know for a fact that there are more.
Query analyser brings out the exact amount therefore i know that it is an
access problem.

   I need to merge two tables together.  Let's call them Names and
Addresses.  Names has one record per contact and about 10,000 records total.
Addresses has up to 4 addresses per contact and about 400 records total.
Names Table fields:  (PK)id, firstname, lastname, etc.

I am trying to track inventory of products in multiple warehouses. I need
to keep a running total at each warehouse so I can view and analyze
historic usage at each site.
To achieve this, I set up an inventory table for each warehouse. For my

Hi  everyone
I got a form set up that is supposed to bring in to values from a table
(TABLE A) and based on user entered information into the same form I got to
do some simple math and store the data in another table (TABLE B).  The

Below is a Query to drive an SQL2000 Access View query. I am trying to make
the function work in the View. It works in the standard Access query, but not
a View query. How do I need to adapt this function? The function is a date
finction that says that a week starts on Monday ...

I don't understand the concept of what makes one query updatable and another
not updatable
I would like to update records directly from my form but this is not an
updatable query.  What do I need to do to make this updatable?  .

I have a query that only singles out my boxes that are checked.  But all the
numbers are -1.  I know that's how Access recgonizes True, but now that I'm
building my report I have -1,-2,-3.  How do I just have it count positive not
negative?

I have a need to query an access database to find records where entries have
all been completed in a linked table but x field hasn't in the originating.
Data - Table 1
- intRefID