-
Somewhat new to access.
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
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules