juicybeasty
Registered User.
- Local time
- Today, 12:31
- Joined
- Feb 17, 2003
- Messages
- 52
I'm having a problem with a query, as follows:
I need to be able to enter the name of an account handler when prompted. So in the criteria section of the AccountHandler field I've got [name]. This works OK when none of the other fields have criteria.
However I also need to have data for specific months only.
I have CreatedMonth and CreatedYear fields, and the criteria I have for them are:
CreatedMonth - "nov" or "dec" CreatedYear - "02"
CreatedMonth - "jan" or "feb" or "mar" Created Year - "03"
Once I add the above criteria (on 2 separate lines as shown above), it still asks for AccountHandler name, but regardless of what you put in it still brings up details for ALL account handlers.
No doubt there's a simple explanation for this.
I hope someone can help me. Thanks.
I need to be able to enter the name of an account handler when prompted. So in the criteria section of the AccountHandler field I've got [name]. This works OK when none of the other fields have criteria.
However I also need to have data for specific months only.
I have CreatedMonth and CreatedYear fields, and the criteria I have for them are:
CreatedMonth - "nov" or "dec" CreatedYear - "02"
CreatedMonth - "jan" or "feb" or "mar" Created Year - "03"
Once I add the above criteria (on 2 separate lines as shown above), it still asks for AccountHandler name, but regardless of what you put in it still brings up details for ALL account handlers.
No doubt there's a simple explanation for this.
I hope someone can help me. Thanks.