Search results
-
P
Sum of calulation in subform not working?
Hi There, I have a field in my subform that I'm calculating using a value from the main form [RE_Forecast_PPod]: =[Cppm]/1000000*[Qinj_m3d]*1000/Forms!RE_Forecast_PPod!Bag_size_kg*7 This is working correctly. What I then tried to do was create a Sum of this field in the footer of the... -
P
Creating duplicate records with Form command - sql error
Hi There, I have some experience with sql, but limited experience with access. I am trying to create duplicate parent and child records using a form. I have added the following VB code and I keep getting a syntax erro in insert into statement. I'm hoping (praying) it's something simple that I...