Excel Visual Basics - Reading Closed .csv files & Grabbing Certain Rows

CRogers650 

I think you can use first and last to specify the first and last records like below:

select first(item_description),first(qty) from PiecesMinifigsSets union all select last(item_description),last(qty) from PiecesMinifigsSets;

sample:

drop table PiecesMinifigsSets;
create table PiecesMinifigsSets (item_description text,qty double);
insert into PiecesMinifigsSets values('black title',0.1);
insert into PiecesMinifigsSets values('black title',0.2);
insert into PiecesMinifigsSets values('black title',0.3);
insert into PiecesMinifigsSets values('black title',null);
insert into PiecesMinifigsSets values('blue title',0.11);
select * from PiecesMinifigsSets;

item_description qty

select first(item_description),first(qty) from PiecesMinifigsSets union all select last(item_description),last(qty) from PiecesMinifigsSets;

Expr1000 Expr1001