Help, I would like a report to look like this but I can't work out how

[t5amec]

Hi,

I have created a word doc for an example of the report i want to make, but I don't think that access is capable of doing it.

Can you take a look at my download and tell me if I am wrong, and/or how it could be done.

[

http://bandreview.net/REPORTPREVIEW.doc

]

Cheers



Make Sense? I hope so (-:

 

[THWatson]

t5amec
When I attempted to take a look at what you had posted, but my virus checker stopped it, indicating there was a malicious script.

Thought you should know.

Tom

 

[dhookom]

Sure, it can be done. Your invoice numbers and details would be displayed using a subreport. Without knowing your table structures and relationships it is difficult to get more specific. For instance are all the Order fields in one table? Is the comments field also in the table or could there be multiple comments records per one order record? Do you always need the comments field to display two lines regardless of how much information is in the comments field?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[t5amec]

the tables are as follows
TblOrderEntry
OrderNumberID - AutoNumber - PK
OrderNumber - Text

TblOrderInformation
OrderNumber - Linked To field in OrderNumber
LineID - AutoNumber - PK
Description - Text
Requisition - Text
DeliveryNote - Text
Unit - Text
Rate - Currency
OnHireDate - Date
OffHireDate - Date
CollectionNote - Text
Activity - Text
ECode - Text
Complete - Yes/No
Comments - Memo

TblInvoiceEntry
InvoiceNumberID - AutoNumber - PK
InvoiceNumber - Text

TblInvoiceInformation
OrderNumber - Linked to field in TblInvoiceEntry
Description - Linked to field in TblInvoiceInformation
InvoiceNumber - Text
InvoiceFrom - Date
InvoiceTo - Date

ok, sorry to bore you with that.
the comments could only be altered on TblOrderInformation.

the is no reason why the comments records should be on every order line, i just thought it may make the report look more uniform.
there is no reason why there are two comments lines, mearly other than to give spacing.

Make Sense? I hope so (-:

 

[dhookom]

I am not sure why you have your "...entry" tables. Are both fields in these tables unique? I would place the "...ID" values in the "...Information" tables rather than the "...number" text fields.

I think you can base your main report on tblOrderINformation and then use a subreport in the detail section that contains the Invoice Information.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.