Quick Question for whomever is awake....
I have two tables in this format:
TABLE1
ID - Key
Date - Key
ValueA
and
TABLE2
ID - Key
Date - Key
ValueB
ColumnC
What I am trying to do in Access/Sql is create a query that will Divide TABLE1.ValueA by TABLE2.ValueB and write the results to ColumnC, for each Date.
Cheers,
Simon
I have two tables in this format:
TABLE1
ID - Key
Date - Key
ValueA
and
TABLE2
ID - Key
Date - Key
ValueB
ColumnC
What I am trying to do in Access/Sql is create a query that will Divide TABLE1.ValueA by TABLE2.ValueB and write the results to ColumnC, for each Date.
Cheers,
Simon