Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Morgance

    Can I display the result of a query on a form with option field

    Yes. Put an object frame around the radio buttons and Name it the same as your Query field name. For instance Voided is a column in a query selected off a table. The radio button frame is named Voided. The individual radio buttons have optionvalues of 1,2,3... Morgance
  2. Morgance

    SQL Problem with Grouping and Left/Right-Joins

    SELECT tblSales.OrderNumber, tblSales.CreationDate, tblSalesParts.TrackingNumber, tblSalesParts.releasedate, tblSalesParts.ReleasedTo, tblBuilds.BuildCode, tblSalesParts.TrackingNumber, tblBuilds.Location, tblBuilds.BuildDate, tblBuilds.Built, Max(tblSalesContact.ContactDate) AS...
  3. Morgance

    Append Query behaves erratic

    Sounds like a join problem. If the record already exists, it will append 1 record for every match it found. If it doesnt exist works fine, adds 1. If it already exists, you'll get 1X1, then 1X2, then 1X4, follow??? If you want all records added regarless of if it already exists, just append...
  4. Morgance

    Run Time Error '2001'

    I recommend putting msgbox("line1") or some variation after each line to see which exact line is blowing it up. Morgance
  5. Morgance

    Linked Table Location

    Click on it, always prompt for a new location, ok, and it will pop up the spot in the network where it is located. Hit the up button a few times till you figure out where you are. Morgance
  6. Morgance

    Sub Totals on Data Report!

    If you have which product category it belongs to in a table, for instance: tblProduct Product ProductType Apple Fruit Pear Fruit Lettuce Veggie You can recreate a query to Output it that way by doing the following 2 queries. I created this on the fly, so there may be a faster way. Query...

Part and Inventory Search

Back
Top