Return all data plus gaps in data

Data looks like the following --
Start End
101 105
108 110
111 115
117 129
There are gaps in the data! How do I create a query that returns all the
data as well as the gaps? Such as --
Start End
101 105
106 107 *
108 110
111 115
116 116 *
117 129
* = gaps

Thanks

"Kenneth" wrote:

Data looks like the following --
Start End
101 105
108 110
111 115
117 129
There are gaps in the data! How do I create a query that returns all the
data as well as the gaps? Such as --
Start End
101 105
106 107 *
108 110
111 115
116 116 *
117 129
* = gaps

Thanks

Last time you posted this question, you used date ranges with startdate and
enddate. Come to think of it, last time you posted it your name was Martin -
not to be confused with Good Martin. You've been struggling with this for two
weeks now. It's time to hire a professional.

Didn't you say you hired PC Datasheet to do several projects for you? He
could do this query for you in a snap. Maybe he's too expensive. Contact us.
Our fees are very reasonable.

Chris Mills
Your Access Resource

http://www.accessresource.somee.com/Specials.html