Dlookup Repeating the same data

[Cobra23md]

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.

 

[Norie]

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]

Norie,
Thanks for the response. It worked the way I wanted it to. Thanks again.