UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
2 Pages V < 1 2  (Go to first unread post)
   Reply to this topicStart new topic
> Query To Find Overlapping Date Entries, Access 2010    
 
   
theDBguy
post Nov 29 2017, 10:03 PM
Post#21


Access Wiki and Forums Moderator
Posts: 71,199
Joined: 19-June 07
From: SunnySandyEggo


Hi Brandi,

Unfortunately, what you posted had a linked table. Can you try again with a local table? Thanks.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 
MadPiet
post Nov 29 2017, 10:09 PM
Post#22



Posts: 2,252
Joined: 27-February 09



Ha! Got it!! =)
(well, it returns the right answer... add another trial with a few overlaps and see if it still works!)
Attached File(s)
Attached File  TrialStatsOverlappingDates.zip ( 1.48MB )Number of downloads: 1
 
Go to the top of the page
 
MadPiet
post Nov 29 2017, 10:10 PM
Post#23



Posts: 2,252
Joined: 27-February 09



DBGuy,

I rebuilt the local table from the info provided... it's in my file. I think my queries work...

(When I stop being excited when a wonky query works, it'll be time to quit this racket, for sure!)
Go to the top of the page
 
theDBguy
post Nov 29 2017, 10:42 PM
Post#24


Access Wiki and Forums Moderator
Posts: 71,199
Joined: 19-June 07
From: SunnySandyEggo


Hi Mad,

Thanks. Here's my take based on my previous article on A Practical Use Of A Cartesian Query

Hope it helps...
Attached File(s)
Attached File  TrialStatsOverlappingDates_theDBguy.zip ( 59.08K )Number of downloads: 2
 

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 
Brandi
post Nov 30 2017, 11:04 AM
Post#25



Posts: 1,565
Joined: 24-June 04



New attachment with local table.
Attached File(s)
Attached File  TrialStatsOverlappingDates.zip ( 1.52MB )Number of downloads: 1
 
Go to the top of the page
 
MadPiet
post Nov 30 2017, 01:27 PM
Post#26



Posts: 2,252
Joined: 27-February 09



DBGuy,

That's funny, because that's what I eventually ended up doing. Jeff Moden has a great article on SQL Server Central on tally/numbers tables. Super handy once you get your head around using them!
Go to the top of the page
 
theDBguy
post Nov 30 2017, 01:46 PM
Post#27


Access Wiki and Forums Moderator
Posts: 71,199
Joined: 19-June 07
From: SunnySandyEggo


Hi Mad,

I can't disagree! thumbup.gif

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 
MadPiet
post Nov 30 2017, 01:59 PM
Post#28



Posts: 2,252
Joined: 27-February 09



The hard part about going back and forth between Access and SQL Server is the way each handles parameters and variables. SQL Server makes sense... Access not so much!
Go to the top of the page
 
2 Pages V < 1 2


Custom Search
RSSSearch   Top   Lo-Fi    11th December 2017 - 12:10 PM