SQL query

[Dreamspinner]

I have two questions about a query I'm having trouble with. The DB is Access.

Select Count([UCall]) as Zcnt from tblScore where (Zonex Is Not Null and UCall=[in_call]);

WHen I run this in Access, I get the prompt for in_call twice. The first does nothing (AFAICS), the second returns Zcnt.

I'd also like to put an order by Zonex in the query.

TIA DS

 

[guitarzan]

At first glance, I would say tblScore does not have a field called "in_call"

But, this is really the right forum for this question. I would look into one of the access forums, possibly:
forum701