Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2012

    Return rows where value equals drop down

    I have an Access front page where there is a drop down for month, the SQL code is run once the drop down has been selected and a button is pressed. I need to select rows where values in "month" match this value.

    I am new to Access and am going round in circles. The table the drop down is stored in is Months_t and the rows I need returned are in Gamma_t.

    I have written the code

    strSQL = "SELECT Gamma_t.Page, Gamma_t.Address, Gamma_t.District, Slides_t.Metric, Gamma_t.[Output] " & _
    "From Gamma_t WHERE (((Gamma_t.[Output])=True))) "

    and am looking for an amendment to include the drop down variable.

    Many thanks for any light anyone can shed.

  2. #2
    RuralGuy's Avatar
    RuralGuy is online now Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    8300' in the Colorado Rocky Mountains
    What is this entry in your Select string "Slides_t.Metric"? I thought the table was named "Gamma_t"
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 8
    Last Post: 03-18-2012, 11:17 AM
  2. Is the Access 'Equals' operator broken?
    By AccessPonderer in forum Queries
    Replies: 0
    Last Post: 03-18-2011, 09:00 AM
  3. Replies: 11
    Last Post: 09-02-2010, 01:59 PM
  4. Replies: 3
    Last Post: 08-17-2010, 02:49 PM
  5. Replies: 1
    Last Post: 05-29-2008, 04:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums - Senior Forums