Tech Support Guy banner
  • Please post in our Community Feedback thread for help with the new forum software! If you are having trouble logging in, please Contact Us for assistance.
Status
Not open for further replies.
1 - 1 of 1 Posts

·
Registered
Joined
·
90 Posts
Discussion Starter · #1 ·
Hi Guys,

Im doing a make table query where one of the fields is blank (i,e Date:Null). Then i want to run an update query which will add in the date field i want. Now the column that i create defaults as data type binary but id like it to default as data type Date/Time. I can go in and change the type after ive created the table and before i run the update but i want this report to run in a scheduled task. If that makes any sense to anyone could you tell me how this is done?

Cheers
 
1 - 1 of 1 Posts
Status
Not open for further replies.
Top