Query Data on a Report

mattstrachan

Registered User.
Local time
Yesterday, 21:15
Joined
Feb 22, 2013
Messages
31
I am having trouble getting data to appear on my Report. The report is based of a Query, qryLabel. When I run qryLabel the correct data is displayed but when I try to use this data on the Report, I get an #Error or #Type. Here are the methods I have tried so far to get the data on my Report:

DLookUp
=DLookUp("[StoneLength]","Stones","[StoneName] = Forms![Product]![ProductID]")

Using The Query
=[qryLabel]![StoneLength]

Using the Table
=[Stones].[StoneLength]

Am I just completing missing something this morning?
 
I apologize, I was just completely missing something this morning. I just neeeded to use the DLookUp with the Query as the domain.
 

Users who are viewing this thread

Back
Top Bottom