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 TouchToneTommy 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: WillRiley
  • Content: Threads
  • Order by date
  1. WillRiley

    Selecting only the maximum values

    Hi, I have a table with multiple records for each ID. The records all have an effective date & I wish to return only the 75 or so records out of 20,000 that are the most recent for each id... i.e. for each ID, return the record corresponding to the maximum effective date... In access, I...
  2. WillRiley

    Select Case or some such If type statement

    Hi people, I have the following poser that I could do with some help on. I am trying to match the average balance of an account with a set of "levels" that determine what rate of interest is to be applied to the said account. Trouble I am having is that of the 7 levels, not all of them are...
  3. WillRiley

    Fields not showing Portrait -> Landscape

    My first post for some time.... This is a frustrating little problem... I created a report in with an original page set-up of Portrait, then later changed it to landscape in order to make it look better; however the fields that I have placed in the additional page width given by Landscape do...
  4. WillRiley

    Select Distinct Records

    Please can anyone help me with this one... hopefully an easy one for some of you... My table contains a number of records for the field "groupid" (i.e. a new recod with the same groupid is created whenever one of the other fields gets updated) I am querying a table and want to select...

Part and Inventory Search

Back
Top