G
Guest
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???
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???