Date range

[lk2827]

Hi

I have a query that has date field, days field and a calculated field based on the days field.

E.g

Date: 01/01/08
Days +7 (this can change)
Calculated: 08/01/08.


I need to be able to put in a parameter for the start date (01/01/08 and end date (20/01/08). This should only show the dates between what I have entered in the parameter which is in the brackets above.

Please could some one help me where im going worng.

All I keep getting is blank fields in the query instead of the dates between what I have entered in the brackets above.

Thanks

LK2827

 

[Brianwarnock]

I've just answered this for another poster, guess we have been helping students with their course work.
Brian

 

[boblarson]

I've just answered this for another poster, guess we have been helping students with their course work.
Brian

And does nobody know how to use a search facility anymore?

 

[lk2827]

what post is that then please

 

[boblarson]

I copied this part of your post:

Date: 01/01/08

into the search and it brought things up. A little effort would be appreciated.

 

[lk2827]

Hi Bob,
inst a search facility based on a forms text box?. The result I need is only in a query based on what is already in the query? I just want to filter out results in the query based on the parameters inputed

 

[boblarson]

What I was saying was

This forum has a search feature (top of the page labeled SEARCH). I plugged part of your question in to it to search the answers here and came up with the exact post that Brian was referring to.

 

[lk2827]

Sorry for not explaining my query correctly I cant see where im going worng

 

[lk2827]

I have a query which has a manually inputted date eg 01/01/08 to 01/03/08. In the query I want to filter out all the dates outside of that date range eg 01/04/08 should not be displayed. I only need 01/01/08 to 01/03/08 displayed within the same query. I am trying to do this by using parameter in the query eg first date 01/01/08 end date 01/03/08. but it keeps coming up blank? could you help me on where im going worng.

 

[boblarson]

What is the SQL statement of the query?

 

[lk2827]

there inst an SQL statement, is that where im going wrong.

All I have is a date field which is manually inputted into e.g 01/01/08
A days field which will have e.g +7
And a calculated field based on the above e.g 08/01/08.

Out of the above I want to filter out dates which are not within my start and end date range within the query. e.g if i input start date 01/01/08 end date 02/02/08. I should only see the dates between these and not 01/04/08 or a blank query?

I have attached a quick example of what I mean in the below post

 

[lk2827]

Here it is

 

[raskew]

Aahhhh!

Click here http://www.access-programmers.co.uk/forums/showthread.php?t=150698 and read.

Bob

 

[lk2827]

Hi

Read this and it doesnt work?

I have also tried like [find records beginning with:] &"*" Or Is Null.
but this keeps coming up blank aswell?

Any Ideas.

 

[boblarson]

Well, not sure why it isn't working in the query but using a form it works fine (see attached).

 

[lk2827]

Hi Bob,

Thanks for replying. I have also done this and tried it in a form as I didnt know why it was not working either. When I try it in a form or even in the query now I find that it will only work if you put in a big date range.

Even using your attached sample form it will not work. Try putting in the start date of 08/01/2008 and the end date of 20/01/08. this should display only one result but it does not display any results its blank.

This is my problem with the query or form what ever I use.

 

[boblarson]

Hi Bob,

Thanks for replying. I have also done this and tried it in a form as I didnt know why it was not working either. When I try it in a form or even in the query now I find that it will only work if you put in a big date range.

Even using your attached sample form it will not work. Try putting in the start date of 08/01/2008 and the end date of 20/01/08. this should display only one result but it does not display any results its blank.

This is my problem with the query or form what ever I use.

It works if I put in 01/08/2008 and 01/20/2008 - I think you are running into the issue where you will have to convert your input into U.S. format for the query.

 

[georgedwilkinson]

I don't understand non-US date formats but it is probably your problem.

Access is probably interpreting 8/1/2008 as September 1, 2008 and 20/01/08 as January 20, 2008. Since there are no dates between those two, you would not get records.

 

[boblarson]

Access is probably interpreting 8/1/2008 as September 1, 2008 .

If it is I think we're ALL in trouble since month 8 is August

 

[georgedwilkinson]

I guess it would be. Thanks (again) for correcting me.

The principle is the same, however.