Recent content by pbrydone

Anyone care to help??

Success at last!! Many thanks to everyone for their help (and patience). Can I be bold and ask for a little more help? I am planning on publishing the results of the query to a Report with BeginDate and EndDate. Also, the report will contain a status of where the person is; On Vacation, Sick...

Minty -This looks great. I think that I can work with this. Many thanks to everyone for helping. I'll give it a go and let you all know.

Perhaps you're smarter than me :D. Really, I have tried exactly as you have stated. A silly question (coming from me!). In the query that you have written, it looks like the dates are the other way around. EndDate is where BeginDate etc.

I'm sorry, I don't understanding what you are trying to imply by saying "Which leads me to, did you even (really) try this?". I'm asking for help and I think that comment is a bit offensive. And yes, I did try it and gave you the results. Consider your knowledge a blessing, not a weapon!

I'm afraid not. My default date settings are DD/mm/yyyy. If I enter the dates as you have provided, I don't get anything back.

Thank you. I'm having a bit of a slow Monday so please accept my apologies. Will this be in a query or in the actual report? Also, is there a way where the dates can be interactive?

Sorry folks. I was away from my computer for a couple of days. burrina - thank you for the sample database that you posted for me. Unfortunately, it interrogates only one date field. I have recreated my database on a stand alone that I' going to try and upload (if I can get it right!). You...

I'm afraid it's still not working for me. It must be me. Do you happen to have a sample database that I can download? I can relate better to examples. Thank you.

Where in the query would you suggest I put the string? I have BeginDate and EndDate or should I create a new field in the query?

Thanks guys but I fear that we are going around in circles with this one. Let me start again and I'll try to explain better. I have an Access 2007 database that is to be used for keeping track of people who are on vacation. I have two date fields [Begindate] and [EndDate]. These fields...

Tried it but it doesn't work. The date format for the system is set to dd/MM/yyyy. If this can't work then grateful for any other suggestions on how to create a new database that can do what I am looking for. I have looked around but can't find anything that would fill my needs. Thank you

01/07/2015. The date format is fine

They are both in Date format

Guys - thank you so much for taking an interest. I am attaching a Word document with screenshots from the database. Everything else works fine. It's just generating a report selecting dates between two different date fields that is causing me problems. Most Date Range forms / queries that I...