I am in the process of writing a "best available price" function for a
rooms booking system. I run through 4 possible special price scenarios
on a booking (normal price, stay for x and pay for y nights, minimum
stay, booking made between x and y date etc) and in each scenario set
3 variables. Not all bookings would qualify for all scenarios, so I
could get null values assigned.
Special_ID - Can be null
Description - text description of the special
Value - Calculated Value for the scenario
Where I am stuck is with taking my values and putting them into some
form which I can use in the following way:
I need to present the user with the available option (listbox?) so
that they may make a selection of which price they wish to
use. I wish to pre-select the lowest price option. Do I need to create
array, or should I be looking to create a temporary table. I am not
familiar with arrays in vba.
Tidak ada komentar:
Posting Komentar