Afternoon all,
I have a hopefully simple requirement and cannot make access do what I want. Hoping an expert here can point me in the right direction.
Background:
4 tables in Access(more will be added later)
called
Log
ABC1
SDV2
FGB3
'Log' table has 2 columns (and others that are not important for this but are needed in the table.
Table Name
Count
(so has 3 rows created in it manually - ABC1, SDV2, FGB3 and nothing in the count column)
ABC1 has a number of columns as do the other two tables.
What I want to create is an update query (assume this is the right option)
that
does a row count of each of the 3 tables
and inserts that count into the Log table against the corresponding 'table' entry
So to clarify
if ABC1 had 98 rows of data, SDV2 had 50 rows of data and FGB3 had 25 rows of data
Before running the update the 'Log' table would hold
ABC1 -
SDV2 -
FGB3 -
And after running the update the 'Log' table would hold
ABC1 - 98
SDV2 - 50
FGB3 - 25
My question is how do I go about doing this?
I can write a simple query that does the count - but when I try to create an update query to point to a specific cell in the 'Log' table Access does not do what I want.
Thanks
Jon