Invoicing Problems

[tkd1987]

Hello,
i have made an invoice from a order form,

i would like everything that has been ordered at the same time to appear on the one invoice, where as at the moment each item appears on seperate pages.

Many thanks to any help give on this topic

Aaron

ps the attachment shows what i have so far.

 

[aleb]

Check if you placed the details instead of details section some other place

 

[tkd1987]

Thanks for the reply Aleb but i am sorry i do not understand what you mean?

 

[reclusivemonkey]

Each item should be identifiable by invoice number. You can then group your report by invoice number, and all the items should appear in the items sections. This is provided that you have correctly normalised your database.

 

[aleb]

In the design mode of your report look at the "details" section, make sure that fields for details of the invoice are placed in this section. Also check if you accidently didn't put the page break after the detail field.
Also if you can make a print screen of your report in design mode it would be easier to see what is done wrong.

 

[tkd1987]

attached as the main report is the top half of the report which shows the top part of the invoice, and the file 2nd is the bottom half which only includes the payment details and footer.

as you can probably tell i am a complete NooB i dont know what you mean by posting the SQL?

how do i view it to post it!

 

[tkd1987]

ok i think it may be because i have an autonumber as my sales id, but i would like it to do by reference numbers, which are created from the date+surname ie 20/1/2006Bannister, this views fine on the form but how do i get it to store in the database from there, so that i can get it to search via that

sorry fgor being such a pain in the ass lol

 

[aleb]

Well I think that ReclusiveMonkey hit the bull eye. Your invoice doesnt bear any invoice number ... I am confused how do you identify one invoice from the other ?
Next ( I will assume that you group your details by Student ID ) in design of you report go to the sorting and grouping, group on student id. select show group header and footer. Now in design view of your report appeared the group header. In the group header place section with identify general information about this invoice ( everything which is between report header of the report and quainty, description, unitprice ......
also place there the column names of the details.
In details section leave only fields ( i see you placed something to expand your detail section to height 16 -remove it.) - quantity,product,unitprice ....

All your "thank you for ... " and fields below should go to the group footer section.
and at page footer will go the field which is already there

 

[tkd1987]

thank you aleb i think i understand that i am going to give it a go now.

the only thing i am not to sure on is the invoice number as it will be an auto number and every item will have a new number.... that how i was confused about grouping things via that.

ps i just realised what you was on about to sort the invoices i use the ref...

 

[tkd1987]

Thanks everyone for that...
i finally went an bought a book Access 2003 Bible, that is helping me on my long journey.

Thanks again, and i will probs b bk for more help in bout 10mins hahaha

 

[reclusivemonkey]

Thats a good idea. I had a copy of the Access '97 Version when I first started. It was very helpful.

 

[Banaticus]

Edit: page wasn't refreshing

 

[tkd1987]

hmmm i no this is in the rong place but its to do with the same thing.

but on my main student form i currently have a button saying sales that takes me to the order form, what i would like is for that button to create a new order, and a combo box next to it to select the reference number for that students orders and when selected it does to it.

i have had a play a currently looking through me book, but if anyone could help would save me alot of time as i have alot to do haha.

thanks again.