Make-table resetting table field value? (1 Viewer)

[DeanRowe]

Hi,

I have a make table query that deletes the old table every time the new one is made. However every time the new table is made it resets the field property for the “Date” field to “Text” rather than “Date/Time”

Does anyone know how I can avoid this problem please?

I’ve tried an update query but Access won’t allow me to perform the sum function that I require the actual query to perform. Any suggestions would be very much appreciated.

Thank you

Dean

 

[KenHigg]

Should you be doing an delete & append everytime instead?

ken

 

[John_W]

Split it into two queries - the first to do your sum function, then the second - based on the first - as an append query.

I guess you'd want to run a delete query first to delete the existing records?

Or if you prefer the maketable, if you used the CDate function to coerce the contents of the date field to a date/time datatype, I'd have thought the maketable query would take note of that and make it a date/time field.

 

[DeanRowe]

thanks for your help guys,

I ran a delete query, then an append query, then the final query to select the data. I didnt realise that append queries allowed sum functions to be used!

Thanks again.

Dean

 

[KenHigg]

Glad to help