thanks, its FINALLY working wright
maybe you can help with something that i just can seem to find a way to do it.
I have a table with the fields user, date, study and I need a button that allows me to enter more than one study,i was thinking to increase a field named study1 and so on.
something like this:
if study00 = "" then
study00 = 1
study00 = "study00" + 1
ALTER TABLE ADD studys "'& & study00'" memo
But then when you do the same thing with another user I check all the columns to see which is empty and insert it?
Any idea the best way to do this?