|
|
|
|||||||
|
|
|
LinkBack | Thread Tools | Display Modes |
|
#1
02-04-2009, 09:15 AM
|
|||
|
|||
How can I get a calculated field to return the number back to the table?
I have a form that has a calculated field in it is not sending the total back to the table. I have put the formula for the field in the Quary and also tried to put the formula in the Control Source of the field in the form. I need the total on the table so I can use it on a report. HELP!!!
|
|
#2
02-05-2009, 01:53 PM
|
||||
|
||||
Try setting the field with your calculation in the BeforeUpdate event of the form.
__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07 If your issue is resolved...follow this link for directions on how to use the Solved thread tool! Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Setting criteria in a calculated date field | SteveReberger | Access | 0 | 10-29-2008 04:58 AM |
| Text field max number as integer in sql query of MS Access | kamii47 | Queries | 1 | 10-09-2008 02:48 AM |
| Update table from calculated field in a form | BernardKane | Forms | 3 | 11-28-2006 06:48 AM |
| Calculated Text Box Populating in Table | Debbie | Access | 2 | 11-13-2006 05:02 AM |
| Concatenate two fields (text & number) for key field | Larry Elfenbein | Forms | 2 | 11-10-2005 04:45 AM |
Windows 7 
Access 2007 (version 12.0)
Linear Mode
