 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / July 2006Make Table Query
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??? Try this for the zeros in the default view under tadle design for that field. "000" > I have a query setup to make a new table and the table set up, I'm all good > there. [quoted text clipped - 6 lines] > > Help??? Try this for the zeros in the default value under table design for that field. "000" > I have a query setup to make a new table and the table set up, I'm all good > there. [quoted text clipped - 6 lines] > > Help??? Tried that, it doesn't work. > Try this for the zeros in the default value under table design for that > [quoted text clipped - 12 lines] > > > > Help??? It works fine in Access 2003. > Tried that, it doesn't work. > [quoted text clipped - 14 lines] > > > > > > Help??? I am using 2000, government doesn't get to upgrade until the software is absolutely obsolete :( > It works fine in Access 2003. > [quoted text clipped - 16 lines] > > > > > > > > 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] 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. [quoted text clipped - 17 lines] > > John W. Vinson[MVP] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.