[eluser]reghan[/eluser]
Thanks for the reply.
I have set the money column to
null = no
default = as defined: 0.00
and it still gives me the truncate error:
Error Number: 1265
Data truncated for column 'Day1_LostRevenue' at row 1
for the column that I have set the default to 0.00.
SO I am really unsure what the problem says. I totally agree with your answers, but its just not working.