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

    Hi guys, I have a query that req

    Hi guys, I have a query that requires distinct records returned. These records need to be ordered by how close their postcode is to a fixed value, hence: SELECT DISTINCT.....ORDER BY (ABS(3000-g.PostalCode)) (3000 is the fixed value - Aussie postcodes are generally 4 digits) I continue to...
  2. junket

    messenger not working in XP

    I have Messenger working in my administrators profile, but in all other profiles, clicking on the shortcut or the app file produce no results. I gave another user administrative abilities, but still they cannot get Messenger up and running. I'm guessing it has something to do with group...
  3. junket

    Custom Date format

    I am creating a web site in Australia for Australians, and require users to add their date of birth. Australian standard date format is d/m/y compared to US m/d/y. My site is hosted in the US, therefore the servers default settings are US and the access db looks at the regional setting for the...
  4. junket

    Security: User and Group Accounts

    I have only just started using Access 2002. While investigating the User and Group Account information, I have inadvertantly removed the "Admin" default user from the Admins group. I have created a new user "Administrator" in the Admins group, but cannot figure out where to...

Part and Inventory Search

Back
Top