filter to less than value which is not zero

[ali32j]

Hi All

i am trying to use a query to filter to all values less than £500 but i wish it to exclude the 0 values

my SQL for the filter

HAVING (((Enquiries.[Total Value])<500))

Can anyone help as to what i need to add to ensure all values that are £0.00 are excluded??

Appreciate anyone help

Thanks

Ali

 

[SkipVought]

Hi,

HAVING (((Enquiries.[Total Value])<500))
   AND    Enquiries.[Total Value]>0

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SgtJarrow]

maybe:

HAVING (((Enquiries.[Total Value])<500) AND ((Enquiries.[Total Value])<>0))

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB.NET Programmer

 

[ali32j]

thanks both, used the second one of the two, worked great thanks

 

[dhookom]

It seems the [Total Value] field is not an aggregated value so the filter/criteria would perform better in the WHERE clause rather than the HAVING clause.

Duane
Hook'D on Access
MS Access MVP