T tubar Registered User. Local time Today, 13:08 Joined Jul 13, 2006 Messages 190 Oct 26, 2006 #1 In My Querry If I Want To Round The Answer Of An Expression To The Nearst Whole Number....example 3.97362352 What Do I Do The Expression Is As Followed What We Use In Next Year: [bulbs Per Month]*12
In My Querry If I Want To Round The Answer Of An Expression To The Nearst Whole Number....example 3.97362352 What Do I Do The Expression Is As Followed What We Use In Next Year: [bulbs Per Month]*12
pbaldy Wino Moderator Staff member Local time Today, 11:08 Joined Aug 30, 2003 Messages 36,157 Oct 26, 2006 #2 How about the Round function?
D Dona Registered User. Local time Today, 19:08 Joined Jun 27, 2002 Messages 55 Aug 13, 2007 #3 You can also do the following in design view: right click on the field (your expression) select properties type in fixed for format type in 0 for decimal places save your query Hope this works for you!
You can also do the following in design view: right click on the field (your expression) select properties type in fixed for format type in 0 for decimal places save your query Hope this works for you!
