help please!!!

[suicico]

well i have a backend db and a frontend as well..
i wand to make a query that will return some records that i want to check them and here the tricky one, by customer code and date.
lets say that the query returns 4 fields like this
costumer id
product id
date
drawin
I want to be able to check if for some costumer all records are nul in the drawin field for 1 date.
Thanx

 

[WayneRyan]

suicico,

The following will return all costumer's that have a Null drawin date.

Select [costumer id], [product id], date, drawin
From   YourTable
Where  drawin Is Null
Order By [costumer id]

Note:

Having spaces in your names, complicates things.
Can't use Date as a name, because Access has it reserved.

Wayne

 

[suicico]

thanx for reply
and for the advice
lets take it a litle further..
what if i want to message me if one a customer has no drawin for a date ?
to help you get the picture what i want to do is
i want to give in a form to dates and the query will look for the returns (drawin) of the customer, i want if its possible to message me if a costumer have no drawin..
can this be done?

 

[WayneRyan]

suicico,

Do you mean that you want to make a form, enter a Start Date, and an
End Date, then have the form Display all people that have no drawin
within that time frame?

Wayne

 

[suicico]

well the form that ill get the between dates its no problem
the way i would manualy do what i want is this
filter a costumer, then filter a date, check if all drawins are null(thats not good ), then filter the same customer for the next day, check the null stuff, when a customer finish, filter another customer, filter a day.... and so
on.
is there a way to this be done in code?
thanx oncemore.

 

[suicico]

any ideas???
a guidiline at least plz