Hi Larry,

The view code is as follows:

(I'm sorry I can't remember how to insert code in html page)

SELECT Services.serv_id, Services.unit_id, Services.phb_id,;
Services.invent_id, Services.install_id, Services.subscripno,;
Services.which_svc, Services.service, Services.start_date,;
Services.recur_fee, Services.descrip, Services.start_time,;
Services.createdate, Services.house_id, Services.smoke_id,;
Services.memb_id, Services.other_id;
FROM ;
lw!services;
WHERE Services.memb_id = ( ?vp_membid );
ORDER BY Services.which_svc DESC

This looks OK to me......

Wayne