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 Shaun E 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: *

  • Users: misha8765
  • Content: Threads
  • Order by date
  1. misha8765

    Using Dateadd to find a due date

    Thank you in advance for your time. I have a field called "Hiredate" Three months after the employees hire date they are off probation. Based on the hiredate field, I want to run a report showing me who completes their probation within the next week. Any ideas? Thank you!
  2. misha8765

    Using Date Add Function to find records

    Thank you in advance for your time. I want to run a report which shows me all employees due for an evaluation in the next month. Field: hiredate data example: 10/30/06 I'm looking for all dates (Month and day only) between now and one month from now. I have been working with the dateadd...
  3. misha8765

    Putting "today's date" in a criteria code

    Thank you in advance for your time. I have a date field that states information as such: 10/30/2006 10:00:00 AM Every morning I am looking to pull today's appointments. The following code works, but I have to change the dates every morning: Between #10/30/2006 8:00:00 AM# And #10/30/2006...
  4. misha8765

    Parameter for a date field?

    Thank you in advance for your help. I have the following statement in the criteria of the date and time field in a query: Between #5/12/2006 8:00:00 AM# And #5/12/2006 5:00:00 PM# How can I add a parameter into this expression so I can simply type in the date and not the time to and get a...
  5. misha8765

    Sorting a date field in a query

    Thank you in advance for your help. I have a date field 99/99/00 When I sort ascending in a query, it sorts the year first. I want it to sort by month then day. Any idea? Thank you
  6. misha8765

    How to pull birthdays for a given date range

    Thank you in advance for your help. In a query, I want to pull all employees who have a birthday in May. Our date field is 99/99/00 I don't care about the year and I don't know the birth year in advance. I just want to know all birthday's for each month. Any idea how I can write the code in...

Part and Inventory Search

Back
Top