P
polisci grad
I'm trying to design a summary page for common/important statistics. This
will entail having a text box or something like it present the result of
various differnt equations or formulas, and present the result in a differnt
numerical form than how the original data is stored in the main tables. I
just dont know how to do this.
For example, I want one box to show the most recent value of the price of
crude oil, but present it as currency with two decimals - not the raw form in
which it is stored (10 decimals, no dollar sign). I've made it work by
saving a query of the top 1 records, by date descending, and saving the query
with the value column having a currency property, then putting this field as
the rowsource for a listbox. This is probably the most complicated way to do
this - is there a simpler way?
Also, I would like another box to show the percentage change in prices of
crude oil from one period (determined by a combobox entry) to the next (also
a combo box) and display it as a percentage. Any suggestions??
Thanks,
will entail having a text box or something like it present the result of
various differnt equations or formulas, and present the result in a differnt
numerical form than how the original data is stored in the main tables. I
just dont know how to do this.
For example, I want one box to show the most recent value of the price of
crude oil, but present it as currency with two decimals - not the raw form in
which it is stored (10 decimals, no dollar sign). I've made it work by
saving a query of the top 1 records, by date descending, and saving the query
with the value column having a currency property, then putting this field as
the rowsource for a listbox. This is probably the most complicated way to do
this - is there a simpler way?
Also, I would like another box to show the percentage change in prices of
crude oil from one period (determined by a combobox entry) to the next (also
a combo box) and display it as a percentage. Any suggestions??
Thanks,