Query based on Cartesian query with date parameter not working.

Recur-NEW-2-22-2018.accdbGreetings Experts:

I'm having trouble making a query that is based on another Cartesian query.  
The query is named 1-testdue. It is used to query all events due within a parameter date range.
I can't get it to work correctly, looks like it's pulling Cartesian values for all records.
I need to pull only each instance of event that are due within a certain date range.
Please advise.
Thanks!
LVL 1
Gemini GVBA & Database ProgrammerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Bill PrewCommented:
You would want to share a bit more information, and the code of the queries involved, along with sample data.


»bp
0
Gemini GVBA  & Database ProgrammerAuthor Commented:
Sorry guess it didn't load first time
0
PatHartmanCommented:
The whole point of a Cartesian Product is to multiple the rows in tbl1 by the rows in tbl2 so EVERY row in tbl1 gets matched with every row in tbl2.  If tbl1 has 50 rows and tbl2 has 100 rows, the result set will be 50 * 100 = 5000 rows.

It would be more helpful if you tell us why you are using the Cartesian Product.  What real world function are you trying to model?
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Gustav BrockCIOCommented:
You have posted this or similar several times, but I guess no one understands what you are trying to do, not to mention why.

Your last date is 2127-01-01 so that will probably include any due date, and to find some due dates, you don't need to generate all dates between now and 2127.
Thus, it seams, you need to rethink your concept.
0
Gemini GVBA  & Database ProgrammerAuthor Commented:
The cartesian (or cross join query) in this instance is used to produce all recurring instances of an assigned event. If you look at the website http://allenbrowne.com/AppRecur.html this expert will show the reasoning why. Perhaps that will help you understand the concept and what I am trying to do.
0
Gustav BrockCIOCommented:
Oh, you miss the parameters.
Edit the SQL of the query to have this top line to proceed the Select statement:

PARAMETERS [Enter start] DateTime, [Enter end] DateTime;
SELECT ...

Open in new window

0
Gemini GVBA  & Database ProgrammerAuthor Commented:
My query already has those parameters in the query designer
0
Gustav BrockCIOCommented:
They were not present in the download.
When entered, the query worked as expected. See attached demo, please.
Recur.accdb
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Gemini GVBA  & Database ProgrammerAuthor Commented:
Thanks
0
Gemini GVBA  & Database ProgrammerAuthor Commented:
That worked Thanks!
0
Gustav BrockCIOCommented:
You are welcome!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Query Syntax

From novice to tech pro — start learning today.