C
Crazy Lady
I have a form "orders", created from a Table. I have a subform onto which I
enter the details of the order. When updated, this subform then acquires a
subform which show the results of a whole series of queries and calculations.
The only way I could achieve this in the way I wanted to, was to link 6
queries to 1 table in the relationships window.
The queries are all different calculations of quantities and values based on
the type of product. There is a 7th query which totals all those values, but
there are three different totals. 'Start value', 'ongoing value' and 'finish
value'. The 'ongoing value' increments on a daily basis until 'finish
value' which could be several months or years after start value.
Currently, in a spread sheet, I create a copy of the spreadsheet, I FREEZE
the data as it were by entering the invoicing date into the no. of days
calculation. I then have a 'Total to Date' column, a 'previously invoiced'
column and a 'Balance this month' column. Once the date is frozen, I add
another column and sum 'Previously invoiced' and 'balance this month' then
copy this column and "paste special - values" into the 'previously invoiced'
column of the original spread sheet in which no date values have been frozen
and the daily calculations will continue, but the balance values have been
reset by the paste values action.
I want to do something similar with the database. I want the values in the
field 'previously invoiced' to be updated on command and as per a given date
with the value of 'previously invoiced' and 'balance'.
I may be asking too much. I am wanting to view all current values in form
view (as I now do in spreadsheet view).
Also, when I have created the reports, I want to be able to look at the
exact values as invoiced for any past month. That is, the monthly invoicing
would have to be saved as monthly invoicing. Is this going to be messy and
inelegant?
Thanks in advance for your help, if you can
Crazy Lady
enter the details of the order. When updated, this subform then acquires a
subform which show the results of a whole series of queries and calculations.
The only way I could achieve this in the way I wanted to, was to link 6
queries to 1 table in the relationships window.
The queries are all different calculations of quantities and values based on
the type of product. There is a 7th query which totals all those values, but
there are three different totals. 'Start value', 'ongoing value' and 'finish
value'. The 'ongoing value' increments on a daily basis until 'finish
value' which could be several months or years after start value.
Currently, in a spread sheet, I create a copy of the spreadsheet, I FREEZE
the data as it were by entering the invoicing date into the no. of days
calculation. I then have a 'Total to Date' column, a 'previously invoiced'
column and a 'Balance this month' column. Once the date is frozen, I add
another column and sum 'Previously invoiced' and 'balance this month' then
copy this column and "paste special - values" into the 'previously invoiced'
column of the original spread sheet in which no date values have been frozen
and the daily calculations will continue, but the balance values have been
reset by the paste values action.
I want to do something similar with the database. I want the values in the
field 'previously invoiced' to be updated on command and as per a given date
with the value of 'previously invoiced' and 'balance'.
I may be asking too much. I am wanting to view all current values in form
view (as I now do in spreadsheet view).
Also, when I have created the reports, I want to be able to look at the
exact values as invoiced for any past month. That is, the monthly invoicing
would have to be saved as monthly invoicing. Is this going to be messy and
inelegant?
Thanks in advance for your help, if you can
Crazy Lady