Hi Guys,
I am having a spot of bother again - help please.
I am trying to do a count of a set of records for a field in a query.
I am user parameters and all was going well until I tried to change a date bit to between 2 dates - I am now getting odd results.
I have tried the following
DCount("id","matches","[totbooks]<21 and [div]='" & [enter league code] & "' and [date] between #" & [enter date1] & "# and #" & [enter date2] & "# ")
this returns a count that is much too high
and also
DCount("id","matches","[totbooks]<21 and [div]='" & [enter league code] & "' and [date] >= #" & [enter date1] & "# and [date]<= #" & [enter date2] & "# ")
this returns 0
I must admit it took me a while to work out all the delimiters needed to accomodate parameters and I wonder if they are not correct?
cheers
Phil
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar