Forms, calculated fields, sql in macros, random numbers?

Hi Hoo Here Again

I was messing with forms and got the feeling there are no calculated fields, 
true?
Anyway I couldn't solve right formula in Data field to calc number from 
table +1. I tried to write many formula variants to "Data field" of 
Properties of  "Formatted Field". Nothing helped.
I have used Paradox and Access so I think I'm not extreme beginner...<|:)

So...perhaps then to SQL and macros because I need random numbers in 
calculated colums and I didn't find any random commands from 2 
SQL-manuals...

So could someone throw me with simple macro how to to embedd and run 
SQL-query in macro. I think I can manage to stuff variants with randoms to 
macro myself.

Hoo