BAQ - Customer Number filter seven digits

Are you referring to the CustID field? You can create a calculated field to get the length of the customer ID field then filter results based on the calculated field value. (9.05.702 progress)


(The CustNum field is just a numeric field so if its that one you could just filter that directly)



<!-- #ygrps-yiv-529868009 _filtered #ygrps-yiv-529868009 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-529868009 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-529868009 {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #ygrps-yiv-529868009 {font-family:Consolas; panose-1:2 11 6 9 2 2 4 3 2 4;} _filtered #ygrps-yiv-529868009 {font-family:Verdana; panose-1:2 11 6 4 3 5 4 4 2 4;} #ygrps-yiv-529868009 #ygrps-yiv-529868009 p.ygrps-yiv-529868009MsoNormal, #ygrps-yiv-529868009 li.ygrps-yiv-529868009MsoNormal, #ygrps-yiv-529868009 div.ygrps-yiv-529868009MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman", "serif";} #ygrps-yiv-529868009 a:link, #ygrps-yiv-529868009 span.ygrps-yiv-529868009MsoHyperlink { color:blue; text-decoration:underline;} #ygrps-yiv-529868009 a:visited, #ygrps-yiv-529868009 span.ygrps-yiv-529868009MsoHyperlinkFollowed { color:purple; text-decoration:underline;} #ygrps-yiv-529868009 p {

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-529868009 code
{
font-family:“Courier New”;}
#ygrps-yiv-529868009 pre
{

margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:“Courier New”;}
#ygrps-yiv-529868009 tt
{
font-family:“Courier New”;}
#ygrps-yiv-529868009 span.ygrps-yiv-529868009apple-tab-span
{}
#ygrps-yiv-529868009 span.ygrps-yiv-529868009cat
{}
#ygrps-yiv-529868009 span.ygrps-yiv-529868009ct
{}
#ygrps-yiv-529868009 span.ygrps-yiv-529868009HTMLPreformattedChar
{

font-family:“Consolas”, “serif”;}
#ygrps-yiv-529868009 p.ygrps-yiv-529868009attach, #ygrps-yiv-529868009 li.ygrps-yiv-529868009attach, #ygrps-yiv-529868009 div.ygrps-yiv-529868009attach
{

margin-right:0in;

margin-left:0in;
font-size:9.0pt;
font-family:“Arial”, “sans-serif”;}
#ygrps-yiv-529868009 p.ygrps-yiv-529868009bold, #ygrps-yiv-529868009 li.ygrps-yiv-529868009bold, #ygrps-yiv-529868009 div.ygrps-yiv-529868009bold
{

margin-right:0in;

margin-left:0in;
font-size:10.0pt;
font-family:“Arial”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-529868009 p.ygrps-yiv-529868009green, #ygrps-yiv-529868009 li.ygrps-yiv-529868009green, #ygrps-yiv-529868009 div.ygrps-yiv-529868009green
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
color:#628C2A;}
#ygrps-yiv-529868009 p.ygrps-yiv-529868009replbq, #ygrps-yiv-529868009 li.ygrps-yiv-529868009replbq, #ygrps-yiv-529868009 div.ygrps-yiv-529868009replbq
{
margin:3.0pt;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-529868009 p.ygrps-yiv-529868009ad, #ygrps-yiv-529868009 li.ygrps-yiv-529868009ad, #ygrps-yiv-529868009 div.ygrps-yiv-529868009ad
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-529868009 p.ygrps-yiv-529868009underline, #ygrps-yiv-529868009 li.ygrps-yiv-529868009underline, #ygrps-yiv-529868009 div.ygrps-yiv-529868009underline
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-529868009 span.ygrps-yiv-529868009yshortcuts
{}
#ygrps-yiv-529868009 p.ygrps-yiv-529868009ad1, #ygrps-yiv-529868009 li.ygrps-yiv-529868009ad1, #ygrps-yiv-529868009 div.ygrps-yiv-529868009ad1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-529868009 p.ygrps-yiv-529868009ad2, #ygrps-yiv-529868009 li.ygrps-yiv-529868009ad2, #ygrps-yiv-529868009 div.ygrps-yiv-529868009ad2
{

margin-right:0in;
margin-bottom:7.5pt;
margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-529868009 p.ygrps-yiv-529868009underline1, #ygrps-yiv-529868009 li.ygrps-yiv-529868009underline1, #ygrps-yiv-529868009 div.ygrps-yiv-529868009underline1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
text-decoration:underline;}
#ygrps-yiv-529868009 span.ygrps-yiv-529868009yshortcuts1
{
font-family:“Verdana”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-529868009 span.ygrps-yiv-529868009yshortcuts2
{
font-family:“Verdana”, “sans-serif”;
font-weight:normal;}
#ygrps-yiv-529868009 span.ygrps-yiv-529868009EmailStyle37
{
font-family:“Calibri”, “sans-serif”;
color:#1F497D;}
#ygrps-yiv-529868009 .ygrps-yiv-529868009MsoChpDefault
{
font-size:10.0pt;}
_filtered #ygrps-yiv-529868009 {
margin:1.0in 1.0in 1.0in 1.0in;}
#ygrps-yiv-529868009 div.ygrps-yiv-529868009WordSection1
{}
#ygrps-yiv-529868009
_filtered #ygrps-yiv-529868009 {
}
_filtered #ygrps-yiv-529868009 {

font-family:Symbol;}
_filtered #ygrps-yiv-529868009 {

font-family:“Courier New”;
}
_filtered #ygrps-yiv-529868009 {

font-family:Wingdings;}
_filtered #ygrps-yiv-529868009 {

font-family:Wingdings;}
_filtered #ygrps-yiv-529868009 {

font-family:Wingdings;}
_filtered #ygrps-yiv-529868009 {

font-family:Wingdings;}
_filtered #ygrps-yiv-529868009 {

font-family:Wingdings;}
_filtered #ygrps-yiv-529868009 {

font-family:Wingdings;}
_filtered #ygrps-yiv-529868009 {

font-family:Wingdings;}
#ygrps-yiv-529868009 ol
{margin-bottom:0in;}
#ygrps-yiv-529868009 ul
{margin-bottom:0in;}
–>

Is there a way to filter a BAQ results to only retrieve customer numbers that are seven digits? We have customer numbers that are 4 and 5 digits that I do not want to bring into the BAQ.