0

Between filter on a Alpha numeric

Jet Reports Historic Posts

October 20, 2009 16:13

None

Follow

This is proberbly a lame question to some but;

I have a report that gets data based on a number range using a filter of 1000..2000.
How do i get it to stop returning job numbers that are larger that 4 characters long in an alpha numeric field?

ie

1000
1001
149999
1500
1501
199888
1999

I need to exclude the 149999 and 199888 numbers and any others that it may come across….

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts October 21, 2009 03:09

  Did you want to stop Job Numbers greater than 2000
  or Stop job numbers with more than 4 characters?
  
  -Bromy

• 0
  
  Jet Reports Historic Posts October 21, 2009 09:07

  The job numbers are broken into ranges userally 1000 to 2000 and 2000 to 3000 which defines a set job type.
  So the Jet report is set with this in mind and reports all costs/revenue against the job range with a sum at the bottom.
  It then loops and does the same for the next job range.
  
  However there are some legacy job numbers that appear but we do not want to appear. So the answer would be only 4 characters long.
  
  Any idea?

• 0
  
  Jet Reports Historic Posts October 21, 2009 13:05

  Or is there a function to convert and treat the column as a number only ;)