Using DLookup with Multiple Criteria in Microsoft Access, Part 2

[@RungeCarl]

Brilliant!!! Part 3 please.

[@hosseinpeyvandi3992]

Dear Richard I just learned access all by your tech help videos along past one year and I am so thankful of that. Actually I can't be one your members because of my country policies we can't register or have money transaction in other websites. So sure I want to see the part 3 and I think your gonna use a sub query in the orders query to add discount to the calculated field maybe

[@franciscunninghamjr.3496]

Hi, I for one would like to see more! Thank you for such interesting solutions

[@Shadow.Dragon]

Great video, Richard! I definitely would like to see how you incorporate it into your order db.

[@LogicalDocHIGHTONNAS]

HI Richard, Agree with your comment on quote colours. Would be really helpful to give different colours to all the beginning and ending related quotes as well in your example. Thx from a Platinums member Ron

[@zorandobrijevic8729]

Excellent explanation. Part 3 please, when you can get to it.

[@michael23864]

Yeah I would like to have seen how to apply the discount to the order another excellent video very educational

[@Aki-ht6vh]

Sir which of your course teach on managing pharmacy inventory that includes batch, expiry date. Adding opening stock, purchases and return, sales and return, removing expired product etc. Which method will make access run smoothly in long term even if there are a million inventory records (with their batches) created over a decade? P.s. stock in hand (with their batch and expiry) should appear in combo box when entering sales, p.return or s.return

[@hggryrdchgc]

dont use combo box with sql. use an append query to make the orders

[@aminam3849]

Hi Richard , I'm so great full of your teaching your knowledge and following you all the time , I need a lookup code just like that you told to teach in part 3 , I need to get a value from a table based on dlookup of three or even four cells of that row , if you can do wat u just said im be so grateful, tanks body

[@599CD]

599cd.com/Ask

[@janvanantwerp6574]

Part 3 please... Tks

[@vitom5513]

You can't leave us hanging :) (At least you didn't put it in Members Only)

[@nickbroekhuizen8858]

Yes please Richard, add the discount .. :)

[@alializadeh8195]

Thanks

[@MrGregGooss]

Part 3 please.

[@wmanacay]

Hi, thank you for your video. It is very helpful. I have this script but it is giving me an error -> ValLkUp = DLookup("PermissionPath", "dbo_UserMappedADGroup", "AccountName=""" & [UserName] & """ AND PermissionPath=""" & [strGroupWithAccess] & """") ..AccountName and PermissionPath are columns in the table.On the other hand, [UserName] and [strGroupWithAccess] are variables. Can you please help? Thank you.

[@iljak2914]

Pleas part3🎉😂

[@gregoryjeffries8475]

I want to see how to incorporate.

[@69woogie]

Defo wanna know Mr Rost.

[@sanch023]

C'mon!! Put discounts into that order total!!! Thank you!!!!

[@fontie38]

I do