Hey, I figured it out myself and here is an explanation of what wasn't working and what worked in case someone else is at the same holdup.
The goal: use a calculated value (a single max record) that is output in a select query in a mathematical expression with another table.
The problem: I needed to establish a "relationsh ip" in access between the output max value with the original table it was derived from....
blake15
Last Activity: Dec 15 '07, 07:08 PM
Joined: Mar 3 '07
Location:
-
ps I am using MS Access 2003 and I've got all my data in a single flat table with no set relationships
perhaps I need to establish relationships to get the single max value back into a query to update records in the master table?
Using the expression builder I have attempted to use an update query to do this:
[master]![Chin_Abun]/Max([master]![Chin_Abun])
where master is my table and "Chin_abun"...Leave a comment:
-
Help with using the results of one query in another query
Hey,
I'm desperate for a clue in on how ms access can do this: I'd like take the maximum value from one field and then populate another field by dividing the values of the first field by the max.
An Example:
Field 1 Field 2
1 = 1/3
2 =1/3
3 =3/3
Rather than just using an update query to populate field 1 by dividing it by...
No activity results to display
Leave a comment: