Return all data plus gaps in data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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
Click to expand...

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
 
Back
Top