Hi,

The Situation is This: I have three user access levels (1,2,and 3)
In a query there are different prices for each user group.
Such as Price 1 (for group1) Price 2 (for group 2) and Price 3 (for group 3)

eg. A Product for group 1 would cost 10, group 2 :8 and group 3 6

Group 1 pricing will be available to all users, who do not need to login to the products page (products.asp) I then want members of group 2 to login in to view group 2 prices on the same page (products.asp) and likewise with group 3

If anyone can help me it would be greatly appreciated and i hope i can help others too.

Many Thanks,
Leon