Recent content by Onslaughtdave

Cheers

Hey! That worked like a charm! I put ur posts together and i got results LOL I used your(SuicidED) sql from above with his(PHV) year part and it worked like clockwork! my thanks to both of you! who would have though that sql class and access would come in handy when i started to work heh!

:D no its not homework lol no need to worry im at a coop placement(work placement) and havent used access in a bit lol and i figued that its not displaying the year on the bottom. so your code does work lol i wasnt understanding what my graph was telling me. how would i get it to display the...

ok, i did remember something from first semester ;) sorry about all the questions ... but now it is displaying for ex 144... where does it get 144 lol 1994 is 144? 1995 is 182? ... hmmm is it converting the date to something else? like in seconds or whatever... thanks

well the date is in mm/dd/year but the data is like 1/15/2004 - would it still be 4 or in this case 6? does it count /'s Is there a right funciton instead of mid? like maybe right([table.date], 4)?

SuicidED, Again, works great! however, i forgot to mention that my date field is the entire data...my mistake! is there a way to only capture the year out of the data? thanks for all your help!!!

SuicidED, That works great! however, how would i get it to do that for every year? eg) | | count(anum) | | |__________ year right now it only says one year. thanks for the help!

Hi, I am tring to get this query to work but have lost all hope ;) there is a yes/no field in one of my tables and im tring to get a count of true and a count of false so i can graph the results. However, im getting quite the mess! I got it somewhat working use this query/sql statement...

hmmm... indeed it sure does...ha my mistake...

Another question... where do i requery the combo box?

yes! ok thanks that did the trick! thanks for your help... PHV and FancyPrairie.

where would i use the limittolist?

FancyPrairie, where do i put that? it wont let me click off the text field so i cant press anything. what trigger is catching this?

Hi, Is there a way to discover which events are firing as i do things? in the case that there isn't this is what im tring to do: there is a combo box with a bunch of stuff. if they type one in and find that it isnt in the list then there is an add button beside it. if they press the add...

Thanks! i looked into it and found a perfect example!