Re: [MS_AccessPros] Fitler out split accounts in a query

 

Jim,

What does your data look like? How are you storing the split accounts? I assume these are multiple records in an Employee Splits table.

When you say "show one of the records", which one? Do you always want to show the highest split? What if it's 50/50?

Can you provide some sample records and desired display?

Duane

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Tuesday, April 24, 2018 4:08 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Fitler out split accounts in a query

 

Hello all,

I have a table with employees that are paid from split accounts on some of them. I would like to get a query result that does not show one of the accounts.

some have 70%/30% or 75%/25%. How do I filter out records to only show one of the records?

Thank You So Much for your help.

Jim Wagner

__._,_.___

---

Posted by: Duane Hookom <duanehookom@hotmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___