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 Chriss 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. KayJen

    Need date to change at start of a new year.

    Thanks will give it a try. Sonny
  2. KayJen

    Need date to change at start of a new year.

    Jerome tried yours, got the year but not the month and day. jimbOne, I enter this date into the field. 01/12/03, now we are in January 2004 I would like the year to now reflect 04, so it would now read 01/12/04. I'm just trying to prevent from having to enter the new year for 30 or more...
  3. KayJen

    Need date to change at start of a new year.

    The field is a Date/Time field. When there is a new hire their date of hire is entered into the Date Field. A year from that date an evaluation is due, we are a 24hr., 7 days a week police department, so weekends and holidays do not matter. I want to build a report, so that in the last week...
  4. KayJen

    Need date to change at start of a new year.

    I have a database to track employee evaluations on a year to year basis. The month and day are always the same, however, the year changes, or should hence this is where the problem lies. For instance in December 2003, I would like to send out a letter to all supervisors stating what...
  5. KayJen

    Two diffferent items in On Current, but How?

    Worked Great! Thanks, Sonny
  6. KayJen

    Two diffferent items in On Current, but How?

    I have a form that I am using and in the On Current Event I have it looking for and loading any photographs as the example shows below. I'm also trying to make a command button visible if a certain criteria is met. Is it possible to load more than one event in the On Current portion. Any help...
  7. KayJen

    Birthdate and Null Equals Error

    Mark, Sorry for the late reply, but, we are having our office roof re-done, so we've lost power. I am using my laptop and just tried your suggestion and it works fine, thank you. Thanks, Sonny
  8. KayJen

    Birthdate and Null Equals Error

    Mark, Tried, your suggestion, still receiving #Error. Thanks, Sonny
  9. KayJen

    Birthdate and Null Equals Error

    Hi, I have a field labeled BirthDate on a Form labeled frm_Clients. Next to the Birthdate field is an unbound boxed labeled Age with the following in the Control Source: =Age([BirthDate]). Now to my problem. I also have and unbound box titled: Status, with the following in the Control Source...
  10. KayJen

    Past Help almost working, Just a little most assistance

    I think my example is not clear, what I'm looking for is Assembly St and Elmwood Ave = 5 or it could say Elmwood Ave and Assembly St = 5 The chart will show something like below: Assembly St & Elmwood Ave ------------ 5 Park St & Main St -------------------- 4 Elmwood Ave & Sumter St...
  11. KayJen

    Past Help almost working, Just a little most assistance

    I am working on an accident program where the streets can be entered as A and B or as B and A, (beyond my control comes from accident investigators), I have the query working up to this point to count them, however, they are now listed twice, please help one more time with this ever present...
  12. KayJen

    Can A+B also count B+A as one

    KornGeek I am not currently at work but I will give this solution a try, Thanks for replying... Sonny
  13. KayJen

    Can A+B also count B+A as one

    I've tried UNION and the results are the same, the data is in there more than once if and only if there has been more than one accident at that location within the given month, other than that the data is different. I will keep playing with your query as your solution is the closest I have ever...
  14. KayJen

    Can A+B also count B+A as one

    Narrow removed all until I have the below query, but still showing duplicates, all other eliminations seems to create problems. SELECT [BaseStreet] AS street1, [TowardStreet] AS street2, [Date], [MidBlock] FROM accidents; UNION ALL select TowardStreet, BaseStreet, Date, MidBlock from accidents...
  15. KayJen

    Can A+B also count B+A as one

    I've figure out the date portion and the query works as you described which again I greatly appreciate, however, if repeats twice, the numbers are accurate though. Main St and Center St now says 5 as does Center St and Main St Is there a way to remove the second occurance, any additional...
  16. KayJen

    Can A+B also count B+A as one

    Thank you so very much this seems to be the solution I have developed a headache over searching for. Is there a way to add the date field from my table accidents so that I can narrow the search by months and quarters. Again, Thank You. Sonny
  17. KayJen

    Can A+B also count B+A as one

    Can I use a query to count how many times a set of streets appear in a database. Main Street and Center Street = 4 Center Street and Main Street = 1 These are the same so I would like the count to be 5, but I can't get this to work. My Table is Accidents with the below fields BaseStreet...
  18. KayJen

    Query Results Come Up Short

    Thanks I will start working on the angle. Sonny
  19. KayJen

    Query Results Come Up Short

    I am working on an Accident Collision Program, which requires tracking accidents that occur in an intersection as well as those that occur between two streets in other words Mid Block Accidents. I have three streets, Base Street, Collision Street and Toward Street when I run a query to count...
  20. KayJen

    Four Combo Boxes to One Unbound Text Box

    Thanks for the quick reply this appears to be exactly what I need.

Part and Inventory Search

Back
Top