Search results

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...

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...

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...

Thanks for your help, I will be following up on that site, it's these sort of functions that are what makes me marvel at how complex a simple thing can be and a what looks like it should be complicated turns out to be simple. I have just made the adjustments to the "Real" Database and it...

:eek::D It worked where else can I employ this code, can I use it to pull data from other queries for other fields As I have other fields that need sorted totals

ok so joking aside eventdate is what I should call Date Field

You do know that date doesn't appear in that list anywhere I don't have this problem with WYSIWYG Web Builder:rolleyes:

:eek: are you taking the piss

Grouped by Entity Number I'm hoping to be able to get totals for each field for each entity eventually. I can see it being a query for each field some will have count restrictions like the Date we are working with now, some will be restricted by date and another field. Is that a...

Entity Number and Date are the only 2 Fields. Only 2641 words that have special meaning, how could I have not known that :rolleyes: Does this mean I need to rename the Date Field to something else? 'Cause I don't know what else to call it. I'm starting to think that a sub form on the front...

SELECT DISTINCT [Participation List].[Entity Number], [Participation List].Date FROM [Participation List]; Ok :) What next?

OK :) Now have a Query that shows a list of Entity Numbers(ID) and only single dates. :D What's the next step? Will have to get back tomorrow it's 1.30am here time for bed

That's all it told me to do. Is there supposed to be more? It doesn't do anything. The other query's I created I used the wizard for. What am I supposed to know that I don't, about creating a Query manually?

OK Created Query: Attendance Days Query Unique Values set to Yes Next?

Yeah just a measure of frustration, I do really appreciate people's assistance it just gets hard when the answers have a level of complexity beyond me. I'll be giving that query a crack when I get home

Thanks Everyone but :banghead: I have no training, I don't do this for a living, I left school in 1978 at 15, I am conversant with using modern technology but not building it. My latest personal achievement has been to build 2 Tables, 2 Forms, 2 Queries and a Report in Access prior to that it...

I don't want to cull the records they aren't repeats. I just want to count the individual days each member attends. Members may sign in for multiple activities on the same date that's why I cant just count the total number of records.

Thanks Paul, But I don't know what to do with the code or how to make it active. =Count([Date]) this is what is in the Control Source line of the Property Sheet for the "totals box" Can't that have a definition or filter put in it to make it count duplicated dates as one? Thanks...

Cheers SMALL world aint it I'm actually in Wyndham Vale