Couple of newbie questions

[Awowk]

I will do my best to try to explain my problem. I am very new to Access, and my boss has asked me to create a report that creates invoices for several companies.

He provided me with an SQL dump into Excel, which I have successfully put into report form. I have enclosed a picture of my current layout, and will elaborate in this post.

Right now, I have the report formatted to display 1 invoice per entry, which gives me 27 invoices. It works, but its not what my boss is looking for. I need to have each company with 1 invoice, displaying all entries relevant to that company.

At the top, you can see where it prints out my company name, and relevant information. This is followed by the detination company's information.

When I try to change the layout to display multiple entries on one invoice, I get the following problems:

Problem 1: I have the company name information print out successfully, but when I check the print preview, it only prints out the first company in the excel document, represented by the green square.

The problem I have is that there are 6 different companies, and I need an invoice for each one.

Problem 2: In orange, you can see that I have several pieces of information that are suppose to print out. When I print preview, the information that is printed doesn't correspond with the destination company, but rather all entries in the excel spreadsheet. I need this seperated by corresponding company. Eg. Company 1 has 1 entry, Company 2 has 8 entries. I need 1 invoice for Company 1, and 1 invoice for Company 2 which displays all 8 entries.

Problem 3: In red, I need to calculate the total HST for the respective page. Eg. If there are 4 invoices, each with 5$ HST charge, I need the box in red to add the 4 HST charges, or 5, or 1 etc and display the total.

Problem 4: Similar to problem 3, I need the purple box Amount to equal the total amount on the respective invoice.

I am farmilliar with the basics of Object oriented programming, and basic JAVA, so you can get kind of technical on me and you won't lose me. However, I am still trying to figure out this Access and how to do things with it.

I really appreciate any help you guys can offer. Thank you very much.

[pbaldy]

What section is that top part in? It's cut off. I would expect it to be "Company Header" or something to that effect. In other words, in Sorting and Grouping you would have company listed as a field to be grouped on. The way to get totals would be a textbox with a control source of:

=Sum(Amount)

but it won't work in a page footer. You'd want it in a group footer and/or report footer. See if the attached picture helps.

[Awowk]

It is in the Page Header section.

How do you create sections specific to an entry?

[pbaldy]

The wizard would have asked about it, or, as mentioned, you can also set it in Sorting and Grouping. View/Sorting and Grouping, or on the ribbon in 2007.

[Awowk]

woo it works perfectly now!

Thank you so much for your help

[pbaldy]

Happy to help, and welcome to the site by the way!

[Awowk]

Alright, one last error I am encountering.
The report is doing exactly what its suppose to, grouping invoices by company name, summing the total HST and amount of each invoice and displaying all relevent company information.

The problem I have right now is that there is 1 invoice where 2 entries are combined, even though the company name is completely different.

X Oil Resources
and
Y Energy Ltd

The invoices are combined under X Oil Resources, and I don't know why.
The information between companies is completely different.

Any clue as to why it would do this?
thanks!

[Awowk]

Disregard above question, I had it grouping under the first letter (hurr sorry dumb mistake)

Another question, is there a way to force the grouping to check against full names, instead of checking against x number of letters?

[Awowk]

I'm just going to stop talking now.
Im done, solved again.
Cheers

[pbaldy]

Are you grouping on the name, or some ID field that might be the same? I've never seen the grouping make a mistake like that. Can you post the db?

[pbaldy]

Ah good. Sorry about the post. This is what happens when you start typing and then answer the phone.

[Awowk]

Yeah its what happens when you are a crazy person like me and things like the above make you work through your lunch hour. Then I go and monologue on an MS Access Forum. Go me.

[pbaldy]

LOL! Lunch time here as well.