Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Xpress Query Result as a percentage??
I thought this would be easy but the syntax is really bogging me down. I am a beginner trying to disseminate from a Health Centre database which women smoke; I have my query results but am having trouble expressing them as a percentage of the whole. Is this possible to answer without further...- dubbel00
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
Expressing Values as Percentages
Thnx Jebry for the response:[dob] And DateAdd("m",2,[dob]); Now if someone has the patience to tell me how to express this as a percentage. I know this should be easy and I have looked however I think I am looking too deep for something simple now. It's kinda obvious, but not so to me...- dubbel00
- Thread
- Replies: 0
- Forum: Microsoft: Access Queries and JET SQL
-
BASIC Query Criteria Assistance Reqrd
Forgive the possible faux pas in my question but I'm a newbie to Access, a quick learner but newbie all the same... Q. How do I denote a Criteria that says: " Between DOB and Datestart <= 2 months " where we have tables of Birthdates (DOB) and a start date for health visits...- dubbel00
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
