[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 359
  • Last Modified:

How to get order from a non-structured database.

For QC to determine whether or not they should pre-stage a job they have to open this database and look at the form and visually check it to see if certain fields start with an * or not.  If all fields CellBock5  through CellBock11 start with an *.  Then they should pre-stage.  If any of the said fields have data, but don’t start with an * then they need to bring the part into the lab for checking and they don’t pre-stage.  

I have uploaded an Adobe file to explain what I need and also the database used.  ( the original database uses a backend for the data.  This one has everything together.)
EE-CCharts323-01.pdf
CChartsTest.mdb
CCharts.xls
0
dbqluthier
Asked:
dbqluthier
  • 2
1 Solution
 
GRayLCommented:
Does this do it?

SELECT tblInspecChDataTest.*
FROM tblInspecChDataTest
WHERE InStr("*******",Left(CellBock5,1) & Left(CellBock6,1) & Left(CellBock7,1) & Left(CellBock8,1) & Left(CellBock9,1) & Left(CellBock10,1) & Left(CellBock11,1)) > 0
AND Len(Left(CellBock5,1) & Left(CellBock6,1) & Left(CellBock7,1) & Left(CellBock8,1) & Left(CellBock9,1) & Left(CellBock10,1) & Left(CellBock11,1))<7;
0
 
dbqluthierAuthor Commented:
It worked.  I just plugged it in.

Question:  how does the <7 work?
It would seem that blank fields would mess this up, but they don't.

Super super

Mitch
0
 
GRayLCommented:
Thanks, glad to help.

I am created a string using the first character of each cell which should be a "*".  If it is another character, the InStr function will kick it out.  because that condition will return a zero - hence > 0.  Now I only want to see those records where one  or more of the cells is not filled in, in which case the length of the string has to be less than 7 hence < 7.  If you alter the number of key cells you have to alter the "*******" string accordingly.  
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now