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

    Highest Value in Record

    I have a table with 3 date fields. At least one of them is always filled in, sometimes all of them. In a query, I need to return the single highest value of these fields for each record. Does anyone have any idea how I can do this? It is starting to hurt my brain. Many thanks, James
  2. james2308

    advice required, if possible

    I am not sure if this is the correct forum for this, but i was wondering how much i should expect to pay for a simple access db. I just want a customer one, shoowing what was ordered at each visit, how much each cutsomer spend, when they visited etc. Then reports could be done on how much is...
  3. james2308

    I think I might be going insane.........

    ...well, being driven insane, anyway: I have 2 databases, one on an networked drive shared by my department (P:\), and one on an networked drive shared by the whole company (S:\). In my P Drive Database I have queries which will accept the Date() function, whereas the S Drive Database will...

Part and Inventory Search

Back
Top