Parameter query to show any records falling in on a date

I am sure that the use of EndMonth twice is a typo, however even allowing for that this does not answer the question asked and even if it the question asked had been to find where Startmonth = startparameter and endmonth = endparameter this method is an unnecessarily complicated one.

Brian
 
I am sure that the use of EndMonth twice is a typo, however even allowing for that this does not answer the question asked and even if it the question asked had been to find where Startmonth = startparameter and endmonth = endparameter this method is an unnecessarily complicated one.

Brian


Just thought I'll throw in the idea of using pattern matching. I am aware that it will throw up two input boxes, but it was just an idea since a solution had already been devised.
 
Hi Brian,
Thanks so much for putting your time into this!

In your Word doc, you said:

I originally tried to use your bloomtime subform so have probably messed that up, you can easily import the original from your DB, though I wonder why it has Combo boxes on it when Textboxes are all it needs.


The only reason I'd selected to use combo boxes is that I wanted a drop-down list for the user to select dates from, since I had the pseudo date formatted to month name; this way they wouldn't have to type in a specific date to have that flower appear in that particular month's report. I don't know how to do this any other way than use a combo box's row source SELECT DISTINCT function.



Otherwise, I'm just going to focus on building reports, so I'll let you know if I have anymore issues or questions.



Hope all is well with your wife, thanks again!
 
Hi Brian,
Thanks so much for putting your time into this!

Otherwise, I'm just going to focus on building reports, so I'll let you know if I have anymore issues or questions.

Hope all is well with your wife, thanks again!

She is OK thanks it is fairly frequent regular check as I mentioned to Paul, it just takes most of the day waiting around mainly. :(

Remember that were I run the queries you can just as easily run a report based on the query.

Build things in stages and don't expect an all singing dancing result from day1 and you will get there.

Brian
 

Users who are viewing this thread

Back
Top Bottom