asked on

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

ASKER CERTIFIED SOLUTION

GRayL

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

dbqluthier

ASKER

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

GRayL

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.