I'm not sure if this belongs here, but I wasnt sure where else to put it. I recently attached my personal laptop to our network which we have several policies in effect - one being custom shared folders like a Start Menu so that all users have the same menu on their computer. Something must have...
Whenever I have problems with Data types that I import from a text file, I just make a New field in my table with the correct format I want. Then I create an Update Query that updates the contents of the New Field with the data in the field I pulled from the text file. Once the Update is...
To Mikevh:
The >= Start Date and <= End date does not work because it would include messages with start dates that are ahead of the current date.
To godawgs:
I realize I cant use the >= Start and <=End for the very reason you explain. These are messages that would be entered ahead of time to...
OK, I posted this one before, but I dont think I was clear in what I was trying to do. I have a Message database and each message has a start date and end date. I would like to make a query that would display the appropiate messages for whatever the CURRENT date is. For example, one message...
The only problem with that code is that it would include 5/14/2002 on 5/13/2002 because the 14th falls between the 13th and 17th. I would not want the 14th to be displayed until it was the 14th. End dates could possibly be different also. One might have a one day difference while another might...
I am looking to create a query that would display information based on Start and End Dates. For example, one Start Date would be 5/13/2002 with an End Date of 5/17/2002. I would want that record displayed on 5/13/2002, but not after 5/17/2002. There could be another record in the table with a...
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.