PgAccess Visual Query

Could someone tell me the syntax for the "Criteria" box for the following 
commands:

1. (Date column) Dates between 01-07-2002 and 30-09-2002
2. (Chart_ID column) Where value=10074 
3. (Trans_ID column which has 3 entries with same ID, but only one would have 
a Chart_ID of 10074) If entry has a Chart_ID value of 10074, return all the 
rows EXCEPT the actual entry with Chart_ID=10074

So the query should return this with the amount column split

Date			Chart_ID		Trans_ID		Amount	Amount	Amount

01-07-2002	10074		45689		15
01-07-2002				45689				100
01-07-2002				45689						115

Regards

Scott