M Myriad_Rocker Questioning Reality Local time Today, 14:50 Joined Mar 26, 2004 Messages 166 Feb 1, 2005 #1 I'm doing a calculation within a query...there are more than 2 numbers after the decimal place...can I specify the data type as currency within the query?
I'm doing a calculation within a query...there are more than 2 numbers after the decimal place...can I specify the data type as currency within the query?
sfreeman@co.mer Sam_F Local time Today, 12:50 Joined Aug 2, 2004 Messages 272 Feb 1, 2005 #2 Yes. In the query design view, set the Format Property to currency. HTH