robert, i guess phillip got busy :)...so i'll pinch hit for him...
in access design view, click on the field name then make sure field size (general tab) is set to long integer and decimal places is set to auto. that should eliminate your problem with rounding. if you want to multiply the value of costeach by a qty and project the result as a total, you would do this in the select statement of your query: sum(costeach * qty) as total_costeach then reference total_costeach for display. just be sure to list any non-aggregate columns projected in your select statement in a group by. ~ dina ----- Original Message ----- From: "Robert Orlini" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, May 24, 2002 9:47 AM Subject: RE: update a dollarformat field > Thanks much Phillip. One further question though. > > In Access I have the costeach field setup as numeric. Each time a figure is entered with cents after, it rounds it off to the next amount (350.60 becomes 360). How can I keep it as 350.50 and then at some point have this number calculated via a qty number and total? > > Robert O. > > -----Original Message----- > From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] > Sent: Friday, May 24, 2002 10:35 AM > To: CF-Talk > Subject: RE: update a dollarformat field > > > > OK, now I understand. Costeach is a number in the Access table. > > > > However, is there any way to make the number, let's say > > 1300.50 appear as $1,300.50 when displayed, but as 1300.50 > > (stripped the $, etc) when updating? > > What you have to do is before you update; > form.CostEach=ReplaceList(form.CostEach,"$","","all"); > form.CostEach=ReplaceList(form.CostEach,",","","all"); > > That way it's removed the excess characters > > Philip Arnold > Technical Director > Certified ColdFusion Developer > ASP Multimedia Limited > Switchboard: +44 (0)20 8680 8099 > Fax: +44 (0)20 8686 7911 > > www.aspmedia.co.uk > www.aspevents.net > > An ISO9001 registered company. > > ***************************************************************** ***** > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. If you have received this email in error please notify > the system manager. > ***************************************************************** ***** > > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
