Mr Confused !!!

N

Naveed Pathan

hiiiiii i am so confused about the table design what i want to do can't ;
for example i want two table which all about invoicing such as

TABLE ONE
[INVOICE #]

TABLE TWO

[INVOICE #]

[SNO]

[ITEM]

[PRICE]


SO I WANT TO PRODUCE AN INVOICE LIKE THIS FOR PRINTING BUT I AM CONFUSED HOW
TO DO LIKE THAT


INVOICE # SNO ITEM PRICE

1 1 APPLE 3
2 BANANA 2
3 MANGO 10
4 ORANGE 7
5 CHERRY 4

Note : i don't want to repeat the [invoice] though [SNO] SHOULD BE REPEATED
NO PROBLEM

THANKX
 
F

fredg

hiiiiii i am so confused about the table design what i want to do can't ;
for example i want two table which all about invoicing such as

TABLE ONE
[INVOICE #]

TABLE TWO

[INVOICE #]

[SNO]

[ITEM]

[PRICE]

SO I WANT TO PRODUCE AN INVOICE LIKE THIS FOR PRINTING BUT I AM CONFUSED HOW
TO DO LIKE THAT

INVOICE # SNO ITEM PRICE

1 1 APPLE 3
2 BANANA 2
3 MANGO 10
4 ORANGE 7
5 CHERRY 4

Note : i don't want to repeat the [invoice] though [SNO] SHOULD BE REPEATED
NO PROBLEM

THANKX

Did you try setting the [Invoice] control's Hide Duplicates property
to Yes?
 
N

Naveed Pathan

i am sorry how to do that

thankx
fredg said:
hiiiiii i am so confused about the table design what i want to do can't ;
for example i want two table which all about invoicing such as

TABLE ONE
[INVOICE #]

TABLE TWO

[INVOICE #]

[SNO]

[ITEM]

[PRICE]

SO I WANT TO PRODUCE AN INVOICE LIKE THIS FOR PRINTING BUT I AM CONFUSED HOW
TO DO LIKE THAT

INVOICE # SNO ITEM PRICE

1 1 APPLE 3
2 BANANA 2
3 MANGO 10
4 ORANGE 7
5 CHERRY 4

Note : i don't want to repeat the [invoice] though [SNO] SHOULD BE REPEATED
NO PROBLEM

THANKX

Did you try setting the [Invoice] control's Hide Duplicates property
to Yes?
 
F

fredg

i am sorry how to do that

thankx
fredg said:
hiiiiii i am so confused about the table design what i want to do can't ;
for example i want two table which all about invoicing such as

TABLE ONE
[INVOICE #]

TABLE TWO

[INVOICE #]

[SNO]

[ITEM]

[PRICE]

SO I WANT TO PRODUCE AN INVOICE LIKE THIS FOR PRINTING BUT I AM CONFUSED HOW
TO DO LIKE THAT

INVOICE # SNO ITEM PRICE

1 1 APPLE 3
2 BANANA 2
3 MANGO 10
4 ORANGE 7
5 CHERRY 4

Note : i don't want to repeat the [invoice] though [SNO] SHOULD BE REPEATED
NO PROBLEM

THANKX

Did you try setting the [Invoice] control's Hide Duplicates property
to Yes?

In Design View select the condtol and display it's property sheet.
click on the Format tab.
Set HideDuplicates to Yes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top