Creating Table In Vb - how to set field type 1

[fredka]

I am trying to create a tempoarary table which among other things takes the date that is entered on a form and adds that to the table. The field on the form is a combo box... the problem I am having is the data is not getting passed. When the table is created, it makes this field a binary. I think that is what is preventing my date from passing from the form to the table. Any help would be greatly appreciated!!!

strUpdateFinanceHistory1 = "SELECT tblFinanceNumbers.SECTOR_DESC, tblFinanceNumbers.BaseGroupStatus, " & _
"tblFinanceNumbers.Status, Sum(tblFinanceNumbers.StartingMEMBERS) " & _
"AS SumOfStartingMEMBERS, Sum(tblFinanceNumbers.CurrentMembers) AS SumOfCurrentMembers, " & _
"IIf(Sum([CurrentMembers])>=1,Sum([CurrentMembers]),0)-Sum([startingmembers]) " & _
"AS [Increase/Decrease], [forms]![frmUpdateFinanceData]![financefiledatea] As financedate INTO c " & _
"FROM tblFinanceNumbers GROUP BY tblFinanceNumbers.SECTOR_DESC, " & _
"tblFinanceNumbers.BaseGroupStatus, tblFinanceNumbers.Status, " & _
"forms!frmUpdateFinanceData!financefiledate;"

 

[PHV]

What about this ?
..., #" & [forms]![frmUpdateFinanceData]![financefiledatea] & "# As financedate ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[fredka]

I always learn something from you.... thanks so much PHV .. I really appreciate it !!!!

FRed