Products Subform/Subtotal

[reboot_computers]

Hi Again

I have 2 questions as i'm not sure which direction to go in now. I have a job form which gets most of its information from a table called jobs and on this form I have a subform which is linked to an sales table . All the subform has is a combo box for services and a price , which this bit works fine, you choose the service and it puts the price in on each line as in service and then £39.99 and then hardware diagnostic and then £29.99.

1st question, how do I go about getting a total at the bottom of this table.

2nd question , as the subform is linked to an Sales table which has SalesId,ServiceId, JobId, which all but SalesId are forign keys with relationships to service table and job table. This all works fine but if I ever change the prices it will change everything even past jobs and totals.

Any guidance would be really greatfull as i'm only a newbie.


thanks

 

[burrina]

Example:

=Nz(Sum([GrandTotal]),0)

Is this just for display purposes? If not, it needs to be bound, then it will only change with the correct results.

HTH

 

[spikepl]

Hi Mr. Newbie

A word of advice: your google skills are just as important as your programming skills. 90 % of issues have been dealt with, and learning how to find the solutions is a most effective use of your time. As a newbie, it can of course be difficult to know which words to use, but remember there were other newbies before you, likely using the same search terms

Your second issue can be dealt with in two ways: you can have a table holding rates and date for which they are valid, and link to that. Or, when making an invoice, you insert not links but the actual orderdetail values into the table of invoices, so that data is immutable from then onwards. Programming wise the second options is simpler. It also makes stuff like adresses and customer names immutable, and keeps the beancounters happy (becasue they don't like invoices that change).

 

[reboot_computers]

Hi

Thanks for all the advice. I do use google a lot and as I am a pc repair guy and have my own shop , I have been fixing pc's for 19 years so I am always using google for that. I normally only come and ask the question after I get to the stage where my brain is hurting and I just can't think anmore. Always good tho to remind people that google is a great tool.