Querie Help

[Jramosent]

Just started learning and need help with the list below please:

1. Boat name, owner ID, first & last name of owner and fee for owner ID #2
2. Boat name, fee, first & last names of owner and renewal fee, which is 30% more than the current fee, in order by renewal fee, with the highest renewal fee first

For all queries, create column headings that are appropriate.\

on #1 how do I select only to show fee for owner ID #2?
and also help with #2?


Thank you.

[June7]

1. apply filter criteria.
Can have parameter input popup which is not a good idea because can't validate input so review:
http://datapigtechnologies.com/flash...earchform.html
http://datapigtechnologies.com/flash...tomfilter.html
http://datapigtechnologies.com/flash...mtoreport.html

2. maybe: SELECT *, [CurrentFee] * 1.30 AS RenewalFee ORDER BY [CurrentFee] * 1.30;