make table with empty columns

[sdkramer]

I want to have a make table query that will create rows that are empty eg make table puts in IDnumber and has three blank columns 1) name 2) description 3) price for instance. I'll be creating a second query to update these columns, but I'll need empty columns.

Thanks,

Seth

 

[dcx693]

Look up the CREATE TABLE statement and the CONSTRAINT clause in the Access online help.

 

[sdkramer]

where is the access online help. I'm assuming you are not talking about the paperclip guy.

 

[dcx693]

Oh, I hate that guy, but he is part of the online help. In Access 97, go to the Help menu and choose Contents and Index. Look it up in the index.

 

[sdkramer]

sorry to be such a pest but i dont' seem to have an index, at least if I do it can't get to it that way. I'm using 2002. I tried typing index in clippy and I got stuff about how to index my tables

 

[dcx693]

Ugh, the help system in Access 2002 bites. I don't have XP on my system, but I have Access 2000. Can you right-click the paper clip dude, choose Options, and uncheck "use the Office Assistant"?

 

[Pat Hartman]

I think you're making this harder than it needs to be. Why would you go through the trouble to create a make table query and then an update query. You should be able to use a single query to accomplish the task. Either a Make-table query that includes all the columns filled or an append query that appends rows to an empty table.