Blank Rows

  • Thread starter Thread starter Nick
  • Start date Start date
N

Nick

Anyone know how to write a query that can insert a blank row into a table
after a set of criteria?

Example: Pretend a set of data is sorted by START DATE. INSERT a blank row
after START DATE changes?

Thanks!

Nick
 
You could do something like that using a UNION query. But note that this does
not add records to a table, it just shows a record in the query.

SELECT 1 As MySort, StartDate, Field2, Field3,
FROM Table
UNION All
SELECT Distinct 2, StartDate, Null
FROM Table
ORDER BY MySort, StartDate

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
It won't be completly blank, maybe a few fields filled in.

Long story why I need it, It has to do with another post I have in this
forem, entitiled "Query Help". Inserting blank rows would fix that
problem...although it's not the most efficient way, it would work.
 
Back
Top