Recent content by andyj-84

Hi RainMan, By normal I mean dd/mm/yyyy. I've been applying the function in the Field row of the Query Designer e.g. Appt: Format([F3],"Short Date"). Thanks

Hi, I'm trying to create an append query using the standar query builder. A couple of the fields are date formats but the source data has them has dd.mm.yyyy Is there a way that I can convert, and append, the data as a normal date format without amending it at source. I've tried Format...