Hello everybody!
I have a query that returns:
Description Process Technique Frequency
Sheet 11Ga Krautkramer 10
Master 36x85" Micrometer 15
.
.
.
The application is about checking certain characteristics for parts in manufacturing. If, say, I have 1000 pieces to manufacture, with help from frequency I know after how many produced parts the characteristics check is due. In this case, first and than every 10th and 15th has to have checks performed. What I need is a query from which I can get following report:
Piece no. Description Process Techniqe
1 Sheet 11Ga Krautkramer
Master 36x85" Micrometer
10 Sheet 11Ga Krautkramer
15 Master 36x85" Micrometer
20 Sheet 11Ga Krautkramer
30 Sheet 11Ga Krautkramer
Master 36x85" Micrometer
.
.
.
990 Sheet 11Ga Krautkramer
Master 36x85" Micrometer
1000 Sheet 11Ga Krautkramer
Frequencies and quantity differ from part to part. Also, I would need to be able to enter manufacturing quantity because it's not always 1000.
Thank you!
Marko
I have a query that returns:
Description Process Technique Frequency
Sheet 11Ga Krautkramer 10
Master 36x85" Micrometer 15
.
.
.
The application is about checking certain characteristics for parts in manufacturing. If, say, I have 1000 pieces to manufacture, with help from frequency I know after how many produced parts the characteristics check is due. In this case, first and than every 10th and 15th has to have checks performed. What I need is a query from which I can get following report:
Piece no. Description Process Techniqe
1 Sheet 11Ga Krautkramer
Master 36x85" Micrometer
10 Sheet 11Ga Krautkramer
15 Master 36x85" Micrometer
20 Sheet 11Ga Krautkramer
30 Sheet 11Ga Krautkramer
Master 36x85" Micrometer
.
.
.
990 Sheet 11Ga Krautkramer
Master 36x85" Micrometer
1000 Sheet 11Ga Krautkramer
Frequencies and quantity differ from part to part. Also, I would need to be able to enter manufacturing quantity because it's not always 1000.
Thank you!
Marko