07-06-2011, 10:19 AM #2 Beetle Duly Registered Boozer Join Date: Apr 2011 Location: Camp Swampy (Denver, CO) Hope this makes more sense.Doug SteeleView Member Profile Dec 13 2014, 05:57 PM Post#4UtterAccess VIPPosts: 20,213Joined: 8-January 07From: St. Access 2010 Report Turn Off Alternate Row Color But these numbers will be used in billing so a decimal for time should work a little easier.   Thank you for that info! 0 This discussion has been inactive for

If you wanted to inspect/ite… MS Access Creating and using Temporary Tables in Microsoft Access Article by: Dale Fye I see at least one EE question a week that pertains to Perhaps you could update the field with VBA after a Requery, instead of a function? Thread Tools Rate Thread Display Modes 07-05-2011, 01:59 AM #1 Scotbot Newly Registered User Join Date: Dec 2010 Posts: 22 Thanks: 0 Thanked 0 Times in 0 Posts #type Get More Info Anyway, I've actually moved on and have been doing this without a calculated field.

Join Now I have a start and finish time that is being used in a query. When Access discovers one calculated control that it cannot resolve, it gives up on calculating the others. Second Issue (more of a curiosity really, not essential that this works as it was just a test): As a test I tried the formula =SUM([Bonus]) on the 'Activity Code Header' Suggested Solutions Title # Comments Views Activity Show Student Records with Picture in Grid format on Form 6 27 30d Allow a decimal place for whole numbers 7 23 29d inserting

It's just numbers changing, too. If your report/page header (I can't remember which is used) is totally collapsed, open it up some. All reports that I make are external files, directly inRTF of HTML. Nothing at all complicated.

Site Message (Message will auto close in 2 seconds)Welcome to UtterAccess! To avoid the problem, test the RecordCount of the form's Recordset. But surprisingly, I was unable to find a single article devoted solely to this topic.