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!

Register Log in
  • Congratulations John Tel 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: *

  • Users: mbrichmo
  • Content: Threads
  • Order by date
  1. mbrichmo

    How to hide Shortcuts in Shutter Bar/Navigation Pane in VBA

    Hi, Does anyone know how to hide a shortcut from the shutter bar with VBA?
  2. mbrichmo

    Transforming field values to new boolean fields in a query

    Hi, I would like to transform via a select query a table of the form: PatientMeds(PatientID,Med) to the form: TransformedPatientMeds(PatientID,Med1,Med2,...Med_n) I know the names of the specific Meds and can specify them explicitly. After the transformation I would add criteria for example...
  3. mbrichmo

    Find data associated with most recent record

    I would like to know how to get the data associated with the most recent record for each value of a given field i.e.: Orders(OrderID, OrderDate, Customer, Item) Find the most recent order for each customer and return the item for that order. Thanks!

Part and Inventory Search

Back
Top