creating following query without any kind of vba or php or other code (1 Viewer)

trkl

Registered User.
Local time
Today, 14:38
Joined
Jun 30, 2013
Messages
31
in fitness database created in MS access 2010 have following 2 tables: Member and Program. Member table have fields:MemberID,ProgramID,First,Last,Street,City,State,Zip,Phone,DateJoined,Expiration,Status. Program Table have fields: ProgramID, ProgramType, MonthlyFee, Physical Required. it is required that i have to create the following query: but i dont know how.plz help me. MemberID First Name Last Name Phone Date Joined 1156 Kurt Eisler 804-236-8961 4/17/2013 1142 Kye Nguyen 804-236-0325 2/20/2013 1120 Carmen Sanchez 804-674-5991 10/18/2013 1166 Abigail Turner 804-674-6807 9/1/2013 It has to be created by pressing create then create design query tab.its not to be created by access vba programming. I don’t know how to use query design method to achieve above query. Member table data sheet is: Member Member ID Program ID First Name Last Name Street City State Zip Phone Date Joined Expiration Date Status 1103 201 Joseph Eckler 29 Prospect Street Ashland VA 23005 804-550-3050 1/16/2013 1/16/2014 Active 1105 204 Barry Hassan 9 Harrington Avenue Richmond VA 23220 804-236-6717 3/2/2013 3/2/2015 Active 1106 202 Debbie Ward 18 Barton Street Richmond VA 23219 804-674-8462 4/22/2013 10/22/2013 Active 1110 201 Ashish Mittal 103 Hubbard Way Glen Allen VA 23058 804-553-4737 4/3/2013 4/3/2014 On Hold 1111 203 Liz Sorrento 134 Lincoln Road Chester VA 23831 804-751-1270 2/10/2013 8/20/2013 Active 1115 203 Michelle Kim 290 Brook Mill Road Bon Air VA 23235 804-323-0291 5/17/2013 5/17/2015 Active 1116 207 Robert DeCosta 35 Washington Street Richmond VA 23220 804-236-4121 8/4/2013 8/4/2014 Inactive 1117 203 Paul Novick 302 Great Road Ashland VA 23005 804-550-1164 9/20/2013 9/20/2015 Active 1120 202 Carmen Sanchez 1294 Monument Avenue Richmond VA 23219 804-674-5991 10/18/2013 9/25/2014 On Hold 1121 209 Kelly Smith 7 Lakeview Road Chester VA 23831 804-751-0466 7/18/2013 7/18/2014 Active 1125 203 Jessica Picard 17 Briarwood Lane Mechanicsville VA 23111 804-559-0909 6/22/2013 12/22/2013 Active 1126 204 Sam Bethel 258 Elm Street Mechanicsville VA 23111 804-559-1750 5/19/2013 5/19/2014 Active 1131 207 Olivia Alexander 29 Newtown Circle Richmond VA 23220 804-236-0642 3/11/2013 3/11/2015 Active 1135 201 Tina Sun 682 Hickory Way Chester VA 23831 804-751-9111 6/3/2013 6/3/2014 Active 1136 212 Mary Grant 913 Main Street Chester VA 23831 804-751-8772 5/1/2013 5/1/2015 Active 1137 210 Alan Fraser 41 Carver Hill Road Mechanicsville VA 23111 804-559-5885 3/20/2013 3/20/2014 Active 1139 210 Peter Grigas 3 Pleasant Street Glen Allen VA 23058 804-553-1642 6/9/2013 6/9/2015 Inactive 1140 206 Ronald Cunningham 52 Putnam Road Ashland VA 23005 804-550-7732 2/4/2013 8/4/2013 Active 1142 207 Kye Nguyen 456 Harringont Avenue Richmond VA 23220 804-236-0325 2/20/2013 2/20/2015 On Hold 1143 206 Barry Feinberg 73 Endicott Avenue Chester VA 23831 804-751-1119 10/5/2013 10/5/2014 Active 1144 208 Colleen Murphy 47 Winter Street Mechanicsville VA 23111 804-559-1651 6/9/2013 6/9/2014 Active 1146 209 Marlene Halpin 75 Elm Boulevard Bon Air VA 23235 804-323-0346 7/17/2013 7/17/2015 On Hold 1147 210 Elijah Slomich 108 Roosevelt Avenue Mechanicsville VA 23111 804-559-5060 8/2/2013 8/2/2015 On Hold 1148 212 Todd Wolfe 18 Parker Avenue Richmond VA 23219 804-674-2140 9/20/2013 9/20/2014 Active 1150 203 Zach Adgate 92 Apple Blossom Lane Ashland VA 23005 804-550-6119 10/15/2013 10/15/2014 Active 1151 202 Isabella Cimino 429 South Street Ashland VA 23005 804-550-9870 8/2/2013 8/2/2014 Active 1153 212 Vinnie Tumbiolo 358 East Street Richmond VA 23219 804-674-1434 5/19/2013 5/29/2015 Inactive 1154 204 Jamal Asmal 9872 Turnpike Road Richmond VA 23220 804-236-2194 6/7/2013 6/7/2014 Active 1155 210 Juliette Beaumont 35 Walnut Street Glen Allen VA 23058 804-553-1275 8/1/2013 8/1/2014 Active 1156 208 Kurt Eisler 5 Bradford Circle Richmond VA 23220 804-236-8961 4/17/2013 4/17/2015 On Hold 1158 201 Pedro Fuente 89 Mockingbird Lane Chester VA 23831 804-751-1147 9/5/2013 9/5/2014 Active 1159 211 Maggie Hadley 6 Rose Court Ashland VA 23005 804-550-6103 3/19/2013 3/19/2014 Active 1160 212 Mark Reynolds 11 Pond Lane Mechanicsville VA 23111 804-559-4642 6/20/2013 6/20/2015 Active 1165 207 Shea McKiernan 780 Flint Street Ashland VA 23005 804-550-0107 7/13/2013 7/13/2014 Active 1166 203 Abigail Turner 99 Maple Road Richmond VA 23219 804-674-6807 9/1/2013 9/1/2015 On Hold 1167 204 George Krukonis 14 Collins Drive Richmond VA 23219 804-674-4333 5/5/2013 5/5/2014 Active 1169 211 Maria Gonzalez 100 Tower Drive Richmond VA 23220 804-236-6337 5/19/2013 5/19/2014 Active 1170 203 Student First Student Last 40 Green Boulevard Bon Air VA 23235 804-323-6824 6/3/2013 12/3/2013 Active 1172 211 Ed Curran 25 Fairway Drive Richmond VA 23220 804-674-0227 10/18/2013 11/16/2014 Active Program table datasheet is Program Program ID Program Type Monthly Fee Physical Required 201 Junior Full(Ages 13-17) 40.00 Yes 202 Junior Limited(Ages 13-17) 30.00 Yes 203 Young Adult Full(18-25) 50.00 No 204 Young Adult Limited(ages 18-25) 35.00 No 206 Adult1 Limited (ages 26-35) 45.00 No 207 Adult2 Full (ages 36-50) 60.00 No 208 Adult2 Limited (ages 36-50) 45.00 No 209 Senior1 Full (ages 51-65) 50.00 Yes 210 Senior1 Limited (ages 51-65) 35.00 Yes 211 Senior2 Full (ages 66 and over) 40.00 Yes 212 Senior2 Limited (ages 66 and over) 30.00 Yes Thanks.
 

Mihail

Registered User.
Local time
Today, 12:38
Joined
Jan 22, 2011
Messages
2,373
Can you read your post ?
What about me, and others like me, who handled English less than an 8 years English child ?

My tables are:
TableName (FieldName1, FieldName2 ....)
......................
I wish to achieve this: ......

Cheers.
 

Isskint

Slowly Developing
Local time
Today, 10:38
Joined
Apr 25, 2012
Messages
1,302
Second point of your message Mihail.

We all (well most:p) like to help, but you need to tidy up your posting style - that is soooo confusing.

OK, so creating a query.
On the Create tab, in the Queries group, click Query Wizard.
Select Simple Query Wizard and click Next
Select the table name(s) you want to use in your query (just Member in your case)
Individually select the fields you want in your query, by clicking the field name in the left pane and click >
You can automatically add all the fields by clicking >>
When you have all the fields you want on your query showing in the right pane.
Click next
The next screen allows you to adapt how the data will be displayed, but for your scenario just ensure Detail is selected and click next
Enter a name for your query (try to avoid spaces). Query naming is a personal choice but generally try to make the name descriptive of its purpose but do not make it too long.
At the bottom of the wizard window you have the option to Open the query OR Modify it. For now ensure Open is selected and click Finish.
This is not the only way to create queries but it is the best place to start.

Have a look at these couple of links for some more help, or post here again - but try to make your request a little easier on the eye:banghead:
Tutorial
Youtube video
 

trkl

Registered User.
Local time
Today, 14:38
Joined
Jun 30, 2013
Messages
31
the rules of the forum are against me when trying to upload links of ms word 2010 file which have the question in tables format.
 

trkl

Registered User.
Local time
Today, 14:38
Joined
Jun 30, 2013
Messages
31
Isskint.i already know what you told me about creating query.the question is how to create that specific query.btw thanks for your help.i think we have to press builder button in ms access 2010.
 

trkl

Registered User.
Local time
Today, 14:38
Joined
Jun 30, 2013
Messages
31
when you right click in an empty field in a query design pane and select builder.
 

Isskint

Slowly Developing
Local time
Today, 10:38
Joined
Apr 25, 2012
Messages
1,302
the question is how to create that specific query.

What headings do you need in your query? form what you first posted you wanted

it is required that i have to create the following query: but i dont know how.plz help me. MemberID First Name Last Name Phone Date Joined
If they are the only fields, it is just a simple select query based on the table Member (as i demonstrated). Do you need fields from the Program table also?

Builder??? this would only come up in query design grid (QDG). If you are in the QDG and have no table, click the Add Tables button and select your table. Then you can drag the field names form the box down to the grid.
 

trkl

Registered User.
Local time
Today, 14:38
Joined
Jun 30, 2013
Messages
31
exactly. but the problem comes after that.
 

trkl

Registered User.
Local time
Today, 14:38
Joined
Jun 30, 2013
Messages
31
Isskint.its not a simple select query.though it appears to be and you dont have to to use any vba or any other code.i think when you make equal DateJoined=ExpioryDate field then we can make the above query.
 

trkl

Registered User.
Local time
Today, 14:38
Joined
Jun 30, 2013
Messages
31
i have uploaded word 2010 files to sting serce but this forum rules dont allow me to post links.i think when you or others see them then you would better understand this.
 

Isskint

Slowly Developing
Local time
Today, 10:38
Joined
Apr 25, 2012
Messages
1,302
send file or link to akhantunsolutions@gmail.com i i will have a look.

Now when you make equal DateJoined=ExpioryDate field. From this i guess you want your query to only show records where Member.DateJoined = ??

If you can list ONLY the fields (and table) you want in your query and any condition you want, we can make a start:)
 

trkl

Registered User.
Local time
Today, 14:38
Joined
Jun 30, 2013
Messages
31
email sent yesterday.did you receive it.plz inform.Isskint:following may help! show only customers from Richmond whose membership are on hold.
 

trkl

Registered User.
Local time
Today, 14:38
Joined
Jun 30, 2013
Messages
31
Now when you make equal DateJoined=ExpioryDate field. From this i guess you want your query to only show records where Member.DateJoined = ?? If you can list ONLY the fields (and table) you want in your query and any condition you want, we can make a start yeah.we have to impose conditions but thats my thinking.Author of the Excersise(Question)may have produced the required query without imposing conditions.now you impose conditions through VBA code.but also through design grid of query design.if its design grid then thats the real point?how?
 

Isskint

Slowly Developing
Local time
Today, 10:38
Joined
Apr 25, 2012
Messages
1,302
sorry trkl, extremely busy atm. will get back to you asap:eek:
 

Users who are viewing this thread

Top Bottom