Search results

Thanks for the reply. I actually had Or in there originally and was getting the same result, And was what was in there by the time I copied and pasted the code into my original post. I appreciate what you're saying though and you're absolutely right, the logic of the statement is incorrect...

You know what? I'm actually using a similar statement in another column to strip trailing milliseconds, so quite why it didn't occur to me to try that on the date column......it's been a long week already, that's my excuse! Thanks Trevor, your help's much appreciated.

I have a table called 'Logon' which contains 6 columns. The first column contains a date in format DD/MM/YYYY. Some of the dates are preceeded by the day name, for example 'Mon', 'Tue' etc. I need to remove the preceeding day names and so have created a make take query. The query looks at the...

Nevermind, I got around it by exporting the data in a different way. Glad to see that it wasn't just me that was stumped by it though! ;)

Yep, I'll 2nd that. I missed Doom by a couple of years and a demo of ROTT was available just as I started getting into PC gaming. Absolutely loved the way some of the baddies got on their knees and held their hands up, just begging for an execution style headshot :D That said, I picked it up...

First off, I just want to say hello and apologise if this isn't the correct forum for my question. The question relates to some VBA code which exports a table built using a query off the back of user input into a form. So I wasn't exactly sure which forum this should sit in; Table, Query, VBA...