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 Rhinorhino 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 Digitalcandy02

  1. Digitalcandy02

    How to change date to text CR8.5?

    Sorry for the confusion but that is what I did. I didn't mean to write my code as M/dd/yy. I am actually using M/d/yy. However, it seems to create an empty space in day section when it is less than day 10. For instance; date field = 2/5/04 ToText date field = 2/ 5/04 I need it to be a text...
  2. Digitalcandy02

    Profiles problem.... Some Win98 users settings won't save.

    I've took over the Systems Admin posistion at my current company. I have some Win98 machines to deal with. One of the basic things I want to do is redirect the "My Documents" folder on all of my clients. The Win2K and XP machines are no problem with GPOs. However, I have to...
  3. Digitalcandy02

    Exists question

    I am making a view and want to make a column that returns a boolean. The column will check for a record in another table, if it exists then true else false. This is what I have and ofcourse it doesn't work but the linking is correct. (Select Top 1 LotID From TravelerLot Where LotID =...
  4. Digitalcandy02

    How to get previous Sundays date? CR8.5

    Perfect! Thank you.
  5. Digitalcandy02

    How to get previous Sundays date? CR8.5

    I would like to get the previous Sunday date for any given date field. Can anyone help out with the formula? Thanks
See more

Part and Inventory Search

Back
Top