Somewhat new to access.

[tkelley1620]

I am relatively new to access so please bear with me.


I have an access database with the following fileds

Name
Years Purchasing
Most Recent Spend
LY Spend Months Since Last Purchase
New Customer
Promotion offer:*
The promotion offer field has the following query [CODE]Promortion Offer: IIf([LY Spend]>=1000,0.5,IIf([LY Spend]>=400,0.25,IIf([LY Spend],0.1)))[/CODE

In the next step I have to display all the offiers that only have 50% but without using the cryteria field.
Can someone help?
Not exactly sure how to do this and am a bit stuck thank you
tom

[orange]

You should review this to help with database design.
http://forums.aspfree.com/attachment...2&d=1201055452

Also,if you use a naming convention that does not allow embedded spaces in field or object names, you will save yourself from a lot of grief and syntax errors.

Name is a reserved word in Access. Here is a link with a number of reserved words.
http://allenbrowne.com/AppIssueBadWord.html

The real key to successful database is table design. Before getting too involved with Queries, make sure your table(s)
is Normalized.

Good luck with your project.