F
faxylady
In my contacts, I have created a customized ID field. I did this by first
creating an ID field with the data type as Autonumber. After Access
populated this field, I then added my own customized ID by adding a prefix to
the ID field by means of an Update Query. Ex. in the Update to:
Prefix&[ID]
the prefix being my customized ID.
Now I am trying to export some of these records to the desktop so they can
be imported into another program.
In a Select query, I tried entering
Criteria:
Between Prefix1 and Prefix300
Over 5000 records were returned in the result set. I noticed Prefix 1000+
was entered.
How do I get Access to return the exact results between 1 and 300? I seem
to be missing something here perhaps from my training that I don't remember.
Thank you.
creating an ID field with the data type as Autonumber. After Access
populated this field, I then added my own customized ID by adding a prefix to
the ID field by means of an Update Query. Ex. in the Update to:
Prefix&[ID]
the prefix being my customized ID.
Now I am trying to export some of these records to the desktop so they can
be imported into another program.
In a Select query, I tried entering
Criteria:
Between Prefix1 and Prefix300
Over 5000 records were returned in the result set. I noticed Prefix 1000+
was entered.
How do I get Access to return the exact results between 1 and 300? I seem
to be missing something here perhaps from my training that I don't remember.
Thank you.