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...
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...
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 =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.