Recent content by CMeads1975

Hi I have two dates, for arguments sake date1 and date2 i want to take one from the other and show as either dd hh mm ss or hh mm ss where hh may be greater than 24 Date1=01/10/10 14:24 Date2 =06/10/10 09:36 I want the answer 4 Days 19 Hours 12 Minutes or 111 hours 12 minutes but when i do...

I'm trying to connect to my odbc source via an active x microsoft pivot 9.0. I cant seem to attach any data source to it, does anybody have any ideas?

You could try: >=07/10/02 and <07/25/02 where format is mm/dd/yy Carl.

I'm not sure if this is the right area but I've just found an active x pivot table, and I've placed this in a form, however i do not seem to be able to attach a table or a query or even an odbc connection as the data source. Does anybody know if this is possible or am I barking up the wrong tree...