i have created a sql query to fill a table in access 2010
my query table is Q_blocksarrived and the code used to form it is:
SELECT T_cellararrival.BlockName FROM T_cellararrival GROUP BY T_cellararrival.BlockName;
now i want to add a Please Select row in my column.
Any ideas?
Something like
SELECT ' Please select' As BlockName
UNION SELECT T_cellararrival.BlockName
FROM T_cellararrival;
Last edited by OnErrorGoto0; 01-24-2012 at 04:42 AM.
Good luck.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks