Vb.net query access database table with 2 conditions on the same field

Vb.net query access database table with 2 conditions on the same field

Short background information;

Short background information;

I receive notification emails with an alphanumeric number, a status field, the email receiving time and the sender name.

I have a database which I populated with these outlook emails. E.g.:

Number            status     receivingtime           sender
Xyz12345          new        22.01.2019 20:22:16     abc
Xyz5683           new        23.01.2019 15:45:55     abc
Xyz12345          closed     23.01.2019 14:32:30     abc
Xyz8765           new        24.01.2019 16:55:32     abc
Xyz9999           closed     2t.01.2019 09:10:11     abc

I need a query (number,status,time,sender) which extracts only the new items if they where not already set to status closed.

In the above given example the extracted data should be xyz5683 and xyz8765 I tried already doing this with for loops which I don't really like as the performance is bad.

I also tried this with populating 2 datatables and joining them together, used except within linq. Due to the fact that I like to store it anywhere for further use I also skipped this method. I would prefer

1.) importing all the emails to the access db

2.) Query them as needed

I read tons of articles with different solutions, but can't figure out how to do this....maybe I already got stuck because I'm thinking way too difficult.

Do you have any ideas how I can do this?

Angular 9 Tutorial: Learn to Build a CRUD Angular App Quickly

What's new in Bootstrap 5 and when Bootstrap 5 release date?

Brave, Chrome, Firefox, Opera or Edge: Which is Better and Faster?

How to Build Progressive Web Apps (PWA) using Angular 9

What is new features in Javascript ES2020 ECMAScript 2020

VB.Net Save button not adding data to text file

I'm still new to VB.Net and have been stuck on this for a little over an hour. I'm trying to create an inventory management system where a form opens up for the user to enter pc specs and when I click save will save to the text file, so that it is read into the Inventory Tracker screen. Where each text box is disabled and appends the text as it is updated.

How to make a Windows Service from .Net Core 3.0

NET Core 3.0, it's a lot easier to create Windows Services: just a single line of code ... If the application runs on a Windows system, the method ..

array that changes length at runtime in vb.net

In vb.net, how can i declare a array without mentioning size? and it changes the size as the input comes?