Three Diffrent Query Results On One Label Follow
I am having a problem trying to get three diffrent query results to print on one label
I dont know what i am doing wrong. Is it even possible?
Attached are the pictures of what i have done so far and the results
[b]Pic 1.[/b] The Layout of the label i am creating.
[b]Pic 2.[/b] The database joins i made.
[b]Pic 3[/b]. The query i made.
[b]Pic 4.[/b] The SQL Bar Tender generated.
[b]Pic 5.[/b] The prompts i have setup.
[b]Pic 6, 7 & 8[/b]. Result when i do a print preview. [i](All three product codes and descriptions are the same on each label)
[/i]Whats happening is instead of the results printing on one label
Its printing 3 labels instead of just one label
Can someone please help me
I don't know how to fix it.
Do i need to do a custom SQL query? or a visual basic script?