Recent content by Crevalle

I have to find the number of weekdays between two dates (to the second decimal). For example, if a ticket is opened at 3pm on Friday, and closed at 4pm on Tuesday, I want to exclude the weekend in the day count and have a result similar to 2.04 days. I WAS using this formula (which includes...

M8KWR--I appreciate the detailed recommendation, but I think you've eclipsed my knowledge of Access. I have no experience with forms, or SQL. Is there any method more straight-forward or less complex?

I have a report that utilizes an underlying query that prompts for a date range (one prompt asks for the beginning date, the next asks for the ending date--format is: "08/15/2004"). The report displays data for whatever date range the user enters. However, I would like to display, at the top...

FWIW, this is the formula I use to convert the original text-formatted dates into actual dates. This formula creates the dates I am trying to query against. The dates were originally in text format like this: 2004-07-23-07.53.28.625619 CDate(Month(Left([TCR_R_INQ_STATUS]![UPDATE_DATE],10)) &...

SkipVought--I got an error message (after I entered the dates in the prompts) that read: The expression is typed incorrectly, or is too complex to be evaluated. For example, a numberic expression may contain too many complicated elements. Try simplifying the expression by assigning parts of...

I have a table with dates in the format of "8/1/2004 16:56:21 PM" and I am having great difficulty simply running a "between" dates query. Initially, I had it set up as: between [enter beginning date] and [enter end date]. This skips some records. If I manually put ">=#8/1/2004# and...

Thanks CosmoKramer--Worked like a charm!

BTW--I mis-typed. I meant the data would return 08/01/2004 though 09/14/2004, not 08/14/2004. I'll keep checking back for a response. Thanks!

Looks like my problem lies in the fact that my dates have times associated. So, my query is searching for records UP TO 09/14/2004 @ 12:00am. Can anyone recommend a way around this?

Hate to be a pest, but can you recommend a method to eliminate the time from the query criteria? Or point me in the right direction? Thanks!

Dolfan1873--that's exactly what doesn't work. That's what I mean. It SHOULD work, but it doesn't. So, I'm looking for a work-around. If I put "between [enter beg date] and [enter end date]" it will not pull back the end date, but everything before it. In other words, if the user input...

FWIW--The standard "between [enter beg date] and [enter end date] brings back all dates EXCEPT the current date. For example, if I put 8/1/2004 to 9/14/2004, it will pull back all date from 8/1/2004 to 8/13/2004. When I use the >=/<=, it does the same thing. However, if I put 8/1/2004 to...

FWIW--The standard "between [enter beg date] and [enter end date] brings back all dates EXCEPT the current date. For example, if I put 8/1/2004 to 9/14/2004, it will pull back all date from 8/1/2004 to 8/13/2004. When I use the >=/<=, it does the same thing. However, if I put 8/1/2004 to...

I have dates in the format of "8/2/2004 10:51 PM" in my tables. I would simply like to allow the user to input two dates, and be able to pull all records within the date range. Here's the odd thing: using "Between [enter beg date] and [enter end date]" does not work. For some reason, it works...

I have dates in the format of "8/2/2004 10:51 PM" in my tables. I would simply like to allow the user to input two dates, and be able to pull all records within the date range. Here's the odd thing: using "Between [enter beg date] and [enter end date]" does not work. For some reason, it works...