Show results of no matches between two tables based on a date

Best Microsoft Access Programmer Portland OR

HI,

I have two tables, drivers and trips. I want to show which drivers are not used on a specific day on trips (based on a text box field on a form). I have a trip date field on trips to use for the comparison.

I don’t think i can do this with an unmatched query, and having trouble finding SQL i can use for this.

Any help is appreciated.

submitted by /u/mrkoss
[link] [comments]

Microsoft Acess Developer Portland ORRead More

Popup Switchboard is too large.

Best Microsoft Access Programmer Portland OR

Hey guys, I’m certain this is something simple, and my brains just not quite turned on this morning. I have a switchboard that is adding a large white space underneath the 3 options that I currently have. I would like this white space to not be there.

Here is what it looks like: https://imgur.com/a/BX5dVb8

Here are my format settings: https://imgur.com/a/RQkjTe2

submitted by /u/Kightsbridge
[link] [comments]

Microsoft Acess Developer Portland ORRead More

Savage Love: Coworker’s Boobs Zoom Into View

Best Microsoft Access Programmer Portland OR


by Dan Savage

1582309877-savage-letter-of-the-day-stamp-2020.jpg

Here’s a question for our coronavirus times that isn’t, “Can we hook up yet?” With my whole company working from home, I was recently in a small group Zoom meeting when one coworker, unaware that her camera was on, moved her phone/tablet/laptop and in the process panned across her bare chest. One of the other participants told her that her camera was on, and she immediately switched it off, with a lot of flustered apologies and oh-my-Gods. After a minute or

Read More

The Merc gets it wrong

Best Microsoft Access Programmer Portland OR

by Anonymous

The amateur film buff in me won’t let this opportunity go by to correct the Portland Mercury when you get it wrong. The Bradley Cooper/Lady Gaga remake of “A Star Is Born” is actually the fourth remake, not the third as you stated. The first (non-musical) version was the Janet Gaynor “A Star Is Born,” then the Judy Garland/James Mason version, then the Barbra Streisand/Kris Kristofferson version. It’s not hard, Merc — get it right!

[Thanks for the heads up, anonymous amateur Read More

Kickstand Comedy Finds New Solutions During COVID-19

Best Microsoft Access Programmer Portland OR

Kickstand Comedy Finds New Solutions During COVID-19
by Robert Ham

kickstandcomedy2.jpg
Chelsea Petrakis

The owners of every space where people gather have been refreshing their newsfeeds on the regular in recent weeks as the state slowly starts to reopen, wondering when and how they’ll be able to resume normal business. In this respect, Kickstand Comedy, the nonprofit theater that took over the Brody Theater downtown last year, is like every other concert hall, coffee shop, or bar: waiting patiently until they can safely throw open their doors and stage to comedy … Read More

Don’t Miss the Hilarious I, Anonymous Show—This Thursday!

Best Microsoft Access Programmer Portland OR


by Wm. Steven Humphrey

600x500_IANON.jpg

If you’re stuck inside and desperately needing some top notch comedy, then the I, Anonymous Show (Livestream Edition) is for you! Here’s how it works: We get the funniest local and national comedians to riff and heckle the wildest, jaw droppingly wrong, and uncensored I, Anonymous submissions from the famous Mercury column, and in return you laugh yer buttz off!

The last two editions of the I, Anonymous Show were wildly funny and entertaining, so you truly do not … Read More

Today’s Coronavirus News: Family Parties Cause COVID Spike, States that Reopened Too Soon, and Trump Golfs as People Die

Best Microsoft Access Programmer Portland OR


by Mercury Staff

As national death toll rises to 100,000, Trump tackles the problem by playing golf.
As national death toll rises to 100,000, Trump tackles the problem by playing golf. Leon Neal / Getty News

Here’s your daily roundup of all the local and national news about COVID-19. (Like our coverage? Please consider donating to the Mercury to keep it comin’!)

• According to the Oregon Health Authority, the state currently has 3,967 positive COVID-19 cases (that’s up almost 100 since Friday) and one additional death, for a total of 148. More than 98,000 (that we know … Read More

COVID-19 Forces Popina Swimwear to Close Pearl Store; Refocus on Hollywood Location

Best Microsoft Access Programmer Portland OR

COVID-19 Forces Popina Swimwear to Close Pearl Store; Refocus on Hollywood Location
by Wm. Steven Humphrey

image003.jpg
Popina Swimwear

Fans of fashionable, locally made bathing suits will be sad to learn that Popina Swimwear—which has been in operation for the last 14 years—has been forced to permanently shutter their Pearl location due to financial complications from the pandemic. On a brighter note, their Hollywood location will reopen this Thursday, May 28.

“We’ve made it through some hard times, and this challenge has no doubt been the hardest,” said Popina founder Lulu Levenson in a press release … Read More

Savage Lovecast: Kink and Race with the Mighty Blaksyn

Best Microsoft Access Programmer Portland OR

Savage Lovecast: Kink and Race with the Mighty Blaksyn
by Mercury Promotions

savagelovecast.jpg

A married couple in an open relationship previously enjoyed glory holes at play parties. Then along came some COVID-19. But did that stop them? Hell no! They grabbed the kids’ old sheets and made a home glory hole. Now THAT’S what I’m talking about, America!

A man’s mother died when he was 13, and his father quickly remarried. He found a letter revealing that his father and step-mother had been having an affair before his mother died. Now what? His dad … Read More

Page 5 of 666
1 3 4 5 6 7 666