how could i do that with access? (1 Viewer)

stefanocps

Registered User.
Local time
Today, 10:53
Joined
Jan 31, 2019
Messages
153
each row it is not random. each row is fixed
the row I001
will be all the time the same sequence of character


i will put the same excel file with much lessa data so coul be easier to understand

The table, as you see is fixed it is a schema ti undertsand how value are related to each other
I wrote on top of each column the contition it asks to be "activated
"
Now, for example, the column F 003000 to be activated needs 3X
That means that among all the input row these row are needed
row 11 003 2
row 12 003 2
row 65 021 1

The columns H 005000 needs 1X and at least 1A
that means that these row should be given for this column to be activated

row 65 021 1
and at least one row among these
row 62 019 3
row 80 026 1
row 91 030 2
row 92 030 2


So if the operator will give as input
row 11 row 65 and row 62
the program should activate the column H 005000

Only this column match the criteria needed,
if the input would have been
row 11 row 12 row 65 and row 62
the column F003000 and H005000
would be activated

This basically the routine to build based on those data in the excel file
 

Attachments

  • test excel short.zip
    259.1 KB · Views: 83
Last edited:

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 04:53
Joined
Feb 28, 2001
Messages
27,001
each row it is not random. each row is fixed

The column rules in the aggregate are fixed. The column rules for each independent column vary. There is where the APPARENT randomness comes in - when comparing one "event" rule vs. another.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 17:53
Joined
May 7, 2009
Messages
19,175
Now, for example, the column F 003000 to be activated needs 3X
which rows are they? there are 7 X on your "test excel.xls"
 

stefanocps

Registered User.
Local time
Today, 10:53
Joined
Jan 31, 2019
Messages
153
which rows are they? there are 7 X on your "test excel.xls"
are you talking about my first excel or latest?
in the lates called test excel short there for column 003 000 there are 3X
Look at it, is simplified, i cut rows and columns for a better undertsanding
 

stefanocps

Registered User.
Local time
Today, 10:53
Joined
Jan 31, 2019
Messages
153
The column rules in the aggregate are fixed. The column rules for each independent column vary. There is where the APPARENT randomness comes in - when comparing one "event" rule vs. another.
sorry i am afraid i don 't understand what you said 🙁
 

stefanocps

Registered User.
Local time
Today, 10:53
Joined
Jan 31, 2019
Messages
153
sorry about, i though i posted it but i find out not
so i post the excel file which i simplified and this refer to this post
i copy/paste it again for better understanding

each row it is not random. each row is fixed
the row I001
will be all the time the same sequence of character


i will put the same excel file with much lessa data so coul be easier to understand

The table, as you see is fixed it is a schema ti undertsand how value are related to each other
I wrote on top of each column the contition it asks to be "activated
"
Now, for example, the column F 003000 to be activated needs 3X
That means that among all the input row these row are needed
row 11 003 2
row 12 003 2
row 65 021 1

The columns H 005000 needs 1X and at least 1A
that means that these row should be given for this column to be activated

row 65 021 1
and at least one row among these
row 62 019 3
row 80 026 1
row 91 030 2
row 92 030 2


So if the operator will give as input
row 11 row 65 and row 62
the program should activate the column H 005000

Only this column match the criteria needed,
if the input would have been
row 11 row 12 row 65 and row 62
the column F003000 and H005000
would be activated

This basically the routine to build based on those data in the excel file
 

Attachments

  • test excel short.zip
    259.1 KB · Views: 90

vhung

Member
Local time
Today, 02:53
Joined
Jul 8, 2020
Messages
235
what i will input are those string, the row ones
as in the previous image, for example i input the
I001 string
I001 string it is an one row array of character
View attachment 83425

suppose that we have 10 column the string will contain 10 characters (i consider character also the blank space)
so I001 will looks like XX AB XABA
Charactetrs might be NO,X,A,B,C...

Now i add another input string
View attachment 83426

As you can see, the columns start to be populated
The aim is to see what column meet the condition to be considered, good, or activated,,say as you like. The columns that meet critera will be taken to a further process

Criteria for column to be activated are
001000 1X A
002000 1X
003000 8X
and so on
That means that the column 001000 to be considered activated must have one X and at lest one A, when checking the input row
In this case the column 001000 has got only one X, and it is not activated as it would require at least an A also
But the column 002000 is activated as it contains one X and one A, and to be activated it requires only one X

So this is the game. Consider that i normally will input around 15..20 strings (there should be around 150 input strings prepared)
And the column are around 200

So you see the table is quite static, data are fixed, but the differnt combinations of input string might activate some columns or others


i say iy again..the data i used in this example are different from the ones in the excel table..tht is the original
hello: stefanocps;
seems you have already the desire of your spreadsheet data
as long as you the excel file, you could always upload to msaccess
then you have to assign your field name is it the number code or the text info "anyway text could be added to your report"
if access table is made with your data, it is time for you to make Forms either Single, Datasheet or SplitForm
after that according to your X and A coding supply Formula or Codes based on your desired output or result...
you have to begin the basic, create table, create form, create report, then evaluate your process if meets you goal then proceed...
make a first step...
hope it helps...
 

Users who are viewing this thread

Top Bottom