chart empty fields

[alkrm]

hi ,
i have a chart report built on a query
you will select a date on a form maped to a query,the query will give you the data related to that date and previous 6 days in addition to the day u already selected.
Problem.
some records are not available in the date field.
the Query is ignoring the Empty fields while the Chart Report is showing them with no data

"HOW CAN I LET THE CHART REPORT IGNORE THE EMPTY RECORDS?


thanx in advance

 

[WayneRyan]

ALKRM,

Your query needs for criteria in the appropriate date field:

Is Not Null

Wayne

 

[alkrm]

more about

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??