Hi,
In Excel I have a drop down list that has each month as an item to select from.
The data looks like the following:
Item Jan Feb Mar Apr ...
ABC x x
DEF x
GHI x x x x
When a user selects a month from the list, a macro runs to filer the...
I am using the FormatCurrency() function in the SELECT section of a SELECT-INTO sql query and it's creating a Text field instead of a Currency field. How can I fix this?
Hi,
I am creating a make-table query in sql and when I place the following line,
IIf([Total Payments]<>0,formatpercent([Total Check Payments]/[Total Payments]),0) AS [Check Payment %]
the field that's created in the new table, Check Payment %, gets created as text field. I wan't it to display...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.