Search results

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...

At the moment the database is standalone with no FE Be as yet

I'm afraid that I can't provide the database because its on a mainframe and we can't transfer anything in or out. The code is standard which is used in most Report Date Range forms that are available for download.

I am using the standard Report Date Range form but that only picks up dates when you have one date field. I'm having problems because I have two separate date fields in the table. I need the Report Date Range form to pick up dated between two separate fields.

:banghead: I am using Access 2007. I have a table dealing with vacations with FirstName, LastName, BeginDate and, EndDate. I would like to be able to run a report via a Report Date Range form which will allow me to check who all are on vacation between the BeginDate and the EndDate. I would...

Hello all I have been tasked with creating a database for a small medical clinic which will mainly be dealing with receiving an issuing drugs to patients. We would be looking at entering all of the drugs initially with their current stock balance. We would also be looking at seeing current...