November 26, 2004 at 9:59 am
Hi All
I am fairly new to SQL server and views
I am working of an Access ADP application and receive an Error 2757 when I try an filter out the duplicate entries in a column from a view. I am trying to apply the Group and First logic as used in Access Queries.
My view is compiled from 6 tables. Tables_Element has an inner join to a unique ID in Table_Chapter, and Table_Option has an inner join to a unique id in Table_Element. Entries in Table_Option are duplicated and apply to entries in Table_Element & Table_Chapter.
Where the entry from Table_Option appears more than once for an entry in Table_Element, I want the recordset to only list the first instance of the Table_Option entry for the Table_Element record. The reason why I need only the first record is is minimise the entries in a Form.
Is this not working because the recordset is a View or because I shouldn't be using the Group and First logic from Access Queries???? How else can I get the recordset to diplay unique instances of records????
I have tried using the Group and First logic with a Query in Access from view and I dont get the result I get if I create the query from scratch!!!
Thanking you
Emil
November 29, 2004 at 8:00 am
This was removed by the editor as SPAM
December 1, 2004 at 9:28 am
Try using the Min function instead of First. First is not a function in T-SQL.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply