I Have two Tables. the first holds various information with it's own Primary
Key and also a Supplier ID "SW_Opp" that identifies a Supplier. The second
"Suppliers" Table holds the "SupplierNo" number as the primary key and lists
the "SupplierName" plus other info about the ...

Thought I would give it one more try. How do I run a calculation that uses a
field from 2 different tables?
Table A - field, current
Table 2 - field, out

I'm sure there is a simple solution to this, but being fairly new to Access I
would appreciate some assistance...
I have a query that joins two tables. One table has call details for each day
that an agent works. The other table has details for each call that is graded

I am relatively new to access.  I am using access 2007 to create a
report that contains subtotals.  When the report is displayed on the
screen the subtotals are blank.  When the user clicks on the subtotal
text box then the value appears.  The user has to click on each

Can anyone help please, I would like to get an answer to the problem before
Microsoft close down the Forum.
This is the message I posted earlier, for the full background to this,
please read my post (and Ken Sherien's kind answers) titled "Sub Forms" dated

I've been wondering this question for a few weeks now.  My situation is that
I generate many "runlogs" from my reactor that have various outputs, such as
temperatures, sensor data, etc. versus time.  Very frequently, I want to
compare one runlog to another.  Sometimes I want to ...

I have 4 CSV files that I need to somehow link together so that I can query
the data.  I could manually add the data together but would prefer that is
was linked via Access so that it can be automatically updated each month (via
Peachtree).  Some of the columns in each ...

I create a program Audit Tools...and I want Make MassageBox if my subform
empty...I want make massagebox "No Data Found"...What Should I do????

Hi. I need an Access (or maybe Excel) template to help me create bills of
materials. A worksheet with a list of items (record) with the fields "Part
number", "description" and "cost". I then need to be able create a BOM by
entering the "part number" and have the "description" and ...

how can i create sign sheets

Why this function is not working?
If a time follows between 12AM and 3PM it should show Day shift, anything
else Night Shift
If Time > #12:01:00 AM# < #3:00:00 PM# Then

Problem :
I have a DB table with 56 fields and form is on 1 screen. If I filter records
I need result of filter to display in form view. I know it is possible in
datasheet view - but it is not good for me because I need see all fields and

Is the following possible
I have Table 1 with Field IDTable1 [autonumber] [and other fields] and Table
2 with Field IDTable2 [autonumber] and Field GRV set to text [and other
Fields]

I have seen the zillions of answers to this that state "never add a total
into the table.." But there are cases, such as mine when it is prefered.
I want to update a project table with the final invoice cost. I want it
entered as a hard figure so that I can then export the table ...

I really enjoy the Access Database System it has helped me a lot with my
accounts but I must be doing something wrong because, I keep opening new
databases for each month instead of it following on from the previous month
and using the same "Categories!."