Make Table Query

[jjacob]

I have a query setup to make a new table and the table set up, I'm all good
there.

Here is my problem. I need to convert a date from 11/22/1999 to 11221999 on
the new table, can't figure that one out.

Also I have a text field that needs to default to "000" 3 zeros, I can only
get one 0 to show.

Help???

 

[gumby]

Try this for the zeros in the default view under tadle design for that
field.

"000"

 

[gumby]

Try this for the zeros in the default value under table design for that

field.

"000"

 

[jjacob]

Tried that, it doesn't work.

Try this for the zeros in the default value under table design for that

field.

"000"

 

[gumby]

It works fine in Access 2003.

Tried that, it doesn't work.

 

[jjacob]

I am using 2000, government doesn't get to upgrade until the software is
absolutely obsolete

 

[John Vinson]

I have a query setup to make a new table and the table set up, I'm all good
there.

Why a MakeTable? They are VERY rarely necessary. If you need to do an
Export or a Report, just base it on a Select query instead, and avoid
the overhead and inflexiblilty of MakeTables.

Here is my problem. I need to convert a date from 11/22/1999 to 11221999 on
the new table, can't figure that one out.

Use NewDate: Format([datefield], "mmddyyyy")

Also I have a text field that needs to default to "000" 3 zeros, I can only
get one 0 to show.

Are you certain it's Text datatype? Perhaps you could post the SQL of
the query. Note that MakeTable queries don't necessarily give you much
control over datatypes; you may want to create the desired table,
empty, and use an Append query to fill it instead.

John W. Vinson[MVP]

 

[jjacob]

John,
Thanks I've gotten the query to run properly. I really appreciate your help!

I have a query setup to make a new table and the table set up, I'm all good
there.

Why a MakeTable? They are VERY rarely necessary. If you need to do an
Export or a Report, just base it on a Select query instead, and avoid
the overhead and inflexiblilty of MakeTables.

Here is my problem. I need to convert a date from 11/22/1999 to 11221999 on
the new table, can't figure that one out.

Use NewDate: Format([datefield], "mmddyyyy")

Also I have a text field that needs to default to "000" 3 zeros, I can only
get one 0 to show.

Are you certain it's Text datatype? Perhaps you could post the SQL of
the query. Note that MakeTable queries don't necessarily give you much
control over datatypes; you may want to create the desired table,
empty, and use an Append query to fill it instead.

John W. Vinson[MVP]