G
Guest
I am trying to fill a query field based on entries in other fields.
FirstSavings,SecondSavings, and ThirdSavings are fields in the table call
fooTable.
I created fooquery to select FirstSavings,SecondSavings, and ThirdSavings
from fooTable. I want to add another query field called
fooquery.CurrentSavings that will
pick the latest dollar amount of the three fields and put the value into
CurrentSavings.
Please look at the example below to an idea of what I mean.
EXAMPLE
fooQuery
FirstSavings SecondSavings ThirdSavings CurrentSavings
123 433 345
345
123 0 0
123
564 589
589
FirstSavings,SecondSavings, and ThirdSavings are fields in the table call
fooTable.
I created fooquery to select FirstSavings,SecondSavings, and ThirdSavings
from fooTable. I want to add another query field called
fooquery.CurrentSavings that will
pick the latest dollar amount of the three fields and put the value into
CurrentSavings.
Please look at the example below to an idea of what I mean.
EXAMPLE
fooQuery
FirstSavings SecondSavings ThirdSavings CurrentSavings
123 433 345
345
123 0 0
123
564 589
589