Copy Value Into A Control Based On A Criteria ANSWER

A

Ange Kappas

Hi All,
I worked it out by myself after trail and error using
DLookup in a independent control (named it getrate) and then using the
setvalue as a macro copied the getrate value into the DAILY CHARGE control.

This is the DLookup as I woked it out

=DLookUp("[PRICE]";"PRICELIST";"[COMPANY]=[RESPEL]![COMPANY]AND[RESPEL]![TYPECHARGE]=[CHARGE]AND[RESPEL]![PRICELIST]=[CATEGORY]AND[RESPEL]![ARRIVAL]>=[START]AND[RESPEL]![ARRIVAL]<=[END]")

Hope it helps someone else

Bye
Ange
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adjusting SQL in Query 3
Copying Specific Records From A Field According to another Field By Code 2
Code Stops Due to No Values In Query 5
Checking a Status Control from a Form Before Proceeding 0
Setting Up A Query with Certain Date Criteria 0
Checking a Status Control from a Form Before Proceeding2 1
Subform Linking To Multiple Master Fields Optional 1
Combo Box Default Value based on a query 7

Top