Steve said:
Base your sobform on a query and do the math in the query. Put the following
expression in the first blank fileld:
ExtendedCost:[Quantity]*[Cost]
Set the control source of a field on your subform to ExtebdedCost.
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
Hey Steve !!
Well... We did know that you are NOT an Access resource at all !!
But .... A REAL resource you are with Excel .... Ha ha ha. !!
Asking questions about looping a spreadsheet, asking about Excel-events, not knowing how to add buttons and code ???
http://groups.google.nl/group/microsoft.public.excel.programming/msg/d7d79687dec86195?hl=nl
http://groups.google.nl/group/microsoft.public.excel.programming/msg/a4a8b9b40fe5c313?hl=nl
http://groups.google.nl/group/microsoft.public.excel.programming/msg/46a46c0dc6dc9c15?hl=nl
Curious about your Word skills... You DO know that you can bold text and such ??
This is to inform 'newbees' here about PCD' Steve:
http://home.tiscali.nl/arracom/whoissteve.html (updated, mainly the 'abuse-reporting' page...)
Until now 3950+ pageloads, 2500+ first-time visitors
(these figures are real and rapidly increasing)
Why is this ???
Because Steve is the ONLY person here who continues to advertise in the groups.
It is not relevant whether he advertised in *this* particular post or not...
==> We want him to know that these groups are *not* his private hunting grounds!
For those who don't like too see all these messages:
==> Simply killfile 'StopThisAdvertising'.
Newbees will still see this warning-message.
ArnoR
