Switchwork
Registered User.
- Local time
- Today, 11:51
- Joined
- Dec 1, 2003
- Messages
- 81
Returning queries with no prices. HOW?
Hello all.
Thanks for all of your help for 2003.
Now I need help in 2004.
The problem I have is: I am designing a database for a courier company that I work for.
I want a query that brings me all the records I have from certain dates that have NO Prices for them in the JOB PRICE field. The field that has no price has got £0.00 in it. I don't want it to return any records that has no data at all in the field. Just the ones that have £0.00 in the field.
Could someone please help me with this.
Thank you. I could do with the answere as soon as possible.
Switch
Hello all.
Thanks for all of your help for 2003.
Now I need help in 2004.
The problem I have is: I am designing a database for a courier company that I work for.
I want a query that brings me all the records I have from certain dates that have NO Prices for them in the JOB PRICE field. The field that has no price has got £0.00 in it. I don't want it to return any records that has no data at all in the field. Just the ones that have £0.00 in the field.
Could someone please help me with this.
Thank you. I could do with the answere as soon as possible.
Switch
