Kitana907
Last Activity: Sep 7 '07, 03:07 PM
Joined: Sep 8 '06
Location:
-
The field in common is a text field called ISBN.... -
Looping in Module in Access Help
Hi-
I'm attempting to write a module that uses and updates info from two tables and does the following:
Opens the recordset of a table called "tblstorein v"
If the Needed Field in the tblstoreinv table is null and is less than the DCOH field from the tbldcinv then:The Shipped Field in the tblstoreinv table equals the Needed Field and the DCOH field from tbldcinv = DCOH - Shipped
Else If... -
Thanks, but I still get an error...
When I try to save the change, Access eliminates the brackets around the OH, so it ends up reading:
=Sum([tbletempreturnw orkbook subform].Form!OH)
I tried using the expression builder in Access to read off the table where the data is coming from and then I tried the subform, but still nothing.
Is it possible to do what I'm trying to do in Access? I know...Leave a comment:
-
Text Field in a Form summing up the Values in a Subform
Hi-
I am having issues with adding up fields in a subform. I have a form that has a subform in datasheet mode. It lists titles of books with their correlating units [OH] and dollar amount [OHExtRetail].
The user will be able to delete records from this subform. I am trying to add in text boxes that list the sum of oh, the sum of extretail, and the count of titles.
I have tried it the three ways below with no...
No activity results to display
Leave a comment: