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.