how do i list values within a given range?

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

Guest

i am trying to list the values that my original data does not provide. E.g I
have a range beginning with "ABC0001" and ends at "ABC0043". How do I write a
query or to list the values not shown i.e "ABC0002" all the way to "ABC0042"
as individual values in a seperate table?
 
I would use VBA to loop through a recordset, and record the 'missing' values.
Use Left$(), Mid$(), Right$() and/or InStr() functions to help seperate the
numbers from the text.
 
Steve,
Thanks for your help. Unfortunately, i forgot to mention that i am fairly
new to access and all i am familiar with is the basic stuff running simple
queries, creating tables and forms.

if you could break it down a litte more for me, I would greatly appreciate it.

I.O.
 
Back
Top