Need help writing a query to pull data with six zeros on the end

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

Guest

I have a large data set of nunbers of varying length (between 6 and 20
digits). I would like to pull all of the numbers that end in 6 zeros,
regardless of the length of the number.
 
Create a custom expression:

Custom: Right([FieldName],6)
Criteria: "000000"

1. Open your query in design view.
2. Go to the end (find a blank field).
3. In the Field block, enter the expression above (change field name).
4. In the Criteria block below, enter the criteria listed above (include the
quotes).

That should do the trick.

Best regards,

Todd Shillam
 
Todd Shillam said:
Create a custom expression:

Custom: Right([FieldName],6)
Criteria: "000000"
Click to expand...

Or put the following in the Criteria row of the FieldName column:

Like "*000000"

Tom Lake
 
Back
Top