Select From Where clause

[Raimond]

I am having trouble with this clause Help Please.....

Here is what I have that is not working.

=Select sum ([amount of SS] From main Where [type of SS] = "Bus Pass")

Thanks in advance

 

[pbaldy]

Try

=DSum("[amount of SS]", "main", "[type of SS] = 'Bus Pass'")

 

[Raimond]

Thanks for the quick response.
That worked to return a value, however, it does not follow my date criteria..

It returned the total amount of "bus pass" for the entire table. I need to be able to select a date range. I am using access 2003 and do not see DSUM in my referance book.

 

[pbaldy]

This is the first you've mentioned date criteria. You can add to the criteria; here's a good reference:

http://www.mvps.org/access/general/gen0018.htm

 

[pbaldy]

I guess I should have added that I would have the user entering the dates into a form, and the DSum() would look there for the values.