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 Chris Miller 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: *

  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

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

Part and Inventory Search

Back
Top