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 SkipVought 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. 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 for your help. I need it to look at just the month and the date. This code will only pull people in the future. I need to know employees ready for a review. I need someone who was hired on 11/05/04 to show on the report. I truly appreciate your time.
  3. 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...
  4. misha8765

    Putting "today's date" in a criteria code

    Thank you for your help. I tried: Between #'date()' 8:00:00 AM# And #'date()' 5:00:00 PM# It doesn't work. Any other ideas?
  5. 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...
  6. 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...
  7. misha8765

    Sorting a date field in a query

    Thank you, Where exactly would I put this code. The format is datetime
  8. 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
  9. 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