theinviter
Registered User.
- Local time
- Yesterday, 21:45
- Joined
- Aug 14, 2014
- Messages
- 237
Dear Guys
need help,
I have query that have combined table, so have create another query and i want to make an expression to get the data from that query based on 3 criteria.
i tried this code
Query Name : " Calender Query"
need add expression to get the data from MRN Query1
Expr1: DLookUp([MRN Query1].[Expr1],[MRN Query1],"[Item Code]='" & [MRN Query1].[Item Code] & "' AND [Clinic]='" & [MRN Query1].[Location - Clinics Name] & "' AND [Company] like '" & [MRN Query1].[Account Name] & "'")
but no successful
any help
find attached file
need help,
I have query that have combined table, so have create another query and i want to make an expression to get the data from that query based on 3 criteria.
i tried this code
Query Name : " Calender Query"
need add expression to get the data from MRN Query1
Expr1: DLookUp([MRN Query1].[Expr1],[MRN Query1],"[Item Code]='" & [MRN Query1].[Item Code] & "' AND [Clinic]='" & [MRN Query1].[Location - Clinics Name] & "' AND [Company] like '" & [MRN Query1].[Account Name] & "'")
but no successful
any help
find attached file