Newbie - assigning calculated value to table field
Just outta curiousity, what type of query are you running? A select
query won't add data to a field! Only an action query will do that.
Hope that helps.
Crying Wolf
Quote:
> I am having difficulty assigning a value to a table.
> I have a form that the user fills out information (contract #,
Company,
> etc., ...), and then he clicks on the button I created to "create
report."
> A query is then run in the background and calculations made, but I
can't
> seem to assign the calculated values to fields in the table. If they
were
> all on the form, it works (using Forms!CompleteReport.Totc =
TotalChildren),
> but that is not practical.
> Any ideas? Thank you for your help!
> S Perritt
--
He who learns but does not think is lost, he who thinks but does not lea
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.