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

 

Duane,

Thank You, that was the answer. I do not know why I did not think of that.

Jim Wagner

---

On ‎Tuesday‎, ‎April‎ ‎24‎, ‎2018‎ ‎04‎:‎17‎:‎09‎ ‎PM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

 

Jim,

From what fields you have shown us, I can only suggest a simple totals query:

SELECT [Pos Nbr], Max([Dist Pct]) as DistPct

FROM [It Looks Like This]

GROUP BY [Pos Nbr];

If you want/need more information, you should provide more information.

Regards,

Duane

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Tuesday, April 24, 2018 5:05 PM
To: Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals]
Subject: Re: [MS_AccessPros] Fitler out split accounts in a query

 

Duane,

it looks like this

pos nbr        Dist Pct

111111            100?

222222            100%

333333            75%

333333            25%

444444            70%

444444            30%

My boss does not care which record is showing. 50/50 does not matter either. the highest would be good.. It does need to be in the query though. She is trying to make things easier for her. She takes a table and puts it in excel and then does all of the polishing and pruning the way she likes it. But she is tired of doing all of the work and asked if I could make it more automatic. She does a number of steps to get the look she wants

Here are her steps below

1. delete 2 specific columns
2. sort by title
3. Filter out students
4. filter out certain position numbers
5. add conditional formatting
6. delete more columns
7. change the order of the columns
8. copy data to excel.

But a query can do this easier. I figured I would put it in a continuous form to add the conditional formatting after getting the data.

Jim Wagner

---

On ‎Tuesday‎, ‎April‎ ‎24‎, ‎2018‎ ‎02‎:‎49‎:‎49‎ ‎PM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

 

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: Jim Wagner <luvmymelody@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (5)

---

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

.

__,_._,___