Recent content by velausanakha

RESOLVED but Confused SELECT DISTINCTROW Format$([Stats].[daymonth],'mmmm yyyy') AS [daymonth By Month], Stats.Service, Stats.Code, Sum(Stats.Phone) AS [Sum Of Phone], Sum(Stats.Person) AS [Sum Of Person] FROM Stats GROUP BY Format$([Stats].[daymonth],'mmmm yyyy'), Stats.Service, Stats.Code...

SELECT Service, Code, Count(Phone) AS CALLS FROM [Service Between Dates] WHERE Phone<>False GROUP BY Service, Code; Gets me the calls I like SELECT [Service Between Dates].Service, [Service Between Dates].Code, Count([Service Between Dates].Person) AS PEOPLE FROM [Service Between Dates] WHERE...

I have reposted

I have a single table daymonth Date/Time Time Date/Time Service Text Code Text Service Name/Coordinator Text Phone Yes/No Person Yes/No So daymonth represents the actual date in dd-mm-yyyy format Phone and Person are checkboxes, they should have been radio buttons but I have too much data to...

Yeah that's the only one I can find too. You may be right. There may have been a glitch. I guess I shall post it again shortly or at least something similar because I don't seem to have yesterday's paperwork that it was based on here.

Hey Guys, I'm not really new or a newbie but it has been that long since I've dealt with this stuff. I swear I posted a complicated question in the Queries yesterday. I think it may have been deleted since I haven't exactly been active and I can't find it in a search. However I do need help...

I should probably clarify by form, I mean an Access Database form

I have the clientNo in Client as an AutoNumber as it is also the Student Number, the Stud_Num didn't like being an AutoNumber linked to an AutoNumber before. I shall try again though. Same result, complains about the relationship It has been quite a few years since I touched this stuff

Not really a newbie but it is a newbie question and I have never approached it from this angle. (Access 2003) This is my database and relationships. I know I could've used an extra table but I got tired of a certain roadblock Now I have one big form for new people to fill out that become...