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!

Recent content by LeeEck

  1. LeeEck

    Create new records using parts of existing data

    Hi, The problem I have is this, I have some data that consists of date, time, Username, Login/Out(which happen to all be LogIn marked with an I), and a Machine code for the machine they have logged into as part of a University project I am doing. I want to some how create new records which show...
  2. LeeEck

    Day of week given the date

    Thanks for the reply, I have just found the a slightly different answer on someone elses previously asked question which said to do this: ShowOnDay:Format([Date],"dddd") Where the date is a list of the days that I need to run the query on and this works giving me the day for every...
  3. LeeEck

    Day of week given the date

    Hi Im trying to find a way of for a large set of dates in a table, some way of giving the day of the week for each given date because later I will need to run queries that work off the day of the Week so for example for all the dates that are a thursday a certain query can be run just on the...
See more

Part and Inventory Search

Back
Top