Search results

thanks for your help Paul!!

I just ended up using an IF-ELSE-THEN statement. It's what I know.. Wish I could find out of the Case would work. That just seems more cool.

I'll give you a short break down. I don't want to make you have to write it for me :) Here is the logic in plain english: SMC A1: Type = L, Price > $40,000 and DMD Qty > 500 SMC A2: Type = L, Price is between $6000- $39,999 and DMD Qty is between 100-499 SMC A3: Type = L, Price is...

Lol which one? The SMC is based off of 3 values... 1) Price 2) Dmd Qty 3) Type So can you do a CASE and check 3 variables?

Follow up question... would it be better to do a CASE or an IF THEN ELSE?

Are you kidding me?!? I got it to work. Instead of a Module, I did a procedure. I feel dumb...

What I eventually want to write in VBA is this but 2x longer: Where nz([SD])+nz([SI]) = DMD Qty SMC: IIf([MC]![P]>39999 And (nz([SD])+nz([SI]))>499 And [MC]![F]="L","A1",IIf([MC]![P]>39999 And ((nz([CD])+nz([CI])) Between 1 And 29) And ((nz([SD])+nz([SI])) Between 100 And 499) And...

The above code doesn't work. When I try to test it in the immeidate table it says "Expected Variable or Precedure, not module." When I try to use the function in query builder it says "Undefined Function "SMC" in expression"

Hello, I've tried googling for the past few hours and I can't figure out what I'm doing wrong. I'm trying to get this to work: Public Function SMC(Dmd As Long) As String If Dmd > 50 Then SMC = "A1" End If End Function Then I want to go to Query builder and say "SMC: SMC([Dmd...

No ideas? Do I need to give more input?

SELECT SWR.[Office], SWR.Product, [SOH C].SumOfUnrestricted, Sum(SWR.[Order Quantity]) AS [SumOfOrder Quantity1] FROM [SOH C] RIGHT JOIN SWR ON [SOH C].[External Long Material Number]=SWR.Product GROUP BY SWR.[Office], SWR.Product, [SOH C].SumOfUnrestricted HAVING ((([SOH...

This is driving me insane. I even consolidated the queries with more complex expressions. That's not the problem I don think.

Hello, In access I have a query (made from 2 queries) then compared against another double query. When I open excel and try to import it (so they sync/refresh data). It just imports nothing but the headers, no data. Just 2 blank rows. Anyone know why? My other imports to excel work just fine.

Well, never mind. I did a query of a query of a query to get it. If anyone knows a simplar way, please let me know!

I have another challenge similar to this but I can't think it out. I have 4 important fields. Order Number (Unique except 1st 5 charectors) Product Number Quantity Customer Number I need to filter the 8 important order numbers that start with 5 charectors like THOQ or SADJAA. I filtered...

You are great! Thanks!

Hello, I tired to search for help on this topic but I can't find anything specific to what I'm looking for. I have a table that has a long list of order numbers, the 1st 5 mean location like: THOQR1234WERAJS12 ASKLFJ1432WEJKLAKS THOQR1234WKLAJS17 THOQR1234WKIAJS13 GASDKAL123ASF0800...