Auto fill

[Steve183]

Hello all,

I’m working on a charity donation database. I have a calculated field [DonationTotal] in a subform. I have another textfield [DonationStatus] on the main form.

When a DonationTotal gets to $500.00 I want the DonationStatus to auto fill with “Bronze”

When a DonationTotal gets to $1000.00 I want the DonationStatus to auto fill with “Silver”

When a DonationTotal gets to $1500.00 I want the DonationStatus to auto fill with “Gold”

When a DonationTotal gets to $2000.00 I want the DonationStatus to auto fill with “Platinum”


Can’t figure out how to do this. Any help would be greatly appreciated.

Regards,

Steve

 

[highandwild]

Have a look at the Orders form in the Northwind sample database.

Have a SUM calculation in the footer of the subform that sums the text box in the detail section. You then make reference to this in the main form.

 

[Steve183]

Hello HighandWild

I guess I didn’t explain my problem that well. The DonationTotal is summed. It’s the auto fill of the DonationStatus that has me at my wits end.

I’ve spent days at this. I’m not sure whether to run a query somehow, or Dlookup, or If Then Else. I’m lost.

Steve183

 

[boblarson]

Well, for one - you should probably be storing the donation amounts as an individual record for each and then using a QUERY to get the totals (not storing the total in the table) just as you should NOT store the status in the table, but use a QUERY to display the amount. You can use a QUERY in 99.9% of the places where you would use a table.

 

[highandwild]

Use the Switch function and set the criteria values in descending order.