LinkBack URL
About LinkBacks
Hi
I Have a Tble in Access , I want to show only Alis and Ebra in the query (only Ebra and Alis)
Thanks
I put a sample file
Hi
I Have a Tble in Access , I want to show only Alis and Ebra in the query (only Ebra and Alis)
Thanks
I put a sample file
Here is your SQL statement
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
THANK
If I want WORK to show equals, that is, ID one and three ONLY(CRITERA EQUAL WORK)
Last edited by AliGW; 07-24-2024 at 02:05 AM. Reason: Please don't quote unnecessarily - use the Quick Reply button instead.
Perhaps,
Please Login or Register to view this content.
no. i want equal criteria in field show me. There are many rows
Last edited by AliGW; 08-06-2024 at 02:35 AM. Reason: Please don't quote unnecessarily - use the Quick Reply button instead.
Maybe this
OrPlease Login or Register to view this content.
OrPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by mike7952; 07-24-2024 at 10:25 AM.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
for creteria 1 , code is ok , but i want to show work equal. then creteria 2 for work equal.what is code for that?
thank
<I WANT SHOW ME RESULT QUERY all LastName that: 1.(FIRST NAME IS ALIS OR EBRA) 2.(WorkCode IS EQUAL). RESULT=3 ROW WITH ID 1,6,7>
Last edited by AliGW; 08-06-2024 at 02:35 AM. Reason: Please don't quote unnecessarily - use the Quick Reply button instead.
Work equal to what? your database doesnt have a work field?
added in attachment fileOriginally Posted by mike7952
You don't even have 7 records in your database. Maybe someone else can help you
I WANT SHOW ME RESULT QUERY all LastName that: 1.(FIRST NAME IS ALIS OR EBRA) 2.(WorkCode IS EQUAL). RESULT=3 ROW WITH ID 1,6,7
in workCode field data is equal togheder to show
Try this,
Please Login or Register to view this content.
ok .this codr is true and show result,
I UPLOAD FILE
I want RESULT TO SAME EXEL RESUL IN query
Line NumberS that have 1. Support NO start by "S48, S52S",2.HAVE equal joint
Last edited by AliGW; 08-06-2024 at 02:36 AM. Reason: Please don't quote unnecessarily - use the Quick Reply button instead.
Hi
Can Someone Answer This Subject?
Hi
Can Someone Answer This Subject?
Why? You have marked it as SOLVED. Please remove the tag if you want help.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
ok. I do
thanks
Thanks.
Your data is a bit confusing.Maybe, you can try this.
Please Login or Register to view this content.
ok it is true
very thanks
Last edited by AliGW; 08-06-2024 at 02:34 AM. Reason: Please don't quote unnecessarily - use the Quick Reply button instead.
You are welcome.
-----------------------------------
If that takes care of your original question, please click on "Thread Tools" from the menu link above and mark this thread as SOLVED.
ok
Of course
Last edited by AliGW; 08-06-2024 at 02:35 AM. Reason: Please don't quote unnecessarily - use the Quick Reply button instead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks