Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

if function in access, any easier way?


(!)

OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,608 posts.
 
Join Date: Mar 2005
Location: UK
16-Feb-2012, 10:36 AM #16
One to One requires 2 Key Id fields and they can't be anything else, One to Many requires A key ID (1) to a number type lone (Many).
I will take a look at the latest version, what column needs to be ""havent done coaching""?
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,608 posts.
 
Join Date: Mar 2005
Location: UK
16-Feb-2012, 11:04 AM #17
The iif does not like the use of the or function and for some reason it doesn't like the mixed columns either, I might be able to find the correct syntax for them, but in the mean time here is a work around splitting them in to 2 columns and then working with the columns.
Attached Files
File Type: zip send v 0.0.zip (440.3 KB, 6 views)
__________________
OBP
I do not give up easily
Jayabhadra's Avatar
Jayabhadra Jayabhadra is offline
Member with 52 posts.
THREAD STARTER
 
Join Date: Feb 2012
Experience: Familiar
16-Feb-2012, 08:13 PM #18
sorry for late reply, last night already too late. "havent done coaching" is in "status" field.

I tried to download and open but it was error, saying "unexpected end or archive". Can you repost?

Thanks a ton!
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,608 posts.
 
Join Date: Mar 2005
Location: UK
17-Feb-2012, 07:49 AM #19
It opens OK for me. Here it is again.
Attached Files
File Type: zip send v 0.0.zip (440.3 KB, 5 views)
Jayabhadra's Avatar
Jayabhadra Jayabhadra is offline
Member with 52 posts.
THREAD STARTER
 
Join Date: Feb 2012
Experience: Familiar
17-Feb-2012, 09:13 AM #20
Ok, opened it already. I made an adjustment.

There's still some issue, for "ID_Vendor" 63 and 68, "status" is "Ok - Cli" so the final score is taken from "Total_Cli". Rather than "Ok -Cli", its "status" should be "havent done field check", since the document score after coaching is "M" and "H" so it goes for field checking. That makes the "nilai_akhir" will be "ongoing".

I tried to make some report I'll need:
- "AllData" which shows all companies "status" and "category".
- "NeedFieldCheck" to show list of company that gonna have field checking.
Both reports need to have problem with field "Vendor", but I can't figure why.

Thanks as always.
Attached Files
File Type: zip send v 0.1.zip (379.0 KB, 6 views)
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,608 posts.
 
Join Date: Mar 2005
Location: UK
17-Feb-2012, 11:58 AM #21
So should the Status ever be Ok - Cli?
I have fixed the Reports for you.
Jayabhadra's Avatar
Jayabhadra Jayabhadra is offline
Member with 52 posts.
THREAD STARTER
 
Join Date: Feb 2012
Experience: Familiar
17-Feb-2012, 12:05 PM #22
Yep, when field "Hasil_Dok" is "TL" or "L" and field "Hasil_Cli" is also "TL" or "L", The status should be "Ok_Cli", like record for ID_Vendor: 100.

Can you post the result? Maybe after the issue for ID_Vendor 63 and 68 is fixed. Real thanks, I thought you already left, cause here is already late
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,608 posts.
 
Join Date: Mar 2005
Location: UK
17-Feb-2012, 12:41 PM #23
I am still trying to figure out the syntax that will allow both "Ok_Cli" and "havent done field check". I have tried using an And and that gives the same problem as the or.
Jayabhadra's Avatar
Jayabhadra Jayabhadra is offline
Member with 52 posts.
THREAD STARTER
 
Join Date: Feb 2012
Experience: Familiar
17-Feb-2012, 12:46 PM #24
Okay, in the meantime I'll just progress with other things I can do. Really tons of thanks OBP, appreciate it so much!!
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


Tags
access, if function, system out of resource

(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑