Database & Application Miscellaneous: YASQQLQ- Yet another SQL query question

• samirnagheenanajar / 104 / Tues, 26 Jan 2010 01:28:00 GMT / Comments (5)
• Im working in access 2003. Ill just start with the query, im trying to populate a combobox with:
  SELECT DISTINCT [Feeder Property Values].value FROM [Feeder Property Values] WHERE ([Feeder Property Values].[feeder property key]=3 And ([Feeder Property Values].value Like (ComboState.Value) & '.%'))
  
  this works when I dont include the part after the AND. when I include the part after AND i get nothing.
  
  [Feeder Property Values].value looks like this: UT.GGR.CKB.GGR17.ZKVA
  
  and ComboState is a combo box with two letter state abbreviatsions (UT, CA, ID, etc).
  
  Im trying to narrow the query down to just [Feeder Property Values].value that begin with the two letters currently selected in ComboState.
  
  Any thoughts.
• Keywords:

  yasqqlq-, sql, query, database, application

• http://database.itags.org/database-application/158041/«« Last Thread - Next Thread »»

• 1. There should not be a .value after the field names. Is this being done inside Access or from an application outside the database and bing passed in?

     garymazzone | Wed, 05 Dec 2007 19:35:00 GMT |

  2. its being done inside access. im setting the rowsource to the above query. I just tried it with out the .value after the field name and got the same result. thanks for the speedy response. any other thoughts.

     samirnagheenanajar | Wed, 05 Dec 2007 19:36:00 GMT |

  3. If inside access then the wildcard is * and not %

     garymazzone | Wed, 05 Dec 2007 19:37:00 GMT |

  4. that did it. thanks.

     samirnagheenanajar | Wed, 05 Dec 2007 19:38:00 GMT |

  5. Your welcome. If this resolves the issue could you please use the thread tools above and mark this thread as resolved.

     garymazzone | Wed, 05 Dec 2007 19:39:00 GMT |