Run Query By Group without Row lines (1 Viewer)

[alayash03]

Hello,
I would like to run query by group Order ID.

Order ID	Order Details ID	Invoice Code	Product ID	Cost Price	Quantity	Sales Price	Discount Prct	Discount Amount	VAT Prct	VAT Amount	Total Amount
4​	1​	INV1	Honor 8x	$10.00​	1​	$15.00​	0.00%​	$0.00​	0.00%​	$0.00​	£15.00​
​	2​	INV2	Honor 9x	$15.00​	1​	$20.00​	0.00%​	$0.00​	0.00%​	$0.00​	£20.00​
					2​						£35.00​

You see above Order ID =4, Order Details ID : 1 & 2. And I don't want between Order Details ID LINE

Order ID	Order Details ID	Invoice Code	Product ID	Cost Price	Quantity	Sales Price	Discount Prct	Discount Amount	VAT Prct	VAT Amount	Total Amount
4​	1 2​	INV1 INV2	Honor 8x Honor 9x	$10.00 $15.00​	1 1​	$15.00 $20.00​	0.00% 0.00%​	$0.00 $0.00​	0.00% 0.00%​	$0.00 $0.00​	£15.00 £20.00​
				35	2		0	0	0	0	£35.00​

How can display this in the Query and report page ?

 

[arnelgp]

you can try to remove the Border Line (Border Style = Transparent) of the textboxes in design view.

 

[alayash03]

you can try to remove the Border Line (Border Style = None) of the textboxes in design view.

Thank you very much for your reply...
I tried it, If I put NONE then all border will NONE.
I want each order Numbers.

I show here Only One Order number. There I have 29 Orders

 

[alayash03]

you can try to remove the Border Line (Border Style = Transparent) of the textboxes in design view.

6-7 months ago I see in google somewhere that I dont remember. This type of work.. Today many times and Many ways I searching but can't reach..

 

[Gasman]

6-7 months ago I see in google somewhere that I dont remember. This type of work.. Today many times and Many ways I searching but can't reach..

That is what bookmarks are for?
Play around with the gridline settings. Only make solid if end of group.
Have a look here https://www.google.com/search?q=set...CBNGAHiAwQgQRgA4gMEIEYYAYgGAQ&sclient=gws-wiz

 

[alayash03]

That is what bookmarks are for?

Wa Allah, this is mistake... I do not do it.

 

[Gasman]

Also search this site.

How to create a report with grid lines?

Hi, In my first steps working with Access I feel unable to find out how can I create a report that shows the data (records from a Clients Table - Name, Phone, e-mail fields-) in a "spreadsheet like" format with gridlines. Can anyone help me on this? Thanks

www.access-programmers.co.uk

 

[arnelgp]

when i set the Textbox border to Transparent, the "Totals" will not align since it has border on them.
so i re-instate the border and make the color white.

 

[Gasman]

when i set the Textbox border to Transparent, the "Totals" will not align since it has border on them.
so i re-instate the border and make the color white.

You would make that last DB 14 wouldn't you?
I was able to open your first DB, but not the last.

 

[alayash03]

when i set the Textbox border to Transparent, the "Totals" will not align since it has border on them.
so i re-instate the border and make the color white.

Thank you for report
Actually. I want Query mainly. Every time print much cost. and waste papers.
If I run query then see the Order by group. ON SECREEN a make purchase for customer. Make problems line only.

 

[alayash03]

You would make that last DB 14 wouldn't you?
I was able to open your first DB, but not the last.

You talking about previous thread dB ?

 

[arnelgp]

you don't need to "Print" the report to the Printer, you can just view it.

 

[alayash03]

you don't need to "Print" the report to the Printer, you can just view it.

Order Parcel arrange or Deliver Man can't possible to View all. Order number to tracking and Make parcel.
Your advice also I noted. I can make each order report by criteria.

Wait for some can give advice for query view...

 

[Gasman]

You talking about previous thread dB ?

No, arnel uploaded a second DB, but that needs 14 or later. I only have 12. The first DB he uploaded, I was able to open fine.

 

[Gasman]

Wait for some can give advice for query view...

I cannot see that happening TBH.