sql statement problems..

hello, I have a few questions..

1) How do you use the INSERT INTO command and only insert values into specified fields?

2) How do you use the INSERT INTO command when there is an AUTO NUMBER field?

3) In a numeric field, how do you return the highest number?

Thanks!

Thai

Check out this site, Thai:

http://w3.one.net/~jhoffman/sqltut.htm