Dlookup Repeating the same data

Cobra23md

Board Regular
Joined
Jan 8, 2003
Messages
118
I have a query that pulls data from one table and works the way I need it to. However, some people that look at the data in the query wanted a new column added. I have another query that looks this information up. I tried using dlookup to pull that information from the 2nd query. The query works fine but the new column has the same data repeated all of the way down. The data it is displaying lines up with the first row in the query, but the rest of the rows should be different. I am at a complete loss as to how to fix this. My dlookup statement looks like this.

Ratio:dlookup("MaxofRatio",[qry Ratio 3],"Employee="& '[Employee]')


Any help is appreciated. This has me baffled. Thanks. :confused:
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,357
Office Version
  1. 365
Platform
  1. Windows
Well that expression isn't right for a start, and I don't actually see how it would give you any results.

Do you actually have an employee called [Employee]?:)

Perhaps this?

Ratio:dlookup("MaxofRatio",[qry Ratio 3],"Employee='"& [Employee] &"'")
 

Cobra23md

Board Regular
Joined
Jan 8, 2003
Messages
118
Norie,
Thanks for the response. It worked the way I wanted it to. Thanks again. :biggrin:
 

Forum statistics

Threads
1,181,055
Messages
5,927,863
Members
436,573
Latest member
CMR237

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top