Rock & Gem Show-Termine
January 2023
27-29—Tyler, Texas: Annual Exhibition; Gem and Mineral Society of East Texas; Tyler Rose Garden Center, 420 Rose Park Drive; Friday 10-5, Saturday 10-6, Sunday 10-5; Adult $5, Student $1; Rock Food Tables, neon rock display, club member collection displays, lapping demonstrations, children's games; contact Ed Grounds, (903) 316-9157; Email: egrds1@gmail.com; Website: www.etgms.org/January 2023 to February 2023
25-5—TUCSON, ARIZONA: wholesale and retail fair; JOGS International Exhibitions; Tucson Expo Center, 3750 E Irvington Road; Friday 10-6; $15; contact Yelena Masenko, (213) 629-3030; email: info@jogsshow.com; Website: www.jogsshow.com/ 28-4—TUCSON, ARIZONA: Annual Exhibition; stone colors; Casino Del Sol, 5655 W Valencia Rd; daily 10-6; Free pass; Colors of the Stone, Tucson's largest arts and crafts fair, returns along with To Bead True Blue and Artisan Workshops. The sample brings together a diverse group of artisans, lapidaries, lapidaries and artisans; contact Josie Johnson; Website: www.colorsofthestone.comFebruary 2023
2-4—TUCSON, ARIZONA: exhibition and sale; Faceters Guild of the USA; Old Pueblo Lapidary Club, 3118 N Dale Ave; Thursday 10-5, Friday 10-5, Saturday 10-9; Check website for approval details; A great event to learn or improve your carving skills, doping presentations, warm up, software usage, stone sorting, machine demo, gate prizes, stone competition and Faceters Hob Nob to close out Saturday night; contact David Smith, 520-907-5527; Email: David@beadholiday.com; Website: USFacetersguild.org 4-5—MERRITT-INSEL, FLORIDA: exhibition and sale; Stone and Gem Club of Central Brevard; Kiwanis Recreation Center, 951 Kiwanis Island Park; Sat 10-5, Sun 10-4; $6 adults, $1 off coupon available on website or Fl Today ad, children 12 and under stay free when accompanied by an adult; We will have approximately 25 vendors selling handmade and manufactured rocks, minerals, specimens, gemstones, slabs, jewelry, and findings. Especially for the little ones and the young at heart, there will be a padlock and spinning wheel. Both days there will be silent auctions and raffles; contact Roz Mestre, (321) 431-0159; Email: roz.mestre@att.net; Website: www.centralbrevardgems.com 9-12—TUCSON, ARIZONA: Annual Exhibition; Tucson Gem and Mineral Society, Inc; Tucson Convention Center, 260 S. Church Avenue; Thursday 10-6, Friday 10-6, Saturday 10-6, Sunday 10-4; Ticketed Event - Open to the Public - Retail - This show is for all ages: adults, seniors, children, etc.; 68. Tucson Gem and Mineral Show® THEME: SILICA: agates, opals and quartz, wow; contact Tucson Gem and Mineral Society, Inc, (520) 322-5773; Email: tgms@tgms.org; Website: www.tgms.org/show 11-12—PUERTO DE ROBLE, WASHINGTON: 57th Annual Darling Jewels Show; Whidbey Island Gem Club; The Center at Oak Harbor, 51 SE Jerome St; Sat 9-5, Sun 9-5; free; Door prizes, member displays, vendors, protesters; contact Victoria Lovett; Email: vick_o_rama@hotmail.com 17-19—SANTA BARBARA, CALIFORNIA: wholesale and retail fair; Gem Faire Inc.; Earl Warren Exhibition Grounds, 3400 Calle Real; Friday 12-6, Saturday 10-6, Sunday 10-5; $7 weekend pass; Fine jewelry, precious and semi-precious stones, millions of pearls, crystals, gold and silver, minerals and more at manufacturer prices. Buy directly from importers and wholesalers. repair and cleaning of jewelry during the purchase; contact Yooy Nelson, (503) 252-8300; Email: info@gemfaire.com; Website: www.gemfaire.com 17-26—INDIO, CALIFORNIA: exhibition and sale; Gem and Mineral Society of San Gorgonio de Cabazon, CA; Riverside National Date Fair and Festival Company, 46350 Arabia Street; Fri. 3-10, Sat. 10-10, Sun. 10-10, Mon. 10-10; Fair admission: $11 adults, $10 seniors, $9 youth; Find us at the Gem and Mineral Building, along with a number of vendors and our competitive storefronts. Hours: 3 pm to 10 pm Tuesday through Friday; contact Peggy Richard, (951) 963-6751; Email: pegylrichard@yahoo.com; Website: SGMGS.org 18-19—GEORGETOWN, TEXAS: Annual Exhibition; Williamson County Gem and Mineral Society; The Community Center at San Gabriel Park, 445 East Morrow Street; Sat 10-6, Sun 10-4; Adults 13+ $3: Children 6-12 $2; Up to 6 years are free. Cash only, no big bills; WCGMS 52nd Annual Gem Show! Featuring twelve high bidders, wheel of fortune game, silent auctions, hourly prizes, one adult and one youth grand prize drawing at 3:30 p.m. m. on Sunday. Rolling Rock Club meeting on Sunday at 9 am; contact Janet OPella; Email: wcgmsgemboree@gmail.com; Website: www.facebook.com/WilliamsonCountyGemSociety 18-19—ANTIOQUIA, CALIFORNIA: Annual Exhibition; Lapidary Club of Antioquia; Contra Costa County Fairgrounds, 1201 West 10th Street; Sat 10-5, Sun 10-5; ADULTS - R$ 6, Children up to 12 years old and Free uniformed Scouts with Paid Adult, Active Military with ID - Free; A variety of vendors with gems, minerals, fossils, meteorites, crystals, pearls, jewelry, and much more. Activities include rock and gem identification, demonstrations, educational demonstrations, silent auctions, and free children's activities. something for everyone and all ages; contact Kelly Plumb, (510) 693-9075; Email: Kellyplumb900@yahoo.com; Website: www.antiochlapidaryclub.com 24-26—COAST MESA, CALIFORNIA: wholesale and retail fair; Gem Faire Inc.; OC Feira & Events Center, 88 Feira Dr; Friday 12-6, Saturday 10-6, Sunday 10-5; $7 weekend pass; Fine jewelry, precious and semi-precious stones, millions of pearls, crystals, gold and silver, minerals and more at manufacturer prices. Buy directly from importers and wholesalers. repair and cleaning of jewelry during the purchase; contact Yooy Nelson, (503) 252-8300; Email: info@gemfaire.com; Website: www.gemfaire.com 24-26—GOLDEN, COLORED: Annual Exhibition; Denver Gem and Mineral Guild; Jefferson County Fairgrounds, 15200 West 6th Avenue; Friday 10-6, Saturday 10-6, Sunday 10-5; Free; Fun for the whole family with geode cookies, beautiful minerals from around the world (and meteorites from around the solar system), ancient fossils, fluorescent room with glow-in-the-dark stones, gemstones, opals, custom stone tables, beautiful handmade items. personalized jewelry; contact Dr. Beth Simmons, (303) 902-1708; Email: MineralGuild@gmail.com; Website: denvergem.org/February-Show/ 24-26—CLARKDALE, ARIZONA: Annual Exhibition; Mingus Gem and Mineral Club; Clark Memorial Clubhouse Auditorium, 19 N. Ninth Street; Friday 9-5, Saturday 9-5, Sunday 9-4; Free; Vendors, demos wire breaking and geodes, agates, fossils, gemstones, beads, findings, cabochons, crystals, geodes, rock slabs, carved minerals, handcrafted jewelry, sculptures, and unique gift items; Kids Corner offers free mineral samples to children 12 and under; contact Bill Hedglin, (928) 634-0269; Email: billkarin3@q.com; Website: www.mingusgem.club 25-25—LAKELAND, Florida: Annual Exhibition; GM&FS bone valley; Lakeland First Presbyterian Church, 175 Lake Hollingsworth Dr., P.O. field 906; Saturday 9-4:30; $3 Adults, Children under 18 and Teachers Free; Door prizes, Spin & Win mineral wheel, kids scavenger hunt, educational exhibits, silent and random auctions, many vendors selling rocks, minerals, fossils, jewelry, gifts, hobby items; contact Jim Reed, (863) 255-0651; Email: BoneValley.info@gmail.com; Website: www.bonevalley.net/ 25-26—ANCHORAGE, ALASCA: Spring Stone and Gem Show; Chugach Gem and Mineral Society; Midtown Mall, 600 E Northern Lights Blvd; Sat 10-7, Sun 12-6; free; free parking; contact Paul Burger; Email: cavemonpaul@hotmail.com 25-26—VALLE, CALIFORNIA: Annual Exhibition; Vallejo Gems and Minerals Society; Solano County Fairgrounds, McCormack Hall, 900 Fairgrounds Drive, Vallejo CA 94589; Sat 10-5, Sun 10-5; Adults $6, children under 12 free; Gems, geodes, fossils, pearls and minerals from around the world. Discover stone carvings and stone crafts from vendors and live demonstrations. Something for everyone! silent auction, geode cutting and children's games of chance and discovery; contact Debra Duhon, (415) 254-1506; Email: dduhonvgms@gmail.com; Website: www.vjgems.co/ 25-26—JACKSON, MISSISSIPPI: Annual Exhibition; Mississippi Gemstone and Mineral Society; Mississippi Trade Mart at State Fairgrounds, 1200 Mississippi Street; Friday 9-6, Saturday 9-4; Adults $8: Students $3: Scouts and Leaders in uniform $2: Children 5 and under free; Over 25 dealers in gemstones, fossils, minerals, jewelry, stone cutting tools, beads and more. Stone carving demonstrations, including flint cutting, cabochon cutting, and jewelry making. Exhibitions and educational offers from universities and government agencies. Children activities; contact Leslie A. Lane, (601) 344-8171; Email: rock2lanes@gmail.com; Website: www.missgems.org 25-26—BOISE, IDAHO: Annual exhibition of gems, minerals and fossils; Idaho Gem Club; Idaho Exposition, 5610 Glenwood; Sat 10-6, Sun 10-5; $5 children 12 and under free; We offer demos, storefronts, children's games, silent auctions and many sellers; contact Brent Stewart, (208) 342-1151 25-26—JACKSON, MISSISSIPPI: Annual Exhibition; Mississippi Gemstone and Mineral Society; Mississippi Trade Mart at State Fairgrounds, 1200 Mississippi Street; Sat 9-6, Sun 9-4; Adults $8: Students $3: Uniformed Scouts and Guides $2: Children 5 and under free; Over 25 dealers in gemstones, fossils, minerals, jewelry, stone cutting tools, pearls and more. Exhibitions and educational offers from universities / government organizations. Stone carving demonstrations: flint carving, cabochon carving, jewelry making, and exhibits. Children activities; contact Leslie A. Lane, (601) 344-8171; Email: rock2lanes@gmail.comMarch 2023
3-5—Lang, Florida: Annual Exhibition; Suncoast Gem & Mineral Society, Inc. of St. Petersburg, Florida; Largo Events Center, 6340 126th Ave N; Friday 10-6, Saturday 10-6, Sunday 10-5; Adult $6/Student with parent or ID $5/Under 6 years free/Valid every three days; Discover our world-class suppliers of gemstones, minerals, jewelry, slabs, cabochons, fossils, pearls, and more. Door prizes, exhibits, gem mining trough for young and old, silent auction every half hour, lapidary demonstrations, and the debut of the newly discovered lapidary stone, Markonite; contact Breta McGuire, (727) 344-9676; Website: www.sgams.com 3-5—PORTLAND, OREGON: Annual Exhibition; Oregon Agate and Mineral Society 71st Annual Exposition; OMSI (Oregon Museum of Science and Industry) Auditorium, 1945 SE Water Avenue; Friday 9:30-5:30, Saturday 9:30-5:30, Sunday 9:30-5; free; Demonstrations and exhibits of stone carving and creative skills, jewelry, a children's corner, sale of stones, minerals and plaques, stone dining table, touch table and much more. (without providers); contact Sonia Watt; Email: sonywatt@yahoo.com 3-5—FOREST GROVE, OREGON: Annual Exhibition; Tualatin Valley Gem Club; Forest Grove National Guard Armory, 2950 Taylor Way; Fri 10-5, Sat 10-5, Sun 10-5; $1; Children 12 and under free with adults; 64th Annual Rock & Gem Show, Exhibits, Door Prizes, Silent Auction, Kids' Fun Corner, Demonstrations; Contact William Harvey Jr.; Email: WLHARVEYJR@msn.com; Website: www.tvgc.org 3-5—DEL MAR, CALIFORNIA: wholesale and retail fair; Gem Faire Inc.; Del Mar Fairgrounds, 2260 Jimmy Durante Blvd; Friday 12-6, Saturday 10-6, Sunday 10-5; $7 weekend pass; Fine jewelry, precious and semi-precious stones, millions of pearls, crystals, gold and silver, minerals and more at manufacturer prices. Buy directly from importers and wholesalers. repair and cleaning of jewelry during the purchase; contact Yooy Nelson, (503) 252-8300; Email: info@gemfaire.com; Website: www.gemfaire.com 3-5—NEWARK, CALIFORNIA: Annual Exhibition; Society of Minerals and Gems of the Castro Valley; Newark Pavilion, 6430 Thornton Ave; Friday 10-4, Saturday 10-6, Sunday 10-3; $10/3 day; $6/day; children under 13 Free with adults; Educational and family event. More than 35 resellers, local and throughout the country: Jewelry, Findings, Gems, Stones, Fossils, Minerals, Crystals, Opals, Faceted Gems, Pearls. Fluorescent. exhibits Gem identification. Spinning wheel for children. geodes. door prices Auction, Saturday, 2 pm Handmade - Raffle $1; contact Cathy; email: showchair@mgscv.org; Website: mgscv.org/show.html 4-5—MELBOURNE, FLORIDA: exhibition and sale; Canaveral Gem and Mineral Society; Melbourne Auditorium, 625 E Hibiscus Blvd; Sat 10-5, Sun 10-5; $5 at the door; Coupons can be found on our Facebook group, https://www.facebook.com/Canaveralmgs; contact Melissa J. Horan, (321) 960-4134; Email: 4memelissa@gmail.com 4-5—Wilmington, Delaware: Annual Exhibition; Delaware Mineralogical Society; Hilton's DoubleTree, 4727 Concord Pike (Rt-202); Sat 10-5, Sun 11-5; Senior (60+) $5, Adult (18-59) $6 ($5 with coupon), Junior (12-17) $3, Scouts in Uniform and Kids 12 and under free when accompanied by a paying adult; The family show features educational displays of minerals, lapidaries, and fossils; a list of good dealers in minerals, fossils, gems, and jewelry; Raffles for interesting specimens and a children's area where the little ones can purchase cheap mineral and fossil specimens; contact Christine Verdi; Email: 1DMS.President@gmail.com; Website: https://www.facebook.com/Delaware-Mineralogical-Societys-Annual-Gem-Mineral-and-Fossil-Show-109057331950888 4-5—Meriden, Connecticut: Annual Exhibition; The Lapidary and Mineral Society of Central CT; Maloney High School, gravel driveway; Saturday 9:30-5, Sunday 10-4; adults $5; Minerals, gems, crystals, exhibits and more; contact Tom Benedict; Email: meridenmineralclub@gmail.com; Website: www.lmscc.org 4-5—Caldwell, Idaho: 69th Annual Show - Rock & Gem Show 2023; Owyhee Gem and Mineral Society; O'Conner Country House, 2207 Blaine; Sat 10-6, Sun 10-5; $5 children 11 and under free with adults; Vendors, marchers, blacklight display, gemstone wheel, sand ditch, bags, door prizes every half hour, raffle, silent auction, grand prize; contact Paul Deveau, (208) 994-8025; Email: dueho@q.com; Website: www.OwyheeRocks.com 4-5—ISSAQUAH, WASHINGTON: Gems, Minerals and Jewelry Fair; East KingCo Rock Club; Pickering Barn, 1730 10th Avenue NW; Sat 10-6, Sun 10-5; free; We have 26 gemstone, jewelry and mineral dealers, gemstone and mineral exhibits, a stone carving exhibit, children's activities, silent auctions, Whats My Rock ID and hourly door prices; contact Kim Villines, (425) 828-3872; Email: earthlightgems@gmail.com; Website: EastKingCo.org 4-5—VENTURA, CALIFORNIA: Annual Exhibition; Ventura Gem and Mineral Society; Ventura County Fairgrounds, 10 W. Harbor Blvd; Sat 10-5, Sun 10-4; Free! Fairgrounds charges a fee for parking; 50 exhibitions of precious stones, minerals, fossils and stone carvings; ongoing demonstrations of stone carving and jewelry making; sweepstakes and silent auctions; a thrift store and plant sales; 15+ merchants; Activities for children and free resources for teachers. A SoCal tradition that spans 6 decades and continues; contact Richard Slyker, (805) 312-8467; Email: info@vgms.org; Website: www.vgms.org 4-5—MESA, ARIZONA: exhibition and sale; Apache Junction Stone and Gem Club; Mesa Community College, 1401 S Dobson Road; Sat 9-5, Sun 9-4; Adults $3, children under 18 free; More than 100 suppliers of stones, gems, minerals and other suppliers related to this great hobby. Educational value for children. event for dogs Grocery seller. Find great deals and meet cool people who love rock music; contact Linda Huss, Secretary, (480) 319-1960; Email: secretaria@ajrockclub.com; Website: www.ajrockclub.com/ 4-5—ANCHORAGE, ALASCA: Spring Stone and Gem Show; Chugach Gem and Mineral Society; Midtown Mall, 600 E Northern Lights Blvd; Sat 10-7, Sun 12-6; free; Free parking, 2 weekend events; contact Paul Burger; Email: cavemonpaul@hotmail.com 10-11—RICHBORO, PENSILVANIA: Annual Exhibition; Leidy Microscopic Society; Adventist Lutheran Church, 45 Worthington Mill Rd; Friday 12-6, Saturday 9-6; $25 Half Table - $40 Full Table - Guests $5 Friday and $10 Saturday (including Saturday lunch); 46th Leidy Micromount Symposium Examine and explore mineral specimens enhanced by magnification through the microscope; contact Donald McAlarnen, (610) 247-5097; Email: donmcalarnen@outlook.com; Website: www.leidymicroscopic.com 10-11—COLVILLE, WASHINGTON: Annual Exhibition; Panorama Club of Gems and Minerals; Northeast Washington Fairgrounds, 317 West Astor; Friday 9-6, Saturday 9-5; Free pass; stalls, showcases, black light exhibition, children's activities; contact Johnie Pitman; Email: jgpitman@outlook.com; Website: panoramagem.com/ 10-12—AUGUSTA, GEORGIA: Annual Exhibition; Augusta Gem and Mineral Society and Aiken Gem and Mineral Society; Julian Smith Casino, 2200 Broad Street; Friday 10-6, Saturday 10-6, Sunday 11-5; $4 Day Pass or $6 Weekend Pass - Kids 12 and under FREE with paying adult; Member Demonstrations, Lapidary Demonstrations, Educational Resources, Hourly Awards, Scavenger Hunts, Tote Bags, Sold & Cut Geodes, Grand Door Awards, Coffee Shops Dealers: Gold, Silver, Fine & Everyday Jewelry, Loose Gemstones, Cabochons, Slabs , crystals, minerals, fossils, treasures, pearls and more; contact Wayne Parker; Email: agams.club@gmail.com; Website: www.aikengmfs.org or www.agams.club 10-12—VICTORVILLE, CALIFORNIA: retail display; Victor Valley Gem & Mineral Club - Back door of Stoddard Wells Rockhound; 15056B Seventh Street, Stoddard Wells Road, 11473 Mint Street; Friday 9-5, Saturday 9-5, Sunday 9-5; Free pass; contact Mark Lantz at 760-243-2330; Email: President@vvgmc.org 10-12—APPLE VALLEY, CALIFORNIA: Annual Exhibition; Victor Valley Gem and Mineral Club; 47th Annual Stoddard Wells Rockhound Tailgate Meeting, Stoddard Wells Rd; daily 9-5, daily 9-5, daily 9-5; Free; Upon arrival, take 1-15 towards Barstow to exit 157 Bell Mtn Rd/Stoddard Wells Rd and Dale Evans Parkway. Vendors offering slabs and huts, finds and equipment, minerals and fossils, raw materials, handcrafted and faceted jewelry, family outings to marble varieties; contact Mark Lantz, (760) 243-2330; Email: President@vvgmc.org; Website: www.vvgmc.org 10-12—KANSAS-CITY, MISSOURI: Annual Exhibition; Association of Earth Science Clubs of Greater Kansas City; KCI Expo Center, 11730 NW Ambassador Dr, 2102 SE Shale Ridge Dr; Friday 10-8, Saturday 10-7, Sunday 10-5; Adult $7, 2-day pass $12, 3-day pass $18, children 5-12 $4, children 4 and under free; Free parking. Special Exhibits, Fluorescent Minerals, Flint Cutting, Stone Carving Demonstrations, 60+ Retailers; Wholesalers, identification stand, mining courses. silent auctions, Saturday night concession auction; contact Bruce Stinemetz, (816) 795-5159; Email: kcgemshow@yahoo.com; Website: www.kcgemshow.org 11-12—SAN FRANCISCO, CALIFORNIA: retail display; Pacific Crystal Guild; San Francisco County Fair Building, 1199-9th Street, Golden Gate Park; Sat 10-6, Sun 10-4; US$14 (valid for both days – free for children under 12 years old); It will be great. Best sellers, wonderful products. Gems, jewelry, crystal beads and metaphysical healing tools, more than 50 stalls; contact Jerry Tomlinson, (415) 383-7837; email: jerry@crystalfair.com; Website: http://www.crystalfair.com 11-12—NEW YORK, NEW YORK: exhibition and sale; Mineralogical Club of New York; High School of Fashion Industries, 225 West 24th Street New York GYM 3rd Floor; Sat 10-6, Sat 11-5; Admission $6 per person and children 12 and under free with paying adult; Free lectures and door prices per hour, dealers near and far with a great selection; contact Mohamed Bary, (347) 247-6568; Email: barygems@gmail.com; Website: www.barygems.com 11-12—SAN FRANCISCO, CALIFORNIA: retail display; Pacific Crystal Guild; San Francisco County Fair Building, 1199 - 9th Avenue (at Lincoln Way), Golden Gate Park; Sat 10-6, Sun 10-4; $14 (valid for both days, free for children 12 and under); This is gonna be great. Best sellers, wonderful products. Gems, jewelry, crystal beads and metaphysical healing tools, more than 30 stalls; contact Jerry Tomlinson, (415) 383-7837; email: jerry@crystalfair.com; Website: http://www.crystalfair.com 11-12—TURLOCK, CALIFORNIA: Annual Exhibition; Mother Lode Mineral Society; Stanislaus Fairgrounds, 900 North Broadway; Sat 10-5, Sun 10-5; Adults $8, children under 12 free; Tactile animatronic dinosaur for kids; contact Belinda Wendland; Email: bwendx2@yahoo.com 11-12—ARCHIVES, IDAHO: 73rd Annual Exhibition of Rocks, Gems, Minerals and Jewelry; Magic Valley Gems Club; Twin Falls County Fairgrounds, 215 Fair Avenue; Sat 10-5, Sun 10-4; Adult $2 Children 12 and under are free when accompanied by an adult; Membership, Wholesale & Jewelers Showcases, Door Prizes, Youth Games, Demonstrations, Pockets of Polished Stone, Silent Auctions and much more; contact Sam Marsh; Email: bigdawg66@yahoo.com; Website: www.magicvalleygemclub.org 11-12—KALISPELL, MONTANA: Gold, Gems and Minerals Exhibition; Rock Arbors of northwestern Montana; Flathead County Fairgrounds, Expo Building, 265 North Meridian Road; Sat 9-6, Sun 10-5; Admission $2 Middle and High School, Elementary and Junior - Free; Our rock show offers a wide range of items from our vendors; demonstrations and displays by members of our club and the local mining group; silent auctions featuring items from local stone hunters, fossil collectors, and flint cutters. The children's corner is one of the most popular attractions; contact Lloyd Fager, (608) 436-0780; Email: oldgrayelf@sbcglobal.net 17-19—PUYALLUP, WASHINGTON: wholesale and retail fair; Gem Faire Inc.; Washington State Fair Events Center, 110 9th Ave SW; Friday 12-6, Saturday 10-6, Sunday 10-5; $7 weekend pass; Fine jewelry, precious and semi-precious stones, millions of pearls, crystals, gold and silver, minerals and more at manufacturer prices. Buy directly from importers and wholesalers. repair and cleaning of jewelry during the purchase; contact Yooy Nelson, (503) 252-8300; Email: info@gemfaire.com; Website: www.gemfaire.com 17-19—JACKSON, MÍCHIGAN: Annual Exhibition; Michigan Gemstone and Mineral Society; Jackson County Fairgrounds—American 1 Event Center, 128 W. Ganson; Friday 10-6, Saturday 10-5, Sunday 11-5; Adults: $4, Seniors $2, Students $1-4 and under FREE. FREE Senior Fridays and Girl Scouts in Uniform FREE; All welcome! Family fun for all! We have: GEMS, MINERALS, ROCKS, FOSSILS, HOURLY DRAW, GREAT DRAW, EXHIBITIONS, LAPIDARIES, GREAT SILENT AUCTION, PROTESTERS, PRIZES AT THE DOOR, PEARLS AND JEWELRY. We also have fun activities for the kids in the family. I would like to see you; contact Sally, (517) 522-3396; Email: Saltoosal2@yahoo.com; Website: mgmsrockclub.com Facebook: Michigan Gem and Mineral Society 17-19—Swannanoa, North Carolina: Annual Exhibition; MAGMA shows precious stones, minerals and fossils; Earth of Heaven Sanctuary Club, 39 Spring Cove Road; Friday 9-6, Saturday 9-6, Sunday 10-5; Free; Numerous vendors offer a wide variety of gemstones, minerals, fossils, jewelry, lapidaries, antique collections, and all manner of other treasures. Our new place has heat and air conditioning. Clean toilets and amazing food served every day! Free admission, rain or shine; contact Richard Jacquot, (828) 779-4501; Email: rickjacquot@gmail.com; Website: www.americanrockhound.com 17-19—ALBUQUERQUE, NEW MEXICO: Annual Exhibition; Albuquerque Gem and Mineral Club; Expo NM State Fairgrounds, 300 San Pedro NE; Friday 10-6, Thursday 10-6, Sunday 10-5; Friday $2, Saturday and Sunday. $5, children 13 and under free; Treasures of the Earth jewelry, mineral and gem exhibit at Creative Arts Bldg. Enter Gate 3 @ San Pedro y Cobre. 50+ dealers, mineral samples, jewelry, cabochons, beads, fossils, slabs, rough and petrified wood, tools, prize-winning equipment, silent auctions, junior table, displays; contact Paul Hlava, 505-850-7524; email: paulhlava@q.com; Website: www.hauptversammlung.info 17-19—MARIETTA, GEORGIA: Annual Exhibition; Bellpoint Gem Show; Cobb Civic Ctr, 548 S. Marietta Pkwy; Friday 10-5:30, Saturday 10-5:30, Sunday 10-4:30; $8 admission (cash only); Selected dealers from near and far selling rare minerals, jewelry, gemstones, fossils, healing stones, pearls, crystals, stones; contact BJ; Email: mbellpoint@gmail.com; Website: www.bellpointpromotions.com 17-19—SPANISH FORK, AFTER: exhibition and sale; Timpanogos Gem and Mineral Society; Spanish Fork Fairgrounds, 475 South Main Street; Friday 10-7, Saturday 10-7, Sunday 10-5; Free; Founded in 1958, the Timpanogos Gem and Mineral Society is among the oldest and largest in Utah. Meetings are held the third Wednesday of each month at the Springville Senior Center, 65 South 200 East, Springville, Utah. Visitors are welcome! I hope to see you soon; contact Ann Hribal, (801) 851-0283; Email: hribal@comcast.net 17-19—SPANISH FORK, AFTER: Annual Exhibition; Timpanogos Gem and Mineral Society; Spanish Fork Fairgrounds, 475 South Main Street; Friday 10-7, Saturday 10-7, Sunday 10-5; free; Siding, Amethyst, Minerals, Jewelry, Wire Wrap, Squires, Rough Stones, Petrified Wood, Opals, Fossils, Gemstones, Stone Sales, Textbooks, Stone Cutting Tools & Supplies, Junior Club Booth, Touch Table , Lucky bags, Wheel of fortune, Door prizes every half hour to an hour, black light display; contact Jerry Davis, (801) 830-92; Email: carpetman405@gmail.com; Website: www.timrocks.weebly.com 18-18—FALLBROOK, CALIFORNIA: exhibition and sale; Fallbrook Gem and Mineral Society; Fallbrook Gem & Mineral Society, 123 W. Alvarado Street; Saturday 1-4; Free admission, free parking; Sale Rough N Cut - rocks and minerals, gems, equipment and everything related to that. Deals Galore! Early risers are prohibited; however, you can visit our museum with free admission, open on Saturdays from 10 am to 4 pm before and during the event; contact Miles Smith, (760) 728-1130; email: info@fgms.org; Website: www.fgms.org 18-19—SAN JOSE, CALIFORNIA: Annual Exhibition; Santa Clara Valley Gem and Mineral Society; Santa Clara County Amusement Park, 344 Tully Road, 16344 Shady View Lane; Sat 10-5, Sun 10-5; Adults: $6, children 12 and under free, military, first responders and their dependents free with valid ID. Free parking; Precious stones and fine minerals, children's discovery corner, demonstrations, exhibits, prices per hour and touch table; contact James Fox, (408) 356-7711; Email: jfox152@comcast.net 18-19—Winsted, Connecticut: display for smaller; Silver spiral creations; Molinos de merlán, 100 Calle de merlán; Saturday 10-4, Sun 10-4; Free; crystal, minerals, jewelry, cabujones, stone accessories; contact Lynne Patnode, (860) 459-9165; Email: Silverspiralcreations@gmail.com; Website: silverspiralcreations.com 18-19—MISSOULA, MONTANA: 28th Annual Hellgate Gem, Mineral, Fossil & Stone Sale; Hellgate Mineral Society; Hilton Garden Inn, 3700 North Reserve Street; Sat 9-6, Sun 10-5; $3, kids 14 and under free with adult admission; Vendors selling all aspects of Lapidary. Demonstration of booth making, carving, wire winding, and flint working. A table especially for children, where they dig in the gravel and collect gems. We also have a club table for the sale of handbags, a fluorescent mineral stall and boxes; contact Neil Maier or Lora Hall; email: info@hellgatemineralsociety.org; Website: hellgatemineralsociety.org 18-19—LEMOORE, CALIFORNIA: Annual Exhibition; Lemoore Gem and Mineral Show; Trinity Hall, 470 Champion St; Sat 10-6, Sun 10-4; Free; Featuring gemstones and minerals from around the world: fossils, jewelry, pearls, stone carvings, rough cut, geode carving, and handcrafted jewelry; contact Dave Morrell, (559) 362-8904; Email: lemooregemandmineralclub@gmail.com; Website: www.facebook.com/AndLemoore 18-19—CENTRAL POINT, OREGON: Annual Exhibition; Roxy Ann Mineral and Gem Society - Crater Rock Museum; THE EXPO - Seven Feathers Arena, 1 Peninger Road; Sat 9-5, Sun 10-4; $5.12 or less free; contact Liz Ellingson at (541) 664-6081; email: craterrockgemshow@gmail.com; Web: www.craterrock.com 24-26—LOVELAND, COLORADO: Annual Exhibition; Fort Collins RockHounds Club 60th Annual 2023 Club Gem & Mineral Show; Ranch/Larimer County Fairgrounds, Thomas M McKee Building, 5280 Arena Circle, Loveland, CO 80538; Friday 4-8, Saturday 9-6, Sunday 10-4; Adult admission is $4 for a day or $7 for a 3-day pass. Admission for students (12-18 years old) is $1. Children 12 and under stay free when accompanied by an adult. (Admission is cash only. Vendors accept plastic); The club's exhibits feature jade and petrified wood. Metro State University is conducting an educational experiment on rock identification. The door prizes, two grand prizes, bag sales, children's game table, demonstrations and the silent auction continue. Our dealers have everything for Rockhounds; contact Nancy Howerter, (970) 206-9569; Email: fcrockhounds@gmail.com; Website: www.fortcollinsrockhounds.org 24-26—HICKORY, CAROLINA AL NORTE: Annual Exhibition; Catawba Valley Gem & Mineral Club, Inc.; Hickory Metro Convention Center, 1960 13th Ave. Drive, SI; Friday 10-6, Saturday 10-6, Sunday 10-5; Admission is $6, which is good for all three days. Children under 12 years old have free admission. Police and active and retired military with identity card, Scouts and uniformed leaders have free admission during the three days of the event; The Facebook page for concert news is the Catawba Valley Gem & Mineral Club, Inc. Annual Exhibition; contact Dean Russell, (828) 303-1448; Email: cvgmcsecretary@aol.com; Website: www.cvgmc.com 24-26—SPOKANE, WASHINGTON: 62nd Annual Gem, Mineral and Jewelry Fair; Rock Rollers Club of Spokane WA; Spokane County Fair and Exposition Center, 404 N. Havana at Broadway; Friday 10-6, Saturday 10-6, Sunday 10-4; General admission $8; seniors and military $7; Scouts in uniform and children 12 and under FREE; Vendors, exhibits, kids' activities and door prizes Admission valid all weekend Free parking See us on Facebook: Spokane Rock Rollers Gem Mineral & Jewelry Show; contact Steve Koon; Email: silakoondioxide@yahoo.com; Website: www.rockrollers.org 24-26—HILLSBORO, OREGON: wholesale and retail fair; Gem Faire Inc.; Westside Commons, 801 NE 34th Ave; Friday 12-6, Saturday 10-6, Sunday 10-5; $7 weekend pass; Fine jewelry, precious and semi-precious stones, millions of pearls, crystals, gold and silver, minerals and more at manufacturer prices. Buy directly from importers and wholesalers. repair and cleaning of jewelry during the purchase; contact Yooy Nelson, (503) 252-8300; Email: info@gemfaire.com; Website: www.gemfaire.com 24-26—CLOVIS, CALIFORNIA: Annual Exhibition; Fresno Gem and Mineral Society; Clovis Rodeo Grounds, 748 Rodeo Drive; Fri 10-5, Sat 10-5, Sun 10-4; free admission, all ages; The 3rd Annual Central Valley Gem & Mineral Show, sponsored by the Fresno Gem & Mineral Society, presents an extravaganza to see, learn and buy minerals, fossils, gemstones, beautiful handcrafted jewelry and more; contact Peggy J. Keating-Bolm, (708) 822-0361; Email: peggykeatingbolm2@gmail.com; Website: www.facebook.com/events/941764213213343/?ref=newsfeed 25-26—CANTON, OHIO: Annual Exhibition; Stark County Gem and Mineral Show; Stark County Fairgrounds, 305 Wertz Ave; Sat 9-5, Sun 10-5; Adults $5, Seniors 55+ $4, Children (6-14) $1, Uniformed Scouts Free; Door prizes, gem and mineral dealers with cut items, jewelry, pearls, rock slabs, gem and mineral samples. We have a fluorescent screen, children's games, a silent auction for children and adults; contact Vicky Waltz, (330) 862-2162; Email: fvwaltz46@live.com 25-26—FENDALE, WASHINGTON: 61st Annual Exhibition of Stones and Gems; Mount Baker Rock and Gem Club; Pioneer Pavilion, Kirschstraße 2007; Sat 10-6, Sun 10-5; free; manual vendors and exhibitors; contact Wes Gannaway; Email: debnwes@comcast.net; Website: http://mtbakerrockclub.org 25-26—WYSOX, PENSILVANIA: Annual Exhibition; Che-Hanna Rock and Mineral Club, Inc.; Wysox vol. Fire Department, 111 Lake Road, PO Box 224; Sat 9-5, Sun 10-4; Adults - $3, Students - $1, Children under 8 years free; Susquehanna River Archaeological Center special exhibit, fluorescent minerals program, mini mine for kids, geode cutting, mineral, gemstone, fossil and jewelry vendors; contact Bob McGuire, (570) 928-9238; Email: uvbob1942@gmail.com; Website: www.chehannarocks.com 25-26—POCATELLO, IDAHO: Annual Exhibition; Southeast Idaho Gem and Mineral Society (SEIGMS); Bannock County Fairgrounds, 10588 Fairgrounds Dr; Sat 10-5, Sun 10-5; $3 Children 12 and under free when accompanied by an adult; We'll feature vendors, silent auctions, demos, fossil digs, gem wheel spins, door prizes, jaw-dropping exhibits, and much more; contact Joe Rodriguez; Email: rodrider4@msn.com 25-26—JANESVILLE, WISCONSIN: Annual Exhibition; Badger Lapidary & Geological Society; Craig Center, Rock County Fairgrounds, 1301 Craig Ave; Sat 9-5, Sun 9-4; Free admission, goodwill donations accepted; Participate in our 52nd Annual Rock, Gems, Fossils and Minerals Exposition. Lots of kids activities, speakers all weekend, vendors selling beautiful minerals, fossils, gems and jewelry, club screenings, demos and our amazing fluorescent display; contact Laurie A. Trocke, (608) 935-0597; Email: laurie.troke@landsend.com; Website: badgerrockclub.org 25-26—TRUTH OR CONSEQUENCES, NEW MEXICO: Annual Exhibition; Sierra County Gem and Stone Society; Sierra County Fair Barn, S Broadway St @ Hyde; Sat 9-5, Sun 10-4; Free; Raw and finished rocks, slabs, rods, beads, jewelry, petrified wood, fossils. Tours, presentations, demonstrations. Gold and sapphire mining. Wheel of Fortune. Family friendly. door prices; contact Dan Lorimier, (575) 740-2927; Email: scragssierracounty@gmail.com; Website: scrags.org 25-26—PLYMOUTH, PENNSYLVANIA CONFERENCE: Annual Exhibition; the Philadelphia Mineralogical Society and the Delaware Valley Paleontological Society; LU Lu Temple, 5140 Butler Pike; Sat 10-5, Sun 10-4; $7 per adult, $2 children 12 and under. Scouts in Free Uniform; Fossils, minerals, gems, speakers and exhibits. Children's mineral space and fossil excavation with gifts. Scout Merit Badge available. Grocery and door prices on both days; contact Douglas M. Klieger, (610) 316-8052; email: dklieger@verizon.net; Website: www.phillyrocks.orgMarch 2023 to April 2023
31-2—EUGENE, OREGON: wholesale and retail fair; Gem Faire Inc.; Lane County Convention Center, 796 W 13th Ave; Friday 12-6, Saturday 10-6, Sunday 10-5; $7 weekend pass; Fine jewelry, precious and semi-precious stones, millions of pearls, crystals, gold and silver, minerals and more at manufacturer prices. Buy directly from importers and wholesalers. repair and cleaning of jewelry during the purchase; contact Yooy Nelson, (503) 252-8300; Email: info@gemfaire.com; Website: www.gemfaire.com 31-2—WEST PALM BEACH, FLÓRIDA: retail display; H&R Gem Shows; South Florida Fairgrounds, 9067 Southern Blvd; Fri 10-5, Sat 10-5, Sun 10-5; $8 adults. Children under 12 years free. Veterans/Military/First Responders receive $1 off regular admission. One ticket is valid every 3 days; Free parking. 24,500 square feet of fabulous vendors including jewelry, gemstones, crystals, rocks, pearls, minerals, raw materials, fossils and more; contact Jerri A. Heer, (419) 344-9999; Email: hrgemshows@gmail.com; Website: www.hrgemshows.com 31-2—RALEIGH, NORTH CAROLINA: Annual Exhibition; Tar Heel Gem and Mineral Club; Kerr Scott Bldg, North Carolina Fairgrounds, 1025 Blue Ridge Rd; Friday 3-7, Saturday 10-6, Sunday 10-5; free; Club areas: hospitality with bags, free magazines, membership prize tickets and raffle, opening of club-purchased geodes, silent auction for children and adults of minerals, fossils and jewelry and art wrapping demonstration, tree and stone making precious cut; contact Cyndy Hummel, (919) 779-6220; Email: mchummel@mindspring.com; Website: www.tarheelclub.orgApril 2023
1-2—LINCOLN, NEBRASKA: Annual Exhibition; Lincoln Gem and Mineral Club, Inc.; Lancaster Events Center (Lincoln Room), 84th Street and Havelock; Sat 9-5, Sun 10-5; $6 per adult or $11 2-Day Pass Children under 11 accompanied by paying adult: FREE; Youth booth, vendors, exhibits, demos, fluorescent displays and a FREE Nebraska Gem Dig. More than 4,000 free parking spaces. Bring your Lincoln Food Bank postcard or ad or canned food and get $1 off admission; contact James Marburger, (402) 430-6703; Email: James.Marburger@outlook.com; Website: www.lincolngemmineralclub.org/ 1-2—PLAINS, ILLINOIS: Annual Exhibition; Des Plaines Valley Geological Society; Des Plaines Park District Recreation Center, 2222 Birch St, 530 Timber Dr; Saturday 9:30-5, Sunday 10-4; Request the access data from the club; Stones, gems, fossils, jewelry. Children's area Free parking. Silent auction. prize draw door prices. mineral identification available; contact Frank Edward Lavin, (815) 222-8197; Email: nival42@hotmail.com 1-2—CHICOPEE, MASSACHUSETTS: Annual Exhibition; Connecticut Valley Mineral Club; Knights Castle, 1599 Memorial Drive; Saturday 9:30-5, Sunday 9:30-3:30; Adult $5, children 12 and under free with paying adult, uniformed Boy Scouts free with paying adult; Free parking, free mineral samples for kids, prize drawings, exhibits, food available on site. CVMC is a non-profit educational organization; contact Barbara Meyer, (978) 394-3144; Email: bjmeyer56@yahoo.com; Website: www.cvmineralclub.org 1-2—TWELVE LAR, OREGON: 73rd Annual Dulce Hogar and Minerals Fair; the Hogar Dulce Mineral and Rock Society; Sweet Home High School Gymnasium, 1641 Long Street; Sat 10-6, Sun 10-5; Adults - 0.50, children up to 12 years free with adults; Exhibits from skilled craftsmen and dedicated hobbyists. Demonstrations by stone carvers such as B. Cabochon making, wire winding, flint working, and geode making. Vendors offer a wide range of gemstones, minerals, fossils, and slabs. Activities for adults include raffles and prizes at the door; contact Ed Anderson, (541) 451-2740; Email: ela4rocks@gmail.com 1-2—ELK RIVER, MINNESOTA: Exhibition; Rocks of the valleys and more; Community Events Center for Furniture and Stuff, 1000 School St NW; Sat 9-4, Sun 9-4; $1 Adult / 14 and under free with an adult; Discover a fascinating world where artisans display their unique pieces! We come together to showcase unique stones, crafts, and collections! It is wonderful; contact Dale Fure, (612) 708-82; Email: dalesrocks_more@outlook.com 1-2—SAN ANTONIO, TEXAS: Annual Exhibition; Southwest Gem and Mineral Society; Morris Center at Joe Freeman Coliseum, 723 AT&T Center Parkway Gate E; Sat 10-6, Sun 10-4; Adults $5 Seniors and Military $3 Children 7 and older $1; 61st Annual Silent Jewelry Auction Party, Hail A Cab, Ferris Wheel, 26 Vendors, Family Fun, $5 Parking; contact R.A. Bowie, (830) 387-1766; Email: krbotx@gvtc.com; Website: www.swgms.org 1-2—TAMPA, FLORIDA: Annual Exhibition; the Tampa Bay Mineral and Science Club; Florida State Fairgrounds - Special Events Center, 4800 US 301, entrance via MLK Jr. driveway; Sat 10-6, Sun 10-5; $10 at the box office, $8 with reservation on the club's website; Parking is free. ATM in front of the door. Indoor event with air conditioning. food stand. More than 63 suppliers that offer raw material, laminated material, wire, stone, geodes, minerals, crystals, jewelry and accessories. A special area for children with: decompression chamber, recognition of stones, black light, microscope, cornhole and cave painting; contact Greig Lundergan, (813) 684-2039; Email: tbmscshow@gmail.com; Website: http://www.tambayrockclub.org 1-2—SILOAM, ARKANSAS SOURCES: Annual Exhibition; Gem and Mineral Society of Northwest Arkansas; Siloam Springs Parish Building, 110 N. Mt. Olive Street; Sat 9-5, Sun 10-4; Adult, US$ 3. Children up to 10 years free; Arkansas Rocks! is our theme, with stones, minerals, fossils, jewels galore. The Kids Corner area offers activities for children. Educational exhibits with information from club members. Lapping demonstrations to show how stones are cut and polished. Silent auction and door prices all day; contact DeLane Cox, (479) 254-0894; Email: delanec3@earthlink.net; Website: Facebook: NWAGMS 7-9—PENSACOLA, FLORIDA: retail display; H&R Gem Shows; Pensacola Interstate Fair, 6655 Mobile Hwy, 9016 122nd Av; Fri 10-5, Sat 10-5, Sun 10-5; $5 adults. Children up to 12 years free. Teens/Veterans/Military/First Responders $1 off. Ticket valid for three days; Free parking. Fabulous 20,000 sf sellers. Jewelry, gems, crystals, rocks, minerals, pearls, fossils, raw materials and much more; contact Jerri Heer, (419) 344-9999; Email: hrgemshows@gmail.com; Website: www.hrgemshows.com 7-9—SANDY, AFTER: wholesale and retail fair; Gem Faire Inc.; Mountain America Expo Center, 9575 S State Street; Friday 12-6, Saturday 10-6, Sunday 10-5; $7 weekend pass; Fine jewelry, precious and semi-precious stones, millions of pearls, crystals, gold and silver, minerals and more at manufacturer prices. Buy directly from importers and wholesalers. repair and cleaning of jewelry during the purchase; contact Yooy Nelson, (503) 252-8300; Email: info@gemfaire.com; Website: www.gemfaire.com 7-9—OGDEN, AFTER: 70th Gemstone Junction Gem & Precious Show; Golden Spike Gem and Mineral Society; Golden Spike Event Center, Weber County Fairgrounds, 1000N 1200W; Friday 9-6, Saturday 10-6, Sunday 10-4; (Donation) Adult $5; Students ages 12-18 $3; Children up to 12 years old free accompanied by an adult; EXPLORE: Ferris wheel, gem hunt, Touch & See area with rock samples, visit fossil experts at Dinosaur Park, buy a bag, watch lapidary demos, go to Mr. , Minerals, gold, jewelry, pearls, precious stones, accessories; contact Margie Miller, (385) 205-9187; Website: www.goldenspikegem.org 8-9—BUTTERFLY, CALIFORNIA: Annual Exhibition; Mariposa Gems and Minerals Club; Mariposa County Fairgrounds, 5007 Fairgrounds Road; Sat 10-5, Sun 10-4; $3 for adults, kids 14 and under stay free, free parking; We have a great raffle, silent auction, geode cutting and delicious food, as well as mineral specimens, rough lapidaries, jewelry and many other rock artefacts; contact Meredith Meehan; email: mgmc@sti.net; Website: www.mariposagemclub.org 14-16—IN SOUTH JORDAN, AFTER: Annual Exhibition; Wasatch Gem Society; Bastian Agricultural Center, 2100 West 11400 South; Friday 10-6, Saturday 10-6, Sunday 10-4; $2 adults, children 12 and under free; Door Prizes, Ferris Wheel, Kids Table, Show and Tell, Shows, Exhibits, Crystals, Rocks, Minerals, Fossils, Wood, Gems, Jewelry, Dinosaur Bones and much more; contact Roberta Chase, (801) 541-7569; Email: roberta.chase@outlook.com 14-16—PLANT CITY, FLORIDA: retail display; H&R Gem Shows; Sadye Gibbs Martin Community Center, 1601 E Dr. MLK Jr Blvd, 9016 122nd Av; Fri 10-5, Sat 10-5, Sun 10-5; $5 adults. Children under 12 years free. Teens/Veterans/Military/First Responders $1 off. Ticket valid for 3 days; Free parking. Fabulous 15,000 sf sellers. Jewelry, gems, crystals, stones, minerals, pearls, fossils, rough stones and much more; contact Jerri Heer, (419) 344-9999; Email: hrgemshows@gmail.com; Website: www.hrgemshows.com 14-16—DANVILLE, INDIANA: Annual Exhibition; American Gem, Mineral and Jewelry Shows LLC; Hendricks County Fairgrounds, 1900 E Main St; Friday 10-6, Saturday 10-6, Sunday 11-4; Adults $7, ages 11-17 $2, children 10 and under free; suppliers of precious stones, minerals, jewelry, pearls, fossils and meteorites; contact Alan Koch; Email: agmjs3@gmail.com; Website: www.americangemshow.com 14-16—RICKREALL, OREGON: WAMS River of Gems 66th Annual Rock Show; Willamette Agate and Mineral Society; Polk County Fairgrounds, 520 S Pacific Hwy W; Fri 9-5, Sat 9-5, Sun 10-4; $5 per person 18+, 17 and under are free; There will be drug dealers, demonstrators, window displays, silent auctions, oral auctions, fluorescent displays and children's games; contact Ken Stubenrauch; Email: wams.riverofgems@gmail.com; Website: www.WAMSI.net 15-16—Marion, Ill.: Annual Exhibition; Southern Illinois Earth Science Club, Inc.; Marion City Pavilion, 1602 Sioux Dr; Sat 10-6, Sun 10-5; Adults $2, children under 18 free; Educational exhibits, rocks, minerals, fossils and jewelry. Fluorescent displays, silent auctions, sweepstakes, win-win artifacts and more; contact Michael Chontofalsky, (618) 532-0455; email: chontofalsky@att.net; Website: www.siesclub.org 15-16—LEFT OF IDAHO, IDAHO: 57th Annual Gem and Mineral Exposition in Idaho Falls; Idaho Falls Gem and Mineral Society; Idaho Falls Recreation Center, corner of Memorial Drive and B Street, 520 Memorial Drive; Sat 10-6, Sun 10-5; $3, children 12 and under free; Vendors selling everything from raw mineral and rock samples to finished jewelry, various children's activities (sand digging, thunder egg hunt, Ferris wheel, etc.), demonstrations by various club members, and showcases filled by our members, most vendors and the Edibles Available club itself; contact Tom Strong, (337) 384-6820; Email: wildlandlapidary@gmail.com; Website: www.ifrockhounds.com 16-16—Waterloo, Iowa: Annual Exhibition; Blackhawk Gem and Mineral Society; Waterloo Center for the Arts, 225 Commercial Street; Sol. 11-5; Admission is free. desired donations; Iowa Rockhounds: Collecting Rocks, Minerals and Fossils! Demonstrations and presentations throughout the day. Throughout the show, flint strikes, carving, goldsmithing, sale of crystals and geodes, handmade jewelry, precious stones and minerals are offered. Silent auctions that run throughout the day; contact Dave Malm; Email: davidmalm@cfu.net 21-23—YAKIMA, WASHINGTON: Annual Exhibition; Yakima Rock and Mineral Club; Central Washington State Fair Park modern residential building, 1301 South Fair Avenue; Fri 10-4, Sat 10-5, Sun 10-4; Adult $6, $1 off with coupon, Student $2, K - 12 and under free with paying adult; Sparkling Parade of Gems - 2023 - Celebrating our 60th show. Jewelry stores, children's activities, stone, mineral and fossil dealers, lucky bags, Ferris wheel, door prizes, raffles, silent auctions, special exhibits and exhibits. Groceries available, free parking at door #5. RV spots nearby; contact Martí Sondgeroth, (509) 910-3484; email: marthams@q.com; Website: www.yakimarockclub.com 21-23—SANTA ROSE, CALIFORNIA: wholesale and retail fair; Gem Faire Inc.; Sonoma County Fairgrounds, 1350 Bennett Valley Rd; Friday 12-6, Saturday 10-6, Sunday 10-5; $7 weekend pass; Fine jewelry, precious and semi-precious stones, millions of pearls, crystals, gold and silver, minerals and more at manufacturer prices. Buy directly from importers and wholesalers. repair and cleaning of jewelry during the purchase; contact Yooy Nelson, (503) 252-8300; Email: info@gemfaire.com; Website: www.gemfaire.com 21-23—WICHITA, KANSAS: Annual Exhibition; Wichita Gem and Mineral Society; Cessna Activity Center, 2744 George Washington Blvd; Friday 9-6, Saturday 10-6, Sunday 10-5; Adult: $5; Youth: 13-17: $1; Children up to 12 years old (accompanied by an adult): FREE; The 69th Annual Wichita Gem & Mineral Show is themed "Earth's Hidden Treasures." April 22 is Education Day; contact Gene Maggard, (316) 742-3746; Email: gandpmaggard@gmail.com; Website: www.wgmsks.org 22-23—MEMPHIS, TENNESSEE: Annual Exhibition; Archaeological and Geological Society of Memphis; Memphis Agricultural Center, 7777 Walnut Grove Road; Sat 9-6, Sun 10-5; Adults $6 (2-day pass $8), children 12 and under $2, uniformed Scouts free; More than 50 dealers and exhibitors sell stones, fossils, minerals, crystals, gemstones, opals, pearls, and jewelry. Children's areas with excavations of precious stones and fossils, geode and stone bowling 24 hours a day. Includes the original Memphis Rock Banquet, a table complete with rocks designed to look like real food; contact WC McDaniel, (901) 490-3575; email: info@theearthwideopen.com; Website: www.theearthwideopen.com. wixsite. with 22-23—CUYAHOGA VALLEY, OHIO: exhibition and sale; Akron Mineral Society and Summit Lapidary Club; Emidio Exhibition Centre, 48 E Bath Rd, 2028 Tallmadge Rd; Sat 10-6, Sun 10-5; Adults $5, Seniors (55+) $4, Children 7-14 $1. Ages 6 and up and Boy Scouts free; Our vendors offer rocks, minerals, fossils, gemstones, and jewelry and accessories. We have stone carving exhibits, youth activities, stone carving demonstrations, and mineral identification. We have geode cracking, silent auction, door prizes, food truck. Free parking, accessible for the disabled; contact Evelyn Tryon, President of Providers, (330) 673-9664; Email: gemboree76@gmail.com 22-23—WALNUT CREEK, CALIFORNIA: retail display; Pacific Crystal Guild; Civic Park Community Center, 1371 Civic Drive (at Broadway); Sat 10-6, Sun 10-4; $14 (valid for both days - free for children 12 and under); Minerals, gems, jewelry: more than 30 stalls; Contact Jerry Tomlinson 22-23—SANFORD, FLORIDA: exhibition and sale; Gem and Mineral Society of Central Florida, Inc.; Sanford Center, 401 E. Seminole Blvd; Sat 9-5, Sun 9-4; Adult $5, children 6-15 $2, uniformed scouts free; Vendors offering handmade minerals, stones, fossils, pearls, gemstones, cabochons and jewelry etc. Also available; silent auction, door prizes, demonstrations and family activities; contact Salvatore Sansone, (321) 278-9294; Email: ssfossilhunter@aol.com; Website: www.cfmgs.org 29-30—ANAHEIM, CALIFORNIA: Annual Exhibition; researchers from the Gem and Mineral Society; Brookhurst Community Center, 2271 W. Crescent Ave; Sat 10-5, Sun 10-4:30; Free; contact Nancy J. Bird, (562) 697-0636; Email: nancyjbird68@gmail.com 29-30—EAU CLAIRE, WISCONSIN: Annual Exhibition; Chippewa Valley Gem and Mineral Society; Eau Claire County Fairgrounds, 5530 Lorch Ave; Sat 9-5, Sun 10-4; Free; Chippewa Valley Gem and Mineral Society 59th Annual Show and Sale. Featuring fluorescent minerals, jewelry, gemstones, minerals, agates, geodes, fossils, petrified wood, rock art, beads, accessories, copper and silver findings, crystals, amethysts, books, and rough stones. Children activities. demonstrations; contact Paul Tubbs, (715) 834-5747; Email: CVGMS2017@gmail.com 29-30—Elma, WASHINGTON: 55th Annual Rock Show; Gray's Harbor Stones and Gems Club; Grays Harbor County Fair and Convention Center, 43 Elma-McCleary Road; Sat 10-5, Sun 10-4:30; free; Silent auction. Children spin a wheel Demonstrations. 1/2 hour drawings. offerer. camping site; contact Gary Emberley, (360) 533-6196; Email: melissa624@hotmail.com 29-30—TROY, OHIO: Annual Exhibition; Miami County Gem and Mineral Club; Miami County Expo Center, 650N. Co. 25-A Street; Sat 10-6, Sun 10-4; Adult $3 - Free admission for children under 17 years; merchants selling minerals, fossils, specimens, jewelry, and gemstones; demonstrations and exhibitions; Children activities; contact Dewey Buck, (937) 308-3012; Email: deweybuck12@gmail.com; Website: www.mcgamc.org 29-30—IRVINE, KENTUCKY: Annual Exhibition; SE KY Gems, Minerals and Fossils Club; Estill Co. School Site, 253 Main St; Sat 9-6, Sun 10-3; free; contact David Davis; Email: redandblackrocks@yahoo.com; Website: www.mountainmushroomfest.org 29-30—KENNEWICK, WASHINGTON: Annual Exhibition; Lakeside Gem and Mineral Club; Benton County Fairgrounds, Building 2, 1500 South Oak Street; Sat 10-5, Sun 10-4; $5 children 14 and under free with paying adult; exhibitions; dealers in precious stones, minerals, fossils and jewelry; Demonstrations including cabochon making, gem cutting, gem trees, bead making, goldsmithing, wire wrapping; Silent auction; youth activities; door prices; Giving up; fluorescent screens; crack geode; tailgating on Sunday morning; contact Larry Hulstrom, (509) 308-8312; email: rockhound132@charter.net; Website: www.lakesidegemandmineralclub.com 29-30—DOVER, NEW HAMPSHIRE: Annual Exhibition; Mineral Club in southeastern New Hampshire; Dover ELKS LODGE, 282 Durham Road (Route 108); daily 10-4, daily 10-4; $5 adults, children 12 and under free (must be accompanied by an adult); Spacious place with many excellent dealers in gemstones, minerals, jewelry and more. Silent auction every ½ hour and raffle every hour. running stone saws to open their treasure troves of geodes, taxi driver demonstrations on both days, and a children's digging area; contact Brian, (207) 606-972; Email: cshore108@yahoo.com; Website: https://www.senhmc.org/ 29-30—WESTSEATTLE, WASHINGTON: Annual Exhibition; West Seattle Rock Club; Alki Masonic Temple (West Seattle), 4736 40th Avenue SW; Sat 10-5, Sun 10-5; free; Silent auction, vendors, demonstrations, children's activities; contact Annette Nelson, (206) 379-3677; Website: www.westseattlerockclub.orgmayo 2023
5-6—YUCAIPA, CALIFORNIA: Annual Exhibition; Yucaipa Valley Gem and Mineral Society; Music and Arts Festival, Adams Street and Yucaipa Blvd; Friday, 6 to 10, Saturday, 12 to 10; FREE; Sample of stones, precious stones and costume jewelery with 15 vendors, children's activities, geode breakers, shop and raffle. The show is held in conjunction with the city-sponsored Yucaipa Music and Arts Festival, which features children's rides, various arts and crafts, food and other vendors, music, and a brewery/wine garden; contact Lee Peterson; Email: grandpasgems@gmail.com 5-7—KALAMAZOO, MÍCHIGAN: Annual Exhibition; Kalamazoo Geological and Mineral Society; Kalamazoo County Expo Center, 2900 Lake Street; Friday 4-8, Saturday 10-6, Sunday 10-5; Adult Admission: $5, children 12 and under are free. Scouts, free in uniform; The 2023 show is bigger: more than 50,000 square feet. New providers. Play games, polish a Petoskey stone, break a geode, build a mineral collection, search for fossils, buy pearls. Learn about geology through the many exhibits organized by KGMS members; hands-on educational activities provided by Western MI University; contact Dave Haas, (269) 625-5909; email: stonehouserock@cs.com; Website: www.kalamazoorockclub.org 5-7—SACRAMENTO, CALIFORNIA: wholesale and retail fair; Gem Faire Inc.; Scottish Rite Center, 6151 H St; Friday 12-6, Saturday 10-6, Sunday 10-5; $7 weekend pass; Fine jewelry, precious and semi-precious stones, millions of pearls, crystals, gold and silver, minerals and more at manufacturer prices. Buy directly from importers and wholesalers. repair and cleaning of jewelry during the purchase; contact Yooy Nelson, (503) 252-8300; Email: info@gemfaire.com; Website: www.gemfaire.com 6-7—TOPSFIELD, MASSACHUSETTS: Annual Exhibition; North Shore Rock and Mineral Club; Topsfield Fairgrounds, 207 Boston Road, Rte.1; Sat 9-5, Sun 10-4; $6 per person; $5 with card; children under 12 years free; free parking; contact Joe Weisberg, (781) 861-6653; email: northshorerockandmineral@gmail.com; Website: www.northshorerock.org 6-7—Kingman, Arizona: Annual Exhibition; Mohave County Gem Dealers; Mohave County Fairgrounds, 2600 Fairgrounds Blvd; Sat 9-5, Sun 9-4; Free for all; Mineral & Gemstone Show, Covered, Ample Free Parking, Door Prizes, Silent Auction, Treasure Chest Raffle; contact Daina Sandhop, (425) 268-9983; Email: ddaes1961@hotmail.com 6-7—LANCASTER, CALIFORNIA: Annual Exhibition; Antelope Valley Gem and Mineral Club; Antelope Valley Fairgrounds, 2551 WAVE H; Sat 10-5, Sun 10-5; Free admission and parking; The Antelope Valley Gem and Mineral Club annual show is coming up. Our annual show is held at the Antelope Valley Fairgrounds. We will have many vendors, displays, and activities for individuals and families. Please note that dogs are only allowed if they are service animals; contact Jamie, (661) 526-3564; Email: marylandoriole@gmail.com; Website: www.avgem.weebly.com 6-7—MARSHFIELD, WISCONSIN: Annual Exhibition; Wisconsin Heartland Gem and Mineral Society; Marshfield High School Field House, 1401 Becker Rd; Sat 10-5, Sun 10-4; Free; contact Cynthia Kelman, (608) 347-1765; email: kelman@tznet.com; Website: www.heartofwisconsinrocks.com 6-7—WACO, TEXAS: Annual Exhibition; Waco Gem and Mineral Club; Waco Convention Center, 100 Washington Ave; Sat 10-5, Sun 10-5; Children up to 6 years - Free; Scouts in uniform - free; Youth from 7 to 17 years old - US$3; All others - $5; contact Roy G. Cooper, (254) 749-9961; Email: Coopersfarmstore@yahoo.com; Website: www.WacoGemandMineral.org 12-14—COAST MESA, CALIFORNIA: wholesale and retail fair; Gem Faire Inc.; OC Feira & Events Center, 88 Feira Dr; Friday 12-6, Saturday 10-6, Sunday 10-5; $7 weekend pass; Fine jewelry, precious and semi-precious stones, millions of pearls, crystals, gold and silver, minerals and more at manufacturer prices. Buy directly from importers and wholesalers. repair and cleaning of jewelry during the purchase; contact Yooy Nelson, (503) 252-8300; Email: info@gemfaire.com; Website: www.gemfaire.com 12-14—Colombian, Misuri: Annual Exhibition; Central Missouri Rock and Lapidary Club; Knights of Columbus Hall, 2525 N. Stadium Blvd. (Ways); Friday 12-7, Saturday 9-5, Sunday 10-4; 3-Day Pass: Adult $6 - Seniors (60+) and Youth (12-16) $3 - Children 11 and under free; Door Prices, Silent Auctions, Kid Mine, Minerals, Gems, Fossils, Jewelry, Geodes, Pearls and more; contact Mary Wozny, (573) 999-3058; Email: lmwoz@msn.com; Website: www.cmrlc.org 13-14—BOZEMAN, MONTANA: Annual Gem, Jewelry, Fossil and Pearl Show - Mother's Day weekend; Bozeman Gem and Mineral Club; Gallatin County Fairgrounds, 901 North Black; Sat 10-6, Sun 10-4; Adult $3 Children 12 and under free with adult admission; Gemstone and mineral exhibits showcasing the best specimens from Montana and the world; Spectacular raffle item; silent auctions; 18 vendors; garnet classification; rock club; contact Linda Johnson, (406) 580-3419; Email: lindajohnson.montana@gmail.com 13-14—Brainerd, Minnesota: Annual Exhibition; Society of Rocks, Gems and Minerals of Cuyuna; Crow Wing County Fairgrounds, 2000 S.E. 13TH Street; Sat 9-5, Sun 10-4; Adults - $2, Children under 12 - $1, Mothers - Free on Sunday (Mother's Day); 80+ Vendors, Lake Superior Agates, Rocks, Minerals, Crystals, Jewelry, Exhibits, Locks, Kids Activities Including Agate Mound, Rock and Geode Cutting, Flint Breaking Demonstrations, Rock Wizard, Concessions; contact Ed Opatz, (320) 250-1363; Email: cuyunarockgemclub@gmail.com; Website: www.cuyunarockclub.org 13-14—Hermiston, Oregon: Annual Hatrockhounds Show: natural treasures underfoot; Hatrockhound Gem and Mineral Society; Eastern Oregon Trade and Events Center (EOTEC), 1705 East Airport Road; Sat 10-5, Sun 10-4; $3 children 12 and under free with adult; Dealers, exhibits, children's corner, silent auction, demonstrations; contact Mike Filarski, (541) 571-2593; Email: stonemorlin1@netscape.net 13-14—SAN ANTONIO, TEXAS: exhibition and sale; Southwest Gem and Mineral Society; Wonderland of the Americas Mall, 4522 Fredericksburg Rd; Sat 10-5, Sun 10-5; Free; free parking; contact John Speck, (210) 596-1611; Email: jspeck2@att.net; Website: www.swgms.org 19-21—FRANKLIN, NORTH CAROLINA: retail display; the Franklin Gem and Mineral Society; Robert C. Carpenter Community Building, 1288 Georgia Rd; Friday 10-6, Saturday 10-6, Sunday 10-4; Adult: $3; There will be demonstrations of stone cutting machinery and art, including cabochon making and cutting. There will be daily presentations by guest speakers on interesting and educational topics related to gems and minerals. There will be hourly prizes and a grand prize at the end of the show; contact Chandra Fox, (706) 982-0402; Email: fgmshows@gmail.com; Website: www.fgmm.org 19-21—PORTLAND, OREGON: Spectacle of rocks and gems by the mount. hood rock club; rock club Mt Hood; Kliever Memorial Armory, 10000 NE 33. Dr; Fri 10-5, Sat 10-5, Sun 10-3; free; More than 30 vendors sell: minerals, stones, pearls, jewelry, fossils, and much more. Children's corner with games and activities, raffles, door prizes and hourly prizes, lapidary and wire wrapping demonstrations, silent auction table with bargains, exhibitions of fossils, minerals, lapidaries, etc.; contact Darrell Engelhard; Email: mhrcdc@gmail.com; Website: mthoodrockclub.com 19-21—Tulsa, Oklahoma: wholesale and retail fair; Gem Faire Inc.; Expo Square, 4145 E 21st St; Friday 12-6, Saturday 10-6, Sunday 10-5; $7 weekend pass; Fine jewelry, precious and semi-precious stones, millions of pearls, crystals, gold and silver, minerals and more at manufacturer prices. Buy directly from importers and wholesalers. repair and cleaning of jewelry during the purchase; contact Yooy Nelson, (503) 252-8300; Email: info@gemfaire.com; Website: www.gemfaire.com 20-21—BENNINGTON, VERMONT: Annual Exhibition; Gem and Mineral Club of Southwest Vermont, Inc.; Grace Christian Schgool, 104 Kocher Dr.; Sat 10-5, Sun 10-4; Adult $5. Children Free; contact Bill Cotrofeld, (802) 375-6782; Email: cotrofeldauto@comcast.net 20-21—BENNINGTON, VERMONT: Annual Exhibition; Gem and Mineral Club of Southwest Vermont, Inc.; Grace Christian School, Kocher Dr. 104; Sat 10-5, Sun 10-3; Adult $5. Children FREE; mineral booklets for kids (free); contact Bill Cotrofeld, (802) 375-6782; Email: cotrofeldauto@comcast.net 20-21—WAUWATOSA, WISCONSIN: exhibition and sale; Wisconsin Geological Society; Müllner Building, Hart Park in Wauwatosa, 72nd and State Streets (park entrance); Saturday 10-4:30pm; Adults $3 or two for $5, kids free, parking free; Geology exhibitsDealer sales of gems, minerals, fossils, jewelryKids activitiesPrizes at the doorFood available; contact Paul Schmidt, (414) 771-8668; Email: pvs@wi.rr.com; Website: www.wigeo.org 26-28—Salem, Virginia: Annual Exhibition; American Gem, Mineral and Jewelry Shows LLC; Salem Civic Center, 1001 Roanoke Blvd; Friday 10-6, Saturday 10-6, Sunday 11-4; Adults $7, ages 11-17 $2, children 10 and under free; suppliers of precious stones, minerals, jewelry, pearls, fossils and meteorites; contact Alan Koch; Email: agmjs3@gmail.com; Website: www.americangemshow.com 26-28—MELBOURNE, FLORIDA: retail display; H&R Gem Shows; Melbourne Auditorium, 625 E Hibiscus Blvd, 9016 122nd Av; Fri 10-5, Sat 10-5, Sun 10-5; $5 adults. Children up to 12 years free. Teens/Veterans/Military/First Responders $1 off. Ticket valid for three days; Free parking. Fabulous 16,000 sf sellers. Jewelry, gems, crystals, stones, minerals. pearls, fossils, rough rocks and more; contact Jerri Heer, (419) 344-9999; Email: hrgemshows@gmail.com; Website: www.hrgemshows.com 27-28—CANBY, OREGON: 59th Annual Gem & Rock Expo - "Rock Jamboree in 2023"; Clackamette Mineral and Gem Corp; Clackamas County Fairgrounds, 694 NE 4th Ave; Sat 9-6, Sun 10-4; free; Vendors, Award Winners, Demonstrations, Children's Corner, Weight Estimation, Sleepers, Raffle, Bargain Stones, Displays, Silent Auction, Free Parking; contact Karen McAllister; Email: gmaktmc@gmail.com; Website: www.clackamettegem.org 27-28—Monroe, Washington: 68th Annual Show of Gems, Jewelry and Minerals; Everett Stones and Gems Club; Evergreen State Fairgrounds, Weidel Event Center, 18359 Cascade View Drive; Sat 10-6, Sun 10-5; free; crystals and geodes; screens and screens; Tools and equipment; Children activities; Silent auction; club sales table; port prices per hour; merchants; and demos. free parking; contact Fritz Mack, (425) 232-0809; Website: http://www.everettrockclub.comJune 2023
2-3—Springfield, Missouri: Annual Exhibition; Ozarks Gem and Mineral Society; Prince of Peace Lutheran Church, 815 E Farm Rd 182 (Planview); Friday 9-5, Saturday 9-5; Admission is free; Vendors with a variety of treasures for sale - there is something for everyone including blanks, slabs, booths, jewelry, minerals, display specimens, geodes, gemstones, fossils and much more. It is an outdoor and fun event for the whole family; contact Amy Hinkler, (417) 597-4657; Email: omgms.57@gmail.com; Website: www.ogms.rocks 2-4—DULUTH, GEORGIA: Annual Exhibition; Bellpoint Gem Show; Gas South Convention Center (new location), 6400 Sugarloaf Pkwy; Friday 10-5:30, Saturday 10-5:30, Sunday 10-4:30; Admission $8 cash only at the door; Selected dealers from near and far selling rare minerals, jewelry, gemstones, fossils, healing stones, pearls, crystals, stones; contact BJ; Email: mbellpoint@gmail.com; Website: www.bellpointpromotions.com 2-4—BONNEY-SEE, WASHINGTON: Annual Exhibition; Puyallup Valley Gem and Mineral Club; Swiss Park - Lake Bonney, 9205 198th Avenue E; Friday 12-5, Saturday 10-5, Sunday 10-4; Free; contact Jillian Higgins, (253) 987-6751; Email: pvgamc@gmail.com; Website: puyallupvalleygemandmineralclub.com/ 3-3—DELTA, COLORADO: Annual Exhibition; Delta County Rock Wranglers; Heddle Recreation Center, 531 North Palmer Street; Saturday 9-5; Free pass; Internal shows from thirty vendors, Silent Action, Rock Bags for sale for children and special activities for children; contact Harry Masinton, (970) 856-3861; Email: hpmasinton@gmail.com 3-4—AMISTAD OCCIDENTAL, MARYLAND: Annual Exhibition; Mid-Atlantic Gem and Mineral Association, LLC; Howard County Fairgrounds, 2210 Fairgrounds Road; Sat 10-5, Sun 11-4; $6; Gem Miner's Spring Gem, Mineral and Pearl Show; Discounted admission available online; contact Teresa Soltis Schwab, (301) 807-9745; email: beadware@rcn.com; Website: gem-show.com 3-4—Marion, Kentucky: Annual Exhibition; Ben E. Clement Museum of Minerals; Ben E. Clement Museum of Minerals, 205 Walker Street; Sat 9-5, Sun 10-4; Check with the museum for admission prices; Gate Hourly Rates Silent Auctions Vendor Tables Museum Tours/Gift Shop Children's Activities Midwest Chapter of the Fluorescent Minerals Society and SHOW & Sale; contact Jackie Dismore, (270) 965-4263; Website: ClementMineralMuseum.org 9-11—MILACA, MINNESOTA: Annual Exhibition; Rocks of the valleys and more; Hairy Mosquito Trading Co, 21287 US-169; Friday 9-5, Saturday 9-5, Sunday 9-5; Free pass; This is the fourth annual Rock N Gem & Artisan show. There are adventures for everyone!! There will be over 65 vendors set up in an outdoor park, selling all things gemstone! There will also be other artisans offering their own personal creations just for you to choose from; contact Dale Fure, (612) 708-8279; Email: dalesrocks_more@outlook.com 10-10—Kent, Connecticut: Exhibition; Connecticut Museum of Antique Machinery and Danbury Mineralogical Society; Connecticut Museum of Antique Machinery, 31 Kent-Cornwall Road (Route 7); Saturday 9-4; Free; Visit the new mining exhibits; contact John Pawloski, (860) 354-029; Email: j.a.pawloski@att.net 10-11—SAN FRANCISCO, CALIFORNIA: retail display; Pacific Crystal Guild; San Francisco County Fair Building, 1199 - 9th Avenue (at Lincoln Way), Golden Gate Park; Sat 10-6, Sun 10-4; $14 (valid for 2 days - free for children 12 and under); San Francisco's Largest Gem & Mineral Show: Celebrates 37 Years; contact Jerry Tomlinson, (415) 383-7837; email: jerry@crystalfair.com; Website: http://www.crystalfair.com 10-11—HIDDEN, CALIFORNIA: Annual Exhibition; Palomar Gem and Mineral Club; California Center for the Arts - Convention Center, 340 North Escondido Blvd; Sat 10-5, Sun 10-4; $5 adults, children 12 and under free; contact Toni Floyd; Email: tonifloyd41615@gmail.com; Website: www.palomargem.org 10-11—HIDDEN, CALIFORNIA: Annual Exhibition; Palomar Gem and Mineral Club; California Center for the Arts - Convention Center, 340 North Escondido Blvd, 41615 Chaparral Dr; Sat 10-5, Sun 10-4; $5, children 12 and under free; Artisans sell handcrafted silver, gold, pearl and imitation jewelry, vintage and antique jewelry, commercial-grade faceted gold and silver jewelry, specialty handmade cabochons, mineral specimens, gemstone trees, other decorative lapidary items, as well as like rough stones from Africa and Australia; contact Toni D. Floyd; Email: pgmcshow@gmail.com; Website: www.palomargem.org 15-18—PRINEVILLE, OREGON: Prineville Rockhound Powwow; Prineville Rock Hounds; Crook County Fairgrounds, 120S Main Street; Thursday 9-5, Friday 9-5, Saturday 9-5, Sunday 9-4; free; Membership required for excursions $10 per family. Visits from June 16 to 18. See the Facebook page for more details. Field Trip Contact: Joe Van Cura, jvancura@peak.org; contact Jim McCoy; Email: Jimmcoy57@yahoo.com 16-18—REEDSPORT, OREGON: Annual Gemstone & Gem Show on Father's Day weekend; Lower Umpqua Gem & Lapidary Society; Reedsport City Hall/Community Center, 451 Winchester Ave; Fri 10-5, Sat 10-5, Sun 10-4; free (donations accepted and appreciated); This family extravaganza takes place on Father's Day weekend (if you call Bambi, leave a message); contact Bambi Darling, (541) 420-8014; Email: reedsportrockshow@gmail.com; Website: ReedsportRockandGemShow.com 16-18—PINO GRANDE, WYOMING: Annual Exhibition; Sublette County Rock Hounds; Sublette County Fairgrounds Event Center, 10937 Hwy 189; Friday 9-5, Saturday 9-5, Sunday 9-3; Adults $2, children free; Vendors, marchers, exhibits, Mr. Bones Dinosaur Puppeteer, field trips, children's activities; contact Jim Gray, (307) 260-6442; Email: jimgray@wyoming.com 16-18—Swannanoa, North Carolina: Annual Exhibition; MAGMA, Jacquot & Son Mineração; Earth of Heaven Sanctuary Club, 39 Spring Cove Road; Friday 9-6, Saturday 9-6, Sunday 10-5; Free; XXII MAGMA Exhibition of Precious Stones, Minerals and Fossils. Numerous vendors offer a wide variety of gemstones, minerals, fossils, jewelry, lapidaries, antique collections, and all manner of other treasures. Our new place has heat and air conditioning. clean toilets and fantastic food served every day; contact Richard Jacquot, (828) 779-4501; Email: rickjacquot@gmail.com; Website: www.americanrockhound.com 22-25—MADRAS, OREGON: Annual Exhibition; Rock Gatherers LLC; Jefferson County Fairgrounds - Madras, Oregon, 430 SW Fairgrounds Road; Daily 9-6, Sun 9-2; Free - excursions $10 per person; Old show, new moderator! Madras Rock and Gem Show has more than 40 vendors and more than 70 years of history. Don't miss this show! Vendors offer everything from rough rock to finely crafted jewelry; Cabins and panels for surprising sculptures. You'll find tools and expertise along with daily excursions; contact Steven Keever, (541) 233-8953 23-25—ELDON, MISSOURI: Annual Exhibition; Osage Rock and Mineral Club; Eldon Community Center, 309 East 2nd. st.; Friday 2-6, Saturday 9-6, Sunday 9-3; No entrance fee; Gemstones, jewelry, geodes, fossils, minerals, quartz crystals, custom jewelry by many talented artists, cabochons, giveaways, demos, displays, games and prizes for kids, fluorescent mineral displays; contact Roger Varvel, (417) 533-2788; email: ormc2023show@centurylink.net; Website: Osage Rock and Mineral Club (Facebook) 23-25—Bedford, Indiana: Annual Exhibition; Lawrence County Rock Club; Lawrence County Fairgrounds, Highway 50; Friday 10-6:30, Saturday 9-6:30, Sunday 10-4; Free and free parking; 58th Annual Gem, Mineral Fossil Show Huge selection of gems, jewelry, pearls, minerals, fossils, rocks, lapidary, Rockhound and prospecting supplies, materials for 4-H projects and science projects. A fun, interesting and educational experience for all ages; contact Kathy Shaffer, (812) 929-5367; Website: www.lawrencecountyrockclub.orgjulio 2023
8-9—SYRACUSE, NEW YORK: Annual Exhibition; Syracuse Gem and Mineral Society; Center of Progress Building, NYS Fairgrounds, 581 State Fair Blvd; Sat 10-6, Sun 10-4; $7 for adults, children 12 and under free; 56 high-end retailers and 5 wholesalers, 6 metaphysical practitioners Foot-cutting, cutting and jewelry demos Children's activities Lectures on Saturdays and Sundays; contact Cheryl Brown, (315) 708-9122; Email: gmssrocks@gmail.com; Website: www.syracusegemsociety.com 14-15—MINOCQUA, WISCONSIN: Annual Exhibition; lakeland gem club; Lakeland High School, 9573 70 State Street; Friday 10-6, Saturday 9-5; Free; Silent auctions, raffles and children's jewelry bags; contact Daniel James Erickson, (715) 479-2900; Email: nettrocks@gmail.com 14-16—CASPER, WYOMING: Annual Exhibition; Natrona County Rock Dog Club; Ramkota Hotel, 800 N. Alamo; Friday 9-5, Saturday 9-5, Sunday 9-4; $3, free for children 12 and under; Raffles, Door Prizes, Silent Auction, Taxi Driver Demo by Lapidary Gary, Vendor; contact Mac Goss, (307) 439-9873; Email: macogre13@yahoo.com 14-16—SHOW BAJO, ARIZONA: Annual Exhibition; White Mountain Gem and Mineral Club; Show Low Elks Lodge, 805 East Whipple; Fri 9-5, Sat 9-5, Sun 10-4; Adults $4, children accompanied by an adult free; Contact C.E. Hickman; Email: carlhickman8@earthlink.net; Website: www.whitemountain-azrockclub.org 15-16—ERIE, PENSYLVANIA: exhibition and sale; Gem City Rock and Mineral Society; Zem Zem Shriners Banquet and Conference Center, 2525 West 38th Street (SE corner of 38th Street and Zuck Rd); Sat 10-6, Sun 10-5; Adults $4 Children under 12 years free; contact Robert Gallivan, (814) 454-6770; Email: gallivan427@gmail.com; Website: www.gemcityrockclub.org/ 22-23—FRIEDRICH, WISCONSIN: Annual Exhibition; Indianhead Gem and Mineral Society; Frederic High School Gymnasium, 1437 Clam Falls Dr. Sat 10-5, Sun 10-4; Free; 56th Annual Gem and Mineral Exhibition. door prices Demonstrations of wiring, lapping, flint rolling and sphere making. Agates, minerals, fossils, gemstones, and jewelry are on display and available for sale. Lunch and snacks are available at the 4H Club; contact Roy Wickman, (715) 357-3223 27-30—FAIR PLAY, COLORADO: Annual Exhibition; Jay Penn; Fairplay River Park Event, 200 Platt Dr, 2324 Alvarado Dr. EH; Thursday 9-5, Friday 9-5, Saturday 9-9, Sunday 9-5; Free admission, free parking; Fairplay Gem, Mineral & Jewelry Show – 26 dealers at this outdoor show. Some examples are minerals, raw materials, slabs, costume jewellery, cabochons, beads; contact Amy J. Penn, (505) 203-1900; Email: amypenn246@gmail.com; Website: abqfallshow.wix.com/fairplay 29-29—TOWNSHIP, DAKOTA DEL SUR: Annual Exhibition; Sioux Empire Gem and Mineral Society; Bethany Reformed Church, 702 W 7th St; Saturday 10-5; Adults $2 Children under 12 years free; contact Harlan Hoogeterp, (605) 987-2446; Email: rockswap@segams.orgAugust 2023
3-6—BILLS, MONTANA: 2023 American Federation and Northwest Federation Gem and Mineral Fair; Billings Gem and Mineral Club; Billings Hotel and Convention Center, 1223 Mullowney Ln; Thursday 10-5, Friday 10-5, Saturday 10-5, Sunday 10-4; Adults $5 per day or $15 for 4-day pass (cash only) Children 12 and under free with paying adult; Don't miss this special regional and national show! With vendors and displays of gemstones, minerals, fossils, artifacts, agates, jewelry and more. Sweepstakes, Silent Auctions, and Lots of Kids Fun Events Family fun includes field trips, banquets, special programs, special exhibits; contact Doug True, (406) 200-8778; Email: https://billingsgemclub.com/contact-us; Website: BillingsGemClub.com 10-13—BOA VISTA, COLORADO: Annual Exhibition; Buena Vista Continuous Tail Gem, Mineral & Fossil Show; Buena Vista Rodeo Grounds, Gregg Dr.; Thursday 9-6, Friday 9-6, Saturday 9-6, Sunday 9-6; Free admission, free parking; Visit Colorado's largest outdoor fossil and mineral exhibit, The Contin-Tail, which is being established on the Continental Divide in beautiful Buena Vista, CO. Annually, 100 purveyors of gemstones, minerals, jewelry, fossils and more come together in the beautiful Valley of Buena Vista Colorado. Social networks @bvrockshow; contact Rachel Ford; Email: bvrockshow@gmail.com; Website: www.bvrockshow.com 11-13—PUERTO TOWNSEND, WASHINGTON: Annual Exhibition; Harbor Townsend rock club; Port Townsend WA, 4907 Landes; Friday 10-8; County Fair Admission: $8 for adults; $6 senior; $2 for children; contact Joan Zimmerman, (360) 809-2097; Email: jzim@gci.net 18-20—RICKREALL, OREGON: late summer rock concert; Willamette Agate and Mineral Society; Polk County Fairgrounds, 520 S Pacific Hwy W; Fri 9-5, Sat 9-5, Sun 10-4; free; contact Ken Stubenrauch; Email: wams.riverofgems@gmail.com; Website: www.WAMSI.net 18-20—LEBANON, PENNSYLVANIA: wholesale and retail fair; Mid-Atlantic Gem and Mineral Association, LLC (MAGMA); Lebanon Valley Expo, 80 Rocherty Rd; Friday 10-6, Saturday 10-6, Sunday 10-4; $6, kids 12 and under and veterans free; Gem Miner's Jubilee Show with precious stones, pearls, jewels, minerals and fossils. Outdoor tailgate area, wholesale hall, educational demonstrations; contact Teresa Soltis Schwab, (301) 807-9745; email: beadware@rcn.com; Website: www.gem-show.com 19-20—BOSSIER CITY, LOUISIANA: Annual Exhibition; Arklatex Gem and Mineral Society; Bossier Civic Center, 620 Benton Rd.; Sat 9-6, Sun 10-4; Daily $5, two-day pass $7 Children 12 and under, Boy Scouts in uniform, students with ID. Free; On Saturday there will be a children's gymkhana with prizes for the first 60 participants. Gate prizes will be awarded every hour during the event; contact Del Glasner, (318) 517-7372; Email: larockclub@gmail.com; Website: www.larockclub.com 19-20—RICE LAKE, WISCONSIN: Annual Exhibition; Gem and Mineral Society of Northwest Wisconsin; Barron County Fairgrounds - Youth Expo Center, 101 Short St, (at Highway 48 - North End of Rice Lake); Sat 10-5, Sun 10-4; Free; With fluorescent minerals. Tickets - Children's Activities and Children's Museum. Demonstrations and exhibitions. Museum-quality minerals, specimens, Lake Superior agates, fossils, jewelry and more. Bring your rocks, fossils, minerals, crystals, and artifacts for a free ID. lunch available; contact Roy Wickman, (715) 357-3223 25-27—MARIETTA, GEORGIA: Annual Exhibition; Bellpoint Gem Show; Cobb Civic Center, 548 S Marietta Pkwy; Friday 10-5:30, Saturday 10-5:30, Sunday 10-4:30; Admission $8 cash only at the door; Selected dealers from near and far selling rare minerals, jewelry, gemstones, fossils, healing stones, pearls, crystals, stones; contact BJ; Email: mbellpoint@gmail.com; Website: www.bellpointpromotions.com 26-27—CANTON, NEW YORK: Annual Exhibition; Rock and Mineral Club of St. Lawrence; Canton Pavilion, NY, 90 Lincoln Street; Saturday 9-4:30, Sunday 9-3; Adults $4, children under 12 free; contact William de Lorraine, (315) 287-2560; Email: wdellie@gmail.com; Website: www.stlawrencecountymineralclub.org 26-27—ELCHHÜGEL, WISCONSIN: Rock swap meeting; Chippewa Valley Gem and Mineral Society; City of Wheaton Ballparks - South Field, 3900 38th St.; Sat 8-4, Sun 8-4; Free; Outlets - 20' x 20' - $25.00 per day. Gems and minerals and rock related equipment. Pay the day of the show. Payable to: Chippewa Valley Gem & Mineral Society. Rain or shine! Something for everyone! Purchases and changes. No camping overnight. food and drinks available; contact Paul Tubbs, (715) 834-5747; Email: CVGMS2017@gmail.comSeptember 2023
1-3—SAINT PETERSBURG, FLORIDA: retail display; H&R Gem Shows; St. Petersburg Coliseum, 535 4th Ave N; Fri 10-5, Sat 10-5, Sun 10-5; $5 adults. Children up to 12 years free. Teens/Veterans/Military/First Responders $1 off. Ticket valid for three days; Free parking. Fabulous 15,000 sf sellers. Jewelry, gems, crystals, rocks, minerals, pearls, fossils, raw rock and much more; contact Jerri A. Heer at 419-344-9999; Email: hrgemshows@gmail.com; Website: www.hrgemshows.com 9-10—PORT ANGLES, WASHINGTON: Annual Exhibition; Clallam County Gem and Mineral Association; Vern Burton Community Center, 308 East 4th Street; Sat 9-5, Sun 10-4; free; family event; contact Kathy Schreiner, (360) 460-0827; Email: kmsjes@olypen.com; Website: www.sequimrocks.org 23-24—LUBBOCK, TEXAS: exhibition and sale; Lubbock Gem and Mineral Society; Lubbock Memorial Civic Center, 1501 Mac Davis Lane; Sat 10-6, Sun 10-5; Ages 13 and older $5, Ages 6 - 12 $3, Ages 5 and under Free; We will have distributors all over the country selling things from all over the world. Member shows, presentations, door prizes and 2 grand prizes. Silent Auction, exhibitions and a large children's area; Contact Walt Beneze; email: walt@lubbockgemandmineral.org; Website: www.lubbockgemandmineral.org 23-24—SAN ANTONIO, TEXAS: exhibition and sale; Southwest Gem and Mineral Society; America's Wonderland, 4522 Fredericksburg Rd; Sat 10-5, Sun 10-5; Free; free parking; contact John Speck, (210) 596-1611; Email: jspeck2@att.net; Website: www.swgms.org/September 2023 to October 2023
30-1—ESTE DE MOLINE, ILLINOIS: Annual Exhibition; Researchers worthy of the Earth; Rock Island County Fairgrounds, 4200 Archer Drive; Sat 9-5, Sun 9-4; $1, kids 12 and under stay free; Sellers from all over the Midwest! Indoor and outdoor show. geode cracks, mining locks, children's activities; contact Cindy Cottrell, (563) 210-4744; Email: cc31068@yahoo.comOctober 2023
6-8—ALBUQUERQUE, NEW MEXICO: Annual Exhibition; Jay Penn; Expo NM State Fairgrounds, 300 San Pedro NE; Friday 9-5, Saturday 9-5, Sunday 9-5; Free pass; 70 merchants, samples of minerals, raw materials, slabs, jewelry, findings, cabochons, pearls, fossils, petrified wood; contact Jay Penn, (505) 883-4195; Email: jaypenn246@gmail.com; Website: abqfallshow.wix.com/abq-fall-show 6-8—HILLSBORO, OREGON: 42nd Portland Regional Gem & Mineral Expo; Portland Regional Jewelry and Minerals Association; Wingspan Event Center Building, Westside Commons, 801 NE 34th Avenue; Friday 10-6, Saturday 10-6, Sunday 10-5; Admission $7 Kids 12 and under free with paying adult (off-site parking fees); 45 dealers in fossils, stones, gems, minerals, pearls, tools, jewelry. Activity corner for children. Lots of educational exhibits/exhibits. Protesters display gemstone cutting, wire wrapping, cabochon, door and prize raffle, silent auction. Interactive fossil discovery area; contact Linda Harvey; Email: lindaharvey2010@gmail.com; Website: www.PortlandRegionalGemandMineral.com 6-8—PLANT CITY, FLORIDA: retail display; H&R Gem Shows; Sadye Gibbs Martin Community Center, 1601 E Dr. MLK Jr. Avenue; Fri 10-5, Sat 10-5, Sun 10-5; $5 adults. Children up to 12 years free. Teens/Veterans/Military/First Responders $1 off. Ticket valid for three days; Free parking. Fabulous 15,000 sf sellers. jewelry, gemstones, crystals, rocks, minerals, pearl fossils, raw rock and much more; contact Jerri A. Heer, (419) 344-9999; Email: hrgemshows@gmail.com; Website: www.hrgemshows.com 7-7—IDAHO, IOWA FALLS: Annual sale of stones, precious stones and jewelry to associates; Idaho Falls Gem and Mineral Society; Bonneville County Fairgrounds, Event Center Bldg, 1542 East 73rd South; Saturday 9-5; Admission - $3, children 12 and under free; This year's event will be exceptional with the return of Chris Anderson from Lion Punch Forge demonstrating the team of him and PepeTools; contact Monique Lake, (208) 757-8036; Email: moniquelake1@gmail.com 7-8—Monroe, Washington: 47th Rocktoberfest; Rock and Gem Club of Marysville; The Evergreen State Fairgrounds, Display Bldg #500, 14405 179th Ave, SE; Sat 10-5, Sun 10-5; free; Crude, slabs, polished cabins, minerals, fossils, tools and lapidaries, jewelry, demonstrator, children's activities and exhibitions club, free parking. Facebook-www.facebook.com/Marysville-Rock-and-Gem-Club-213484905338173; contact Christina Morrissey; email: cmvw@frontier.com; Website: www.marysvillerockclub.com 7-8—SPRINGFIELD, ILLINOIS: Annual Exhibition; LOESS Lincoln Orbit Earth Science Society; Orr Building Illinois State Fair Grounds, Orr Building Illinois State Fair Grounds; Sat 10-6, Sun 10-5; adults $2 seniors and children $1; children's activities, door prizes; Contact Ed Wagner. club president, (309) 838-7782; Email: LOESSpresident@gmail.com 14-15—SERRA VISTA, ARIZONA: Annual Exhibition; Club of Minerals and Gems of Huachuca; Sierra Vista Shopping Center, 2200 El Mercado Loop; Sat 9-5, Sun 10-4; Free admission and parking; 49th Annual Exhibition. Access disabled. Multiple vendors, inside and out. Jewelry, mineral samples, rock art, children's activities. Small show but worth a visit; contact Maudie E. Bailey, (520) 249-1541; Email: gmbailey@msn.com; Website: www.hmgc.site 20-22—SPRINGFIELD, ILLINOIS: Annual Exhibition; MAPS from the Central American Paleontology Society; Illinois State Fairgrounds ORR Building, 66 4H Rd; Friday 9-5, Saturday 8-5, Sunday 8-3; Free pass; Conference Friday 5:30 pm Northfield Inn 3280 Northfield Drive. Saturday Live Auction There are fossil talks given on Friday and Saturday during the show; contact Thomas Williams, Exhibit President, (815) 228-5083; Email: paleotom234@gmail.com; Website: www.midamericapaleo.org 20-22—DANVILLE, INDIANA: Annual Exhibition; American Gem, Mineral and Jewelry Shows LLC; Hendricks County Fairgrounds, 1900 E Main St; Friday 10-6, Saturday 10-6, Sunday 11-4; Adults $7, ages 11-17 $2, children 10 and under free; suppliers of precious stones, minerals, jewelry, pearls, fossils and meteorites; contact Alan Koch; Email: agmjs3@gmail.com; Website: www.americangemshow.comNovember 2023
3-5—HONOLULU, HAWAII: Annual Exhibition; Honolulu Show, LLC; Hawaii Convention Center, 1801 Kalakaua Ave; Friday 10-6, Saturday 10-8, Sunday 10-6; adults $10 | children $5; Hosted by the founder of The Denver Show, The 22nd Street Show and The NJ Show. See your Asian sellers and buyers halfway instead of waiting for them to come to Tucson! The hotel costs $190/night; UPS Freight starts at $450/pallet; booth fee is $1,200 and flights are free with your FF miles; contact Lowell Carhart, (804) 291-6357; email: lowellcarhart@yahoo.com; Website: www.Honolulu.Show 18-19—LEBANON, PENNSYLVANIA: wholesale and retail fair; Mid-Atlantic Gem and Mineral Association, LLC (MAGMA); Lebanon Valley Expo, 80 Rocherty Rd; Saturday 10-5; $6, kids 12 and under and veterans free; Gem Miner Christmas show with gems, jewelry, pearls, minerals, fossils, gifts and crafts. demo room and wholesale; contact Teresa Schwab, (301) 807-9745; email: beadware@rcn.com; Website: www.gem-show.comDecember 2023
1-3—DULUTH, GEORGIA: Annual Exhibition; Bellpoint Gem Show; Gas South Convention Center (new location), 6400 Sugarloaf Pkwy; Friday 10-5:30, Saturday 10-5:30, Sunday 10-4:30; Admission $8 cash only at the door; Selected dealers from near and far selling rare minerals, jewelry, gemstones, fossils, healing stones, pearls, crystals, stones; contact BJ; Email: mbellpoint@gmail.com; Website: www.bellpointpromotions.comFAQs
How to UPDATE view data in SQL? ›
- In Object Explorer, expand the database that contains the view and then expand Views.
- Right-click the view and select Edit Top 200 Rows.
- You may need to modify the SELECT statement in the SQL pane to return the rows to be modified.
The UPDATE statement is used to modify the existing records in a table.
What are the commands to UPDATE data? ›An SQL UPDATE statement changes the data of one or more records in a table. Either all the rows can be updated, or a subset may be chosen using a condition. The UPDATE statement has the following form: UPDATE table_name SET column_name = value [, column_name = value ...]
How do you UPDATE all tables at once? ›Update all fields in a document
Press F9. If your document has tables with fields or formulas, you might need to select each table separately and press F9.
Syntax: UPDATE table_name SET column_name1 = new_value1, column_name2 = new_value2 ---- WHERE condition; Here table_name is the name of the table, column_name is the column whose value you want to update, new_value is the updated value, WHERE is used to filter for specific data.
Can we use update command in view? ›Yes we can insert,Update and delete, if a view is not complex. In SQL, a view is a virtual table based on the result-set of an SQL statement. A view contains rows and columns, just like a real table. We can insert, update and delete a view.
What are the 3 update commands in SQL? ›- INSERT - adds a single or multiple records in the table.
- UPDATE - modifies an existing record.
- DELETE - removes a record from the database.
We can update the multiple rows of the table using the single update command.
How do I update all things in Linux? ›Issue the command sudo apt-get upgrade. Enter your user's password. Look over the list of available updates (see Figure 2) and decide if you want to go through with the entire upgrade. To accept all updates click the 'y' key (no quotes) and hit Enter.
What is update command function? ›UPDATE Command is used to update existing records in a database. ALTER Command by default initializes values of all the tuple as NULL. UPDATE Command sets specified values in the command to the tuples. This command make changes with table structure.
What is SQL update command? ›
The UPDATE command in SQL is used to modify or change the existing records in a table. If we want to update a particular value, we use the WHERE clause along with the UPDATE clause. If you do not use the WHERE clause, all the rows will be affected.
How do you update data in a database? ›To use the UPDATE method, you first determine which table you need to update with UPDATE table_name . After that, you write what kind of change you want to make to the record with the SET statement. Finally, you use a WHERE clause to select which records to change.
How do I manually UPDATE all? ›- Open the Google Play Store app .
- At the top right, tap the profile icon.
- Tap Settings Network Preferences. Auto-update apps.
- Select an option: Over any network to update apps using either Wi-Fi or mobile data. Over Wi-Fi only to update apps only when connected to Wi-Fi.
For instance, updating 2 different tables together in a single query/statement. This involves the use of the BEGIN TRANSACTION clause and the COMMIT clause. The individual UPDATE clauses are written in between the former ones to execute both the updates simultaneously.
How do I manually UPDATE a data table in Excel? ›Update only the selected data Press ALT+F5, or on the Data tab, in the Connections group, click the arrow under Refresh All, and then click Refresh. Update all data in the workbook Press CTRL+ALT+F5, or on the Data tab, in the Connections group, click Refresh All.
How do I update all rows? ›In SQL, sometimes situations arise to update all the rows of the table. We will use the UPDATE command to achieve this in SQL. For this article, we will be using the Microsoft SQL Server as our database. UPDATE table_name SET column1 = value1, column2 = value2, ...
How do I update a table field in SQL? ›- SQL Server / MS Access: ALTER TABLE table_name. ALTER COLUMN column_name datatype;
- My SQL / Oracle (prior version 10G): ALTER TABLE table_name. MODIFY COLUMN column_name datatype;
- Oracle 10G and later: ALTER TABLE table_name.
There are a couple of ways to do it. INSERT INTO students (id, score1, score2) VALUES (1, 5, 8), (2, 10, 8), (3, 8, 3), (4, 10, 7) ON DUPLICATE KEY UPDATE score1 = VALUES(score1), score2 = VALUES(score2);
Will updating the view update table? ›Yes. The data "in" a view has no existence independent from the tables that make up the view. The view is, in essence, a stored SELECT statement that masquerades as a table. The data is stored in the original tables and only "assembled" into the view when you want to look at it.
What is update command with example? ›Update command is a data manipulation command which is used to edit the records of a table. It may be used to update a single row based on a condition, all rows or set of rows based on the condition given by the user.
How to UPDATE 2 values in SQL? ›
We can update multiple columns in SQL using the UPDATE command. The UPDATE statement is followed by a SET statement, which specifies the column(s) where the update is required. Syntax: UPDATE table_name SET column1 = value1, column2 = value2, ...
Which query is used to UPDATE? ›You use update queries in Access databases to add, change, or delete the information in an existing record. You can think of update queries as a powerful form of the Find and Replace dialog box. You cannot use an update query to add new records to a database, or to delete records from a database.
Which command will UPDATE all packages? ›sudo apt-get update and sudo apt-get upgrade are two commands you can use to keep all of your packages up to date in Debian or a Debian-based Linux distribution.
How do I update multiple records in list view? ›To edit multiple records in a List View in Salesforce, click on the pencil icon to enable editing (highlighted in yellow in the image below). Next, select the records you want to edit by clicking on their corresponding checkbox.
How do I update thousands of records in SQL? ›- SELECT *
- INTO dbo. Users_Staging.
- FROM dbo. Users;
- GO.
- /* Change some of their data randomly: */
- UPDATE dbo. Users_Staging.
- SET.
- Reputation = CASE WHEN Id % 2 = 0 THEN Reputation + 100 ELSE Reputation END,
- If you would like to change the default value then go to SSMS > Tools > Options:
- In the Options dialog box, highlight SQL Server Object Explorer and change the default values to any number as per your requirements.
The sudo apt-get update command is used to download package information from all configured sources. The sources often defined in the /etc/apt/sources.list file and other files located in /etc/apt/sources.list.d directory. So when you run update command, it downloads the package information from the Internet.
What is yum update command? ›yum is an interactive, rpm based, package manager. It can automatically perform system updates, including dependency analysis and obsolete processing based on "repository" metadata.
What does apt full upgrade do? ›apt-get upgrade only upgrades existing packages. It doesn't install new packages or remove existing packages. apt-get upgrade doesn't upgrade kernel version. dist-upgrade can remove dependency packages or install new ones (if required)
What is an UPDATE statement? ›In SQL, the UPDATE statement is used to modify or update existing records in a table. You can use it to update everything all at once, or you can specify a subset of records to modify using the WHERE clause. The UPDATE statement is considered a SQL data manipulation command.
What is the UPDATE method? ›
Definition and Usage. The update() method inserts the specified items to the dictionary. The specified items can be a dictionary, or an iterable object with key value pairs.
How do I UPDATE from command line? ›- Type cmd in the search box, choose Run as administrator, and click Yes to continue.
- Type wuauclt.exe /updatenow and hit Enter.
- This command will force Windows Update to check for updates and start downloading.
Syntax. The basic syntax of the UPDATE query with a WHERE clause is as follows − UPDATE table_name SET column1 = value1, column2 = value2...., columnN = valueN WHERE [condition]; You can combine N number of conditions using the AND or the OR operators.
What does database UPDATE mean? ›data update means any modification of the existing data, including its deletion or insertion of new or additional elements; Sample 1Sample 2Sample 3.
Why is updated data important? ›Clean, high quality data improves the accuracy of results therefore providing you with the tools you need to make better marketing decisions. If your customer data is correct you can make decisions in terms of content creation and campaigns targeted at data segments which are much more likely to give effective results.
Why is it important to UPDATE data? ›Updates can prevent security issues and improve compatibility and program features. Software updates are necessary to keep computers, mobile devices and tablets running smoothly -- and they may lower security vulnerabilities. Data breaches, hacks, cyber attacks and identity theft have all been in the news.
How do I update everything on my iPhone? ›Open the App Store. Tap your profile icon at the top of the screen. Scroll to see pending updates and release notes. Tap Update next to an app to update only that app, or tap Update All.
How do I fully update my iPhone? ›Go to Settings > General > Software Update. Tap Automatic Updates, then turn on Download iOS Updates. Turn on Install iOS Updates. Your device will automatically update to the latest version of iOS or iPadOS.
Can I force an update on my iPhone? ›Update iPhone manually
At any time, you can check for and install software updates. Go to Settings > General > Software Update. The screen shows the currently installed version of iOS and whether an update is available. To turn off automatic updates, go to Settings > General > Software Update > Automatic Updates.
Click References > Update Table. Note: Update Table becomes an option only when you click the table of figures in your document. You can also press F9 to update your table of figures. Select an Update in the in the Update Table of Figures dialog box.
Can views be updated or not? ›
You cannot update or insert into a view with Query-By-Forms. You can update, delete, or insert with SQL statements, but you must abide by the following rules, keeping in mind that an error occurs if you attempt an operation that is not permitted.
Can view be modified in SQL? ›A view can be updated with the CREATE OR REPLACE VIEW statement.