DLookup

[DJ_DEF_CON_1]

I have a table that is full of golf scores the courses the dates played and so on.

I have written a query that uses the Avergage function of all the scores played by a certain user based on Start and end dates.

I have created a form where a user selects the start and end dates and a player. The user would then press a command button, where I would use a "DLookup" to populate the text box.

If I populate all the filter criteria and run the query on it's own, I get the data I require. If I try to get that number to populate in an unbound text box, I get an aggrevate error.

Does anyone know why the query would work, but the DLookup would not?

Thanks

 

[AncientOne]

is it possible to post the query and the dlookup statement?

 

[DJ_DEF_CON_1]

I am at work now I will post in a couple of hours.

Thanks for your initial help.

 

[WayneRyan]

DJ,

I don't think that the DLookUp function can
work with aggregates. It sounds like you
need DSUM divided by DCount.

Instead, I'd use your successful query to
populate a nice popup form (and/or report)
to display the info.

Wayne