Recent content by schakarian

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?

I tried the above with some modification and can't get it to work... Dim db As DAO.Database Dim tb As DAO.TableDef Dim fd As DAO.Field Dim pp As DAO.Property Set db = CurrentDb() Set tb = db.TableDefs("APA SR Final") Set fd = tb.Fields("WE 1/9/2004 % Scanned") then when I...

Sorry, I meant .12666666666 above

Ooops, I meant .12666666 above

For testing purposes, when I create a table in design mode and set the field to double with a percent format. This is exactly what I want, the long decimal underlying number (ie. 12.666666666), but displayed as a percent (12.67%). But I'm trying to dynamically create this table with code. What...

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...