thanks guys! all set now.
>Hi timothy,
>SELECT count(*) FROM m:4vs WHERE date_l_in =today INTO ARRAY zz
>yournumberofrecords=zz
>
>
>>I am trying to put the value of an sql count(*) operation into a variable rather then a table, can this be done?
>>
>>I've tried "SELECT count(*) FROM m:4vs WHERE date_l_in =today to y1" but I'm not getting a figure when I know it's >1.
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."