Does anyone knows what are the operator in access for rounding cents.
E ewart Registered User. Local time Today, 23:38 Joined May 22, 2002 Messages 10 May 22, 2002 #1 Does anyone knows what are the operator in access for rounding cents.
L llkhoutx Registered User. Local time Today, 17:38 Joined Feb 26, 2001 Messages 4,018 May 22, 2002 #2 Access has a rounding function.
E ewart Registered User. Local time Today, 23:38 Joined May 22, 2002 Messages 10 May 23, 2002 #3 Sorry for not explaining myself entirely, my true problem is trying to suppress the two decimals places in a query.
Sorry for not explaining myself entirely, my true problem is trying to suppress the two decimals places in a query.
R RV Registered User. Local time Today, 23:38 Joined Feb 8, 2002 Messages 1,115 May 23, 2002 #4 Look in Access Help for the functions Int and Fix. RV
E ewart Registered User. Local time Today, 23:38 Joined May 22, 2002 Messages 10 May 23, 2002 #5 Thank you kindly.