I have a query produces two records for each of my tank I have. The
only item in my query that is different in the two records is my
Model#. The can be tied to a location that I'm not showing in my
query. Is it possible to create two separate fields in my query and
only return 1 record that show both model numbers? I know this is
possible in sql with a case statement.

MFG_SN# Model#1 Model#2 LeakCode (Model#1 when Location is equal to
inner, Model#2 when location is equal to outer)

SELECT dbo_MaterialProducedActualEpa.EpaValue AS Model,
dbo_MaterialProducedActualEpa.GenealogyId AS MFG_SN,
dbo_ResourceActualEpa.EpaName, dbo_MaterialProducedActualEpa.Location
FROM dbo_MaterialProducedActualEpa RIGHT JOIN dbo_ResourceActualEpa ON
dbo_MaterialProducedActualEpa.GenealogyId =
dbo_ResourceActualEpa.ProductionRequestId
GROUP BY dbo_MaterialProducedActualEpa.EpaValue,
dbo_MaterialProducedActualEpa.GenealogyId,
dbo_ResourceActualEpa.EpaName, dbo_MaterialProducedActualEpa.Location
HAVING (((dbo_MaterialProducedActualEpa.GenealogyId)>"000 100") AND
((dbo_ResourceActualEpa.EpaName)="Leak1"))
ORDER BY dbo_MaterialProducedActualEpa.GenealogyId;

I've given this a try
Model1:
DLookUp("[EpaValue]","dbo_MaterialProducedActualEpa","[Location]=Inner")
But I get the error
"The expression you entered as a query parameter produced this error:
'Microsoft Office Access can't find the name 'Inner' you entered in
the expression'" followed by a ODBC call fail. I've played with where
I place the quotation marks, but with no luck.

mcolson wrote:

I sometimes use something like
"Location = 'Inner'")
"Location = """ & YourFieldName & """")