robjones23
Registered User.
- Local time
- Today, 21:20
- Joined
- Dec 16, 2004
- Messages
- 66
Hi,
I need a make table query to run when a database is started - that's the easy part.
What i can't figure out is how to set the table field properties as it's created. I need two of the fields to be set as Date / Time however I can't find anything which seems to give me this option. I'm sure it's staring at me in the face - can someone point me in the right direction please??
The fields have to be set to Date / Time to allow another query to run and bring back the correct results.
At the moment, I'm settling for an amend query, however I can't figure out a way to automatically delete everything from the table after the DB has been closed (I could delete the table on close but this isn't helpful as i need the table there to be set with the Date / Time)
I'm probably going about this the wrong way - someone please help me!!
Cheers
Rob.
I need a make table query to run when a database is started - that's the easy part.
What i can't figure out is how to set the table field properties as it's created. I need two of the fields to be set as Date / Time however I can't find anything which seems to give me this option. I'm sure it's staring at me in the face - can someone point me in the right direction please??
The fields have to be set to Date / Time to allow another query to run and bring back the correct results.
At the moment, I'm settling for an amend query, however I can't figure out a way to automatically delete everything from the table after the DB has been closed (I could delete the table on close but this isn't helpful as i need the table there to be set with the Date / Time)
I'm probably going about this the wrong way - someone please help me!!

Cheers
Rob.