Search results

  1. G

    Distinct Syntax

    Hi all, I'm having difficulty with the syntax in this query to remove duplicate data for the field "StocktransID". Any help is greatly appreciated. SELECT DISTINCT tblStockTrans.StockTransID, tblItem.Brand, tblItem.Category, tblItem.SubCategory, tblItem.Model, tblItem.Description...
  2. G

    Unbound Textbox Equals Listbox Column

    Hi, any reason why =listboxname.column(0) in the control source of a textbox will give me the value "#name?" ? I've used it successfully on another form..but for some reason its not working for me.
  3. G

    Populate listbox with sql like clause

    I am trying to populate a listbox through its rowsource but i'm not sure if my syntax is right for the like clause. Not showing any results: me.list.rowsource = "SELECT tblProducts.ProductID, tblProducts.ProductName, qryTotalProducts.Qty FROM tblProducts INNER JOIN qryTotalProducts ON...
Back
Top Bottom