more about

[alkrm]

thnx for reply WayneRyan

guess i didn't explain the problem very well.

this is example of what is happening

some dates are not exist in the record set cause they r either week ends or holidays..

at the date crieteria i wrote:
CDate([forms]![x]![text0]) Or CDate([forms]![x]![text0])-1.......CDate([forms]![x]![text0])-6

So it count 7days "week"
how can we ignore the dates which are not exist?

when u run the query it only shows 5 records.
but when u run the chart based on this query it will show 2 days with no bars "data"

think i am missing somthin ,,,,, any directions??

 

[alkrm]

delete this admin

it's a reply on another thread.
tried to delete it but i have no right to do so...