Search results

ah ok i understand now. why is it when i try create or view my query in design view its 'normal' but with yours its just a straight code page ?? i think thats why i couldnt get it to work, cos i couldnt get that code page, ive never seen it beofre in access. thanks alot mate. youve been a...

thanks for the reply Jon. im having a bit of trouble getting the query to wrok though. i keep getting syntax errors after putting SELECT [Gender], DateDiff("yyyy",[DOB],Date())+Int(Format(Date(),"mmdd")<Format([DOB],"mmdd")) AS Age, [Completed High School] FROM Students; into the build...

ok. well i made the Age query. heres the link http://www.access-programmers.co.uk/forums/showthread.php?t=74237 to my first post about making stats from my database, maybe useful to explain what im trying to do, also has a sample which someone did for me (very nice person :D ) i have 1 form...

yeah i kow that you dont store calculated values. but calculating Age in a form or in a query wont matter. The Age will still not be stored. simply calculated to show up when the form is open and displaying a students record. but how else can i calculate the statistics that i need ??? the...

hey hey. i posted this in the general section ut didnt get any responses. now ive been thinking about it and i think it could be done in the coded area. I am generating statistics from my table data. gender, ethnicity etc etc. i want to add Age to this. however because im not storing Age, im...

how will this help me ??? calculating it in the form or in a query wont really change anything will it ? i still will have a calculated field.....but this field will not be stored, and therfore not be able to be used in gettng stats

hello. recently i was helped with generating stats from table data and showing it on a form. Now i am trying to generate these stats but i want to generate Age stats. The thing is that i am calculating Age from the DOB field on the form and not storing it. Is there anyway i can still generate...

ok well i dont exactly know how to write a function like this is VB. i am currently generating stats from stored data. But i dont know how to generate stats from calculated data based on stored data. I tried, but it does not work correctly. i tried to upload my db but its too big to be...

worked fine here. saved it in a few diff directories. no problems. can they back up to floppy ??? cos maybe there computers are all nodes running on a server where they cant store it or seomthing......perhaps you shoulod talk to their admin and see why they think it wont work. cos it does...

thanks for the link. i also had a quick search on google and found how to do it. My other question is how can i generate statistics from this calculated data ??? because i want to see the range of ages of students in the database. But because the field is generated each time when the dob is...

hello all. Im still kinda learning access. i want to have a field Age which is displayed on my form and i want it to be calculated from the DOB entered. I dont want users to edit this field either. I know i should have another field where the user enters in Age manually because of data...

great thanks for the database. I didnt expect a complete working sample. cant wait to incorporate this into my form. Thanks alot man cheers. access_learner :)

hi guys. <<sorry if this is in the wrong place, wasnt sure>> ive got a db running. with a form showing all the database information from my table (Students), and allowing the user to do all the update, add kinda things on it. I want to add to this a statistic page, which i would use another...