Counting Repeated Dates as 1

[vbaInet]

Yes it does:-

Date/Time ........ dtm

I think Dave thought you were showing him a list of reserved keywords.

 

[lazydave]

Yes it does:-

Date/Time ........ dtm

Not helping Uncle Gizmo.... I have enough trouble understanding what I do need to know let alone having to know what I don't need to know.

What I am going to do when this database and reports are up and running is lock it up with a password and then use it, chances are this may be the only database I ever build with this level of complexity, a relative term, complex for me, not for you maybe.

I do appreciate help and acknowledge it when I get it.

Cheers
Lazy Dave

 

[lazydave]

vbaInet Thanks for all your help with my problem, as is usual, in my world anyway, when you don't need something any more it turns up.

Just after we got through solving this I had a club member get in touch asking if I needed any help with the database, needless to say she is now working her fingers to the bone solving all my problems.

While I marvel at what she has achieved in hardly no time at all. I have done the "OMG You can make it do that" so how about we now include this and that and can it look like this.....

So I suppose I have now become the "Customer" from hell as opposed to the Ignorant Amateur Builder from hell.

Thanks again for your help and I will probably one day darken your door with a way more complex query on something I didn't build

 

[vbaInet]

Well it's nice to be chauffeur driven sometimes

We're here when you need help, just shout... literally!