I hope this is the correct forum.
I need a view that returns the Top 2 (most recently added) records in a table called Person_For_Contact. I want the top 2 record items to be contained in the one record i.e PFC_1_Address1, PFC_1_Phone etc and PFC_2_Address1, PFC_2_Phone etc.
I know how to do this in a stored procedure, but I need a view to do the job as I am linking to it from an Access database.
I have not had any success in a view.
Thanks
I need a view that returns the Top 2 (most recently added) records in a table called Person_For_Contact. I want the top 2 record items to be contained in the one record i.e PFC_1_Address1, PFC_1_Phone etc and PFC_2_Address1, PFC_2_Phone etc.
I know how to do this in a stored procedure, but I need a view to do the job as I am linking to it from an Access database.
I have not had any success in a view.
Thanks