Counting Repeated Dates as 1

[Uncle Gizmo]

Underscore is fine too. Whichever floats your boat!

Good luck!

I read somewhere recently why you shouldn't use spaces and other non standard characters, it was quite interesting. (Forgot to bookmark it)

Some Access queries can't cope with the square brackets [], causing these queries to fail.

 

[vbaInet]

@Uncle Gizmo: It would have been interesting to see their arguments.

 

[lazydave]

Why on earth would you think that?

Just the amount of time it has taken to build this one DB using wizards, and being told to start doing a line of code, when I haven't even opened a manual query, then being informed that I need to study some Hungarian protocols as well, oh and an improved list as well...... I just thought I was an apprentice and you might be doing the "just pop down the shop for a long weight for the storeman. That's all.

Cheers
Dave

 

[vbaInet]

Access really is a Developer's suite. As a developer you'll first learn the basics and the common/best practices before even attempting to build a full fledged application.
Unfortunately, in your case, you've dived into the deep end only to realise that your application wasn't adhering to best practices.

I think it's sometimes misunderstood that Access isn't as easy or as WYSIWYG with the likes of Word and Excel, so one should approach Access with a Developer's hat on - i.e. follow best practices, know the basics, then attempt to develop an application.

 

[Uncle Gizmo]

then being informed that I need to study some Hungarian protocols

NO... I actually said you don't need to know them.

I also said I don't know them, or adhere to them, (only when it suits me)

I explained that you just need to remember "NOT" to use any real words.

 

[Uncle Gizmo]

You do know that date doesn't appear in that list anywhere

Yes it does:-

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

 

[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

 

[Uncle Gizmo]

@Uncle Gizmo: It would have been interesting to see their arguments.

Hi vbaInet,
I found it!

I started a new thread here:-
http://www.access-programmers.co.uk/forums/showthread.php?t=267020

 

[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!