Subreport vs queryquestion

I have a form, Customer Orders, and a subform, Customer Order Details. I
have a report based upon a query using information from the form and
subform. My problem is that one of the fields does not contain the
information all of the time. Sometimes it does, sometimes it does not. I
cannot see why it is doing this.

Suggestion has been to create a subreport and have master/child links.

Here is my question. I did not create the first form and subform so I am
not familiar with this procedure. If I create a subreport linked to the
form/subform, will it print every time I print the form/subform? I am not
wanting it to be visible on the form/subform and I do not want it to print
with it - which is why I created a query/report separate from it.

Thanks for your assistance.

JNana

You stated "If I create a subreport linked to the form/subform, will it
print every time I print the form/subform?"

Forms are generally for screen displaying and editing of records stored in
tables. Reports are for publishing the records to paper (or screen). You
might want to review the Northwind sample database to find out more about
reports and subreports as well as orders and order details.

--
Duane Hookom
MS Access MVP

"JNana" wrote in message
...
I have a form, Customer Orders, and a subform, Customer Order Details. I
have a report based upon a query using information from the form and
subform. My problem is that one of the fields does not contain the
information all of the time. Sometimes it does, sometimes it does not. I
cannot see why it is doing this.

Suggestion has been to create a subreport and have master/child links.

Here is my question. I did not create the first form and subform so I am
not familiar with this procedure. If I create a subreport linked to the
form/subform, will it print every time I print the form/subform? I am not
wanting it to be visible on the form/subform and I do not want it to print
with it - which is why I created a query/report separate from it.

Thanks for your assistance.

JNana

Thank you for your response. I will look into the sample database.

However, I still am questioning "If I create a subreport linked to the
form/subform, will it print every time I print the form/subform?" Let me
explain further. I first enter my information into the orders/order details
forms from which I generate an invoice. I am also wanting to generate a
Bill of Lading and a Packing List from my orders/order details. I have
created reports from this information; however, my "Notes" field does not
always capture the information that was input. At that point it was
suggested that I use a subreport.

I am listing the SQL below. If you have an opportunity, will you take a
look at this and see if you can determine why the "Notes" field is not
working all of the time.



SELECT Orders.*, [Order Details].OrderDetailID, [Order Details].ProductID,
Products.ProductCode, [Order Details].Quantity, [Order Details].UnitPrice,
Customers.CompanyName, Customers.ContactFirstName,
Customers.ContactLastName, Customers.BillingAddress, Customers.City,
Customers.StateOrProvince, Customers.PostalCode,
Customers.[Country/Region],
Customers.PhoneNumber, Customers.PONumber, Customers.ContactFirstName & "
"
& Customers.ContactLastName AS [Contact Name], [Shipping
Methods].ShippingMethod, Products.ProductName, [Order Details].LineItem,
[Order Details].SerialNum, Customers.ControlNum, Contracts.ContractNum,
Dealer.DealerName, [Order Details].Discount, [Order Details].Notes
FROM (Dealer RIGHT JOIN (Customers RIGHT JOIN ([Shipping Methods] RIGHT
JOIN
(Employees RIGHT JOIN Orders ON Employees.EmployeeID = Orders.EmployeeID)
ON
[Shipping Methods].ShippingMethodID = Orders.ShippingMethodID) ON
Customers.CustomerID = Orders.CustomerID) ON Dealer.DealerID =
Orders.DealerID) RIGHT JOIN ((Contracts INNER JOIN Products ON
Contracts.ContractID = Products.ContractID) INNER JOIN [Order Details] ON
Products.ProductID = [Order Details].ProductID) ON Orders.OrderID = [Order
Details].OrderID
ORDER BY [Order Details].LineItem;



Thanks in advance.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
You stated "If I create a subreport linked to the form/subform, will it
print every time I print the form/subform?"

Forms are generally for screen displaying and editing of records stored in
tables. Reports are for publishing the records to paper (or screen). You
might want to review the Northwind sample database to find out more about
reports and subreports as well as orders and order details.

--
Duane Hookom
MS Access MVP

"JNana" wrote in message
...
I have a form, Customer Orders, and a subform, Customer Order Details. I
have a report based upon a query using information from the form and
subform. My problem is that one of the fields does not contain the
information all of the time. Sometimes it does, sometimes it does not.
I
cannot see why it is doing this.

Suggestion has been to create a subreport and have master/child links.

Here is my question. I did not create the first form and subform so I
am
not familiar with this procedure. If I create a subreport linked to the
form/subform, will it print every time I print the form/subform? I am
not
wanting it to be visible on the form/subform and I do not want it to
print
with it - which is why I created a query/report separate from it.

Thanks for your assistance.

JNana

Is your base issue the inability to display more than 255 characters from
the memo field? If so, your subreport can display the memo field from a
record source that includes the field you need for linking to the main
report.

--
Duane Hookom
MS Access MVP

"JNana" wrote in message
...
Thank you for your response. I will look into the sample database.

However, I still am questioning "If I create a subreport linked to the
form/subform, will it print every time I print the form/subform?" Let me
explain further. I first enter my information into the orders/order
details
forms from which I generate an invoice. I am also wanting to generate a
Bill of Lading and a Packing List from my orders/order details. I have
created reports from this information; however, my "Notes" field does not
always capture the information that was input. At that point it was
suggested that I use a subreport.

I am listing the SQL below. If you have an opportunity, will you take a
look at this and see if you can determine why the "Notes" field is not
working all of the time.



SELECT Orders.*, [Order Details].OrderDetailID, [Order Details].ProductID,
Products.ProductCode, [Order Details].Quantity, [Order
Details].UnitPrice,
Customers.CompanyName, Customers.ContactFirstName,
Customers.ContactLastName, Customers.BillingAddress, Customers.City,
Customers.StateOrProvince, Customers.PostalCode,
Customers.[Country/Region],
Customers.PhoneNumber, Customers.PONumber, Customers.ContactFirstName & "
"
& Customers.ContactLastName AS [Contact Name], [Shipping
Methods].ShippingMethod, Products.ProductName, [Order Details].LineItem,
[Order Details].SerialNum, Customers.ControlNum, Contracts.ContractNum,
Dealer.DealerName, [Order Details].Discount, [Order Details].Notes
FROM (Dealer RIGHT JOIN (Customers RIGHT JOIN ([Shipping Methods] RIGHT
JOIN
(Employees RIGHT JOIN Orders ON Employees.EmployeeID = Orders.EmployeeID)
ON
[Shipping Methods].ShippingMethodID = Orders.ShippingMethodID) ON
Customers.CustomerID = Orders.CustomerID) ON Dealer.DealerID =
Orders.DealerID) RIGHT JOIN ((Contracts INNER JOIN Products ON
Contracts.ContractID = Products.ContractID) INNER JOIN [Order Details] ON
Products.ProductID = [Order Details].ProductID) ON Orders.OrderID =
[Order
Details].OrderID
ORDER BY [Order Details].LineItem;



Thanks in advance.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
You stated "If I create a subreport linked to the form/subform, will it
print every time I print the form/subform?"

Forms are generally for screen displaying and editing of records stored
in
tables. Reports are for publishing the records to paper (or screen). You
might want to review the Northwind sample database to find out more about
reports and subreports as well as orders and order details.

--
Duane Hookom
MS Access MVP

"JNana" wrote in message
...
I have a form, Customer Orders, and a subform, Customer Order Details.
I
have a report based upon a query using information from the form and
subform. My problem is that one of the fields does not contain the
information all of the time. Sometimes it does, sometimes it does not.
I
cannot see why it is doing this.

Suggestion has been to create a subreport and have master/child links.

Here is my question. I did not create the first form and subform so I
am
not familiar with this procedure. If I create a subreport linked to
the
form/subform, will it print every time I print the form/subform? I am
not
wanting it to be visible on the form/subform and I do not want it to
print
with it - which is why I created a query/report separate from it.

Thanks for your assistance.

JNana

I really want a separate report for the Packing List and the Bill of Lading.
The notes from the order details is a field on each of these reports.
Information entered into that field on the order details form SHOULD be
visible and print on these 2 reports. Only some of the time is this
happening. I do not see anything different in the way the information was
input on the order details form.

If I can get the notes information to "pull forward" to these reports, that
will solve my problem.
It is not the inability to display more than 255 characters. It doesn't
display with as few as 10 some of the time, and then does display other
times.
Thanks.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Is your base issue the inability to display more than 255 characters from
the memo field? If so, your subreport can display the memo field from a
record source that includes the field you need for linking to the main
report.

--
Duane Hookom
MS Access MVP

"JNana" wrote in message
...
Thank you for your response. I will look into the sample database.

However, I still am questioning "If I create a subreport linked to
the
form/subform, will it print every time I print the form/subform?" Let
me
explain further. I first enter my information into the orders/order
details
forms from which I generate an invoice. I am also wanting to generate a
Bill of Lading and a Packing List from my orders/order details. I have
created reports from this information; however, my "Notes" field does
not
always capture the information that was input. At that point it was
suggested that I use a subreport.

I am listing the SQL below. If you have an opportunity, will you take a
look at this and see if you can determine why the "Notes" field is not
working all of the time.



SELECT Orders.*, [Order Details].OrderDetailID, [Order
Details].ProductID,
Products.ProductCode, [Order Details].Quantity, [Order
Details].UnitPrice,
Customers.CompanyName, Customers.ContactFirstName,
Customers.ContactLastName, Customers.BillingAddress, Customers.City,
Customers.StateOrProvince, Customers.PostalCode,
Customers.[Country/Region],
Customers.PhoneNumber, Customers.PONumber, Customers.ContactFirstName &
"
"
& Customers.ContactLastName AS [Contact Name], [Shipping
Methods].ShippingMethod, Products.ProductName, [Order
Details].LineItem,
[Order Details].SerialNum, Customers.ControlNum, Contracts.ContractNum,
Dealer.DealerName, [Order Details].Discount, [Order Details].Notes
FROM (Dealer RIGHT JOIN (Customers RIGHT JOIN ([Shipping Methods] RIGHT
JOIN
(Employees RIGHT JOIN Orders ON Employees.EmployeeID =
Orders.EmployeeID)
ON
[Shipping Methods].ShippingMethodID = Orders.ShippingMethodID) ON
Customers.CustomerID = Orders.CustomerID) ON Dealer.DealerID =
Orders.DealerID) RIGHT JOIN ((Contracts INNER JOIN Products ON
Contracts.ContractID = Products.ContractID) INNER JOIN [Order Details]
ON
Products.ProductID = [Order Details].ProductID) ON Orders.OrderID =
[Order
Details].OrderID
ORDER BY [Order Details].LineItem;



Thanks in advance.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
You stated "If I create a subreport linked to the form/subform, will it
print every time I print the form/subform?"

Forms are generally for screen displaying and editing of records stored
in
tables. Reports are for publishing the records to paper (or screen).
You
might want to review the Northwind sample database to find out more
about
reports and subreports as well as orders and order details.

--
Duane Hookom
MS Access MVP

"JNana" wrote in message
...
I have a form, Customer Orders, and a subform, Customer Order Details.
I
have a report based upon a query using information from the form and
subform. My problem is that one of the fields does not contain the
information all of the time. Sometimes it does, sometimes it does
not.
I
cannot see why it is doing this.

Suggestion has been to create a subreport and have master/child
links.

Here is my question. I did not create the first form and subform so
I
am
not familiar with this procedure. If I create a subreport linked to
the
form/subform, will it print every time I print the form/subform? I
am
not
wanting it to be visible on the form/subform and I do not want it to
print
with it - which is why I created a query/report separate from it.

Thanks for your assistance.

JNana

Is the information in the field being copied and pasted from another source?

--
Duane Hookom
MS Access MVP

"JNana" wrote in message
...
I really want a separate report for the Packing List and the Bill of
Lading.
The notes from the order details is a field on each of these reports.
Information entered into that field on the order details form SHOULD be
visible and print on these 2 reports. Only some of the time is this
happening. I do not see anything different in the way the information was
input on the order details form.

If I can get the notes information to "pull forward" to these reports,
that
will solve my problem.
It is not the inability to display more than 255 characters. It doesn't
display with as few as 10 some of the time, and then does display other
times.
Thanks.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Is your base issue the inability to display more than 255 characters from
the memo field? If so, your subreport can display the memo field from a
record source that includes the field you need for linking to the main
report.

--
Duane Hookom
MS Access MVP

"JNana" wrote in message
...
Thank you for your response. I will look into the sample database.

However, I still am questioning "If I create a subreport linked to
the
form/subform, will it print every time I print the form/subform?" Let
me
explain further. I first enter my information into the orders/order
details
forms from which I generate an invoice. I am also wanting to generate
a
Bill of Lading and a Packing List from my orders/order details. I have
created reports from this information; however, my "Notes" field does
not
always capture the information that was input. At that point it was
suggested that I use a subreport.

I am listing the SQL below. If you have an opportunity, will you take
a
look at this and see if you can determine why the "Notes" field is not
working all of the time.



SELECT Orders.*, [Order Details].OrderDetailID, [Order
Details].ProductID,
Products.ProductCode, [Order Details].Quantity, [Order
Details].UnitPrice,
Customers.CompanyName, Customers.ContactFirstName,
Customers.ContactLastName, Customers.BillingAddress, Customers.City,
Customers.StateOrProvince, Customers.PostalCode,
Customers.[Country/Region],
Customers.PhoneNumber, Customers.PONumber, Customers.ContactFirstName
&
"
"
& Customers.ContactLastName AS [Contact Name], [Shipping
Methods].ShippingMethod, Products.ProductName, [Order
Details].LineItem,
[Order Details].SerialNum, Customers.ControlNum,
Contracts.ContractNum,
Dealer.DealerName, [Order Details].Discount, [Order Details].Notes
FROM (Dealer RIGHT JOIN (Customers RIGHT JOIN ([Shipping Methods]
RIGHT
JOIN
(Employees RIGHT JOIN Orders ON Employees.EmployeeID =
Orders.EmployeeID)
ON
[Shipping Methods].ShippingMethodID = Orders.ShippingMethodID) ON
Customers.CustomerID = Orders.CustomerID) ON Dealer.DealerID =
Orders.DealerID) RIGHT JOIN ((Contracts INNER JOIN Products ON
Contracts.ContractID = Products.ContractID) INNER JOIN [Order Details]
ON
Products.ProductID = [Order Details].ProductID) ON Orders.OrderID =
[Order
Details].OrderID
ORDER BY [Order Details].LineItem;



Thanks in advance.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
You stated "If I create a subreport linked to the form/subform, will
it
print every time I print the form/subform?"

Forms are generally for screen displaying and editing of records
stored
in
tables. Reports are for publishing the records to paper (or screen).
You
might want to review the Northwind sample database to find out more
about
reports and subreports as well as orders and order details.

--
Duane Hookom
MS Access MVP

"JNana" wrote in message
...
I have a form, Customer Orders, and a subform, Customer Order
Details.
I
have a report based upon a query using information from the form and
subform. My problem is that one of the fields does not contain the
information all of the time. Sometimes it does, sometimes it does
not.
I
cannot see why it is doing this.

Suggestion has been to create a subreport and have master/child
links.

Here is my question. I did not create the first form and subform so
I
am
not familiar with this procedure. If I create a subreport linked to
the
form/subform, will it print every time I print the form/subform? I
am
not
wanting it to be visible on the form/subform and I do not want it to
print
with it - which is why I created a query/report separate from it.

Thanks for your assistance.

JNana

No. I am entering the information in the order details form.

I created a query - which runs without a problem. Then created the a Bill
of Lading report. The Packing List Report is created from the report,
"Invoice". The information displays on the query and the invoice without
discrepancies.

The 2 reports do not always display the information. ??


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Is the information in the field being copied and pasted from another
source?

--
Duane Hookom
MS Access MVP

"JNana" wrote in message
...
I really want a separate report for the Packing List and the Bill of
Lading.
The notes from the order details is a field on each of these reports.
Information entered into that field on the order details form SHOULD be
visible and print on these 2 reports. Only some of the time is this
happening. I do not see anything different in the way the information
was
input on the order details form.

If I can get the notes information to "pull forward" to these reports,
that
will solve my problem.
It is not the inability to display more than 255 characters. It doesn't
display with as few as 10 some of the time, and then does display other
times.
Thanks.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Is your base issue the inability to display more than 255 characters
from
the memo field? If so, your subreport can display the memo field from a
record source that includes the field you need for linking to the main
report.

--
Duane Hookom
MS Access MVP

"JNana" wrote in message
...
Thank you for your response. I will look into the sample database.

However, I still am questioning "If I create a subreport linked to
the
form/subform, will it print every time I print the form/subform?"
Let
me
explain further. I first enter my information into the orders/order
details
forms from which I generate an invoice. I am also wanting to
generate
a
Bill of Lading and a Packing List from my orders/order details. I
have
created reports from this information; however, my "Notes" field does
not
always capture the information that was input. At that point it was
suggested that I use a subreport.

I am listing the SQL below. If you have an opportunity, will you
take
a
look at this and see if you can determine why the "Notes" field is
not
working all of the time.



SELECT Orders.*, [Order Details].OrderDetailID, [Order
Details].ProductID,
Products.ProductCode, [Order Details].Quantity, [Order
Details].UnitPrice,
Customers.CompanyName, Customers.ContactFirstName,
Customers.ContactLastName, Customers.BillingAddress, Customers.City,
Customers.StateOrProvince, Customers.PostalCode,
Customers.[Country/Region],
Customers.PhoneNumber, Customers.PONumber,
Customers.ContactFirstName
&
"
"
& Customers.ContactLastName AS [Contact Name], [Shipping
Methods].ShippingMethod, Products.ProductName, [Order
Details].LineItem,
[Order Details].SerialNum, Customers.ControlNum,
Contracts.ContractNum,
Dealer.DealerName, [Order Details].Discount, [Order Details].Notes
FROM (Dealer RIGHT JOIN (Customers RIGHT JOIN ([Shipping Methods]
RIGHT
JOIN
(Employees RIGHT JOIN Orders ON Employees.EmployeeID =
Orders.EmployeeID)
ON
[Shipping Methods].ShippingMethodID = Orders.ShippingMethodID) ON
Customers.CustomerID = Orders.CustomerID) ON Dealer.DealerID =
Orders.DealerID) RIGHT JOIN ((Contracts INNER JOIN Products ON
Contracts.ContractID = Products.ContractID) INNER JOIN [Order
Details]
ON
Products.ProductID = [Order Details].ProductID) ON Orders.OrderID =
[Order
Details].OrderID
ORDER BY [Order Details].LineItem;



Thanks in advance.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
You stated "If I create a subreport linked to the form/subform, will
it
print every time I print the form/subform?"

Forms are generally for screen displaying and editing of records
stored
in
tables. Reports are for publishing the records to paper (or screen).
You
might want to review the Northwind sample database to find out more
about
reports and subreports as well as orders and order details.

--
Duane Hookom
MS Access MVP

"JNana" wrote in message
...
I have a form, Customer Orders, and a subform, Customer Order
Details.
I
have a report based upon a query using information from the form
and
subform. My problem is that one of the fields does not contain
the
information all of the time. Sometimes it does, sometimes it does
not.
I
cannot see why it is doing this.

Suggestion has been to create a subreport and have master/child
links.

Here is my question. I did not create the first form and subform
so
I
am
not familiar with this procedure. If I create a subreport linked
to
the
form/subform, will it print every time I print the form/subform?
I
am
not
wanting it to be visible on the form/subform and I do not want it
to
print
with it - which is why I created a query/report separate from it.

Thanks for your assistance.

JNana

Are the controls set to allow growing?
Is the number of characters truncating at a particular place?
What section of the report are the controls in?

--
Duane Hookom
MS Access MVP

"JNana" wrote in message
...
No. I am entering the information in the order details form.

I created a query - which runs without a problem. Then created the a
Bill
of Lading report. The Packing List Report is created from the report,
"Invoice". The information displays on the query and the invoice without
discrepancies.

The 2 reports do not always display the information. ??


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Is the information in the field being copied and pasted from another
source?

--
Duane Hookom
MS Access MVP

"JNana" wrote in message
...
I really want a separate report for the Packing List and the Bill of
Lading.
The notes from the order details is a field on each of these reports.
Information entered into that field on the order details form SHOULD be
visible and print on these 2 reports. Only some of the time is this
happening. I do not see anything different in the way the information
was
input on the order details form.

If I can get the notes information to "pull forward" to these reports,
that
will solve my problem.
It is not the inability to display more than 255 characters. It
doesn't
display with as few as 10 some of the time, and then does display other
times.
Thanks.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Is your base issue the inability to display more than 255 characters
from
the memo field? If so, your subreport can display the memo field from
a
record source that includes the field you need for linking to the main
report.

--
Duane Hookom
MS Access MVP

"JNana" wrote in message
...
Thank you for your response. I will look into the sample database.

However, I still am questioning "If I create a subreport linked
to
the
form/subform, will it print every time I print the form/subform?"
Let
me
explain further. I first enter my information into the orders/order
details
forms from which I generate an invoice. I am also wanting to
generate
a
Bill of Lading and a Packing List from my orders/order details. I
have
created reports from this information; however, my "Notes" field
does
not
always capture the information that was input. At that point it was
suggested that I use a subreport.

I am listing the SQL below. If you have an opportunity, will you
take
a
look at this and see if you can determine why the "Notes" field is
not
working all of the time.



SELECT Orders.*, [Order Details].OrderDetailID, [Order
Details].ProductID,
Products.ProductCode, [Order Details].Quantity, [Order
Details].UnitPrice,
Customers.CompanyName, Customers.ContactFirstName,
Customers.ContactLastName, Customers.BillingAddress,
Customers.City,
Customers.StateOrProvince, Customers.PostalCode,
Customers.[Country/Region],
Customers.PhoneNumber, Customers.PONumber,
Customers.ContactFirstName
&
"
"
& Customers.ContactLastName AS [Contact Name], [Shipping
Methods].ShippingMethod, Products.ProductName, [Order
Details].LineItem,
[Order Details].SerialNum, Customers.ControlNum,
Contracts.ContractNum,
Dealer.DealerName, [Order Details].Discount, [Order Details].Notes
FROM (Dealer RIGHT JOIN (Customers RIGHT JOIN ([Shipping Methods]
RIGHT
JOIN
(Employees RIGHT JOIN Orders ON Employees.EmployeeID =
Orders.EmployeeID)
ON
[Shipping Methods].ShippingMethodID = Orders.ShippingMethodID) ON
Customers.CustomerID = Orders.CustomerID) ON Dealer.DealerID =
Orders.DealerID) RIGHT JOIN ((Contracts INNER JOIN Products ON
Contracts.ContractID = Products.ContractID) INNER JOIN [Order
Details]
ON
Products.ProductID = [Order Details].ProductID) ON Orders.OrderID =
[Order
Details].OrderID
ORDER BY [Order Details].LineItem;



Thanks in advance.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
You stated "If I create a subreport linked to the form/subform,
will
it
print every time I print the form/subform?"

Forms are generally for screen displaying and editing of records
stored
in
tables. Reports are for publishing the records to paper (or
screen).
You
might want to review the Northwind sample database to find out more
about
reports and subreports as well as orders and order details.

--
Duane Hookom
MS Access MVP

"JNana" wrote in message
...
I have a form, Customer Orders, and a subform, Customer Order
Details.
I
have a report based upon a query using information from the form
and
subform. My problem is that one of the fields does not contain
the
information all of the time. Sometimes it does, sometimes it
does
not.
I
cannot see why it is doing this.

Suggestion has been to create a subreport and have master/child
links.

Here is my question. I did not create the first form and subform
so
I
am
not familiar with this procedure. If I create a subreport linked
to
the
form/subform, will it print every time I print the form/subform?
I
am
not
wanting it to be visible on the form/subform and I do not want it
to
print
with it - which is why I created a query/report separate from it.

Thanks for your assistance.

JNana

Yes they are set to allow growing.
Truncating at a particular place? I am not certain of what you mean. They
are not being cut off; i.e. too many characters. They are not being copied
and replaced.
Controls are in page footer section.



"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Are the controls set to allow growing?
Is the number of characters truncating at a particular place?
What section of the report are the controls in?

--
Duane Hookom
MS Access MVP

"JNana" wrote in message
...
No. I am entering the information in the order details form.

I created a query - which runs without a problem. Then created the a
Bill
of Lading report. The Packing List Report is created from the report,
"Invoice". The information displays on the query and the invoice
without
discrepancies.

The 2 reports do not always display the information. ??


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Is the information in the field being copied and pasted from another
source?

--
Duane Hookom
MS Access MVP

"JNana" wrote in message
...
I really want a separate report for the Packing List and the Bill of
Lading.
The notes from the order details is a field on each of these reports.
Information entered into that field on the order details form SHOULD
be
visible and print on these 2 reports. Only some of the time is this
happening. I do not see anything different in the way the
information
was
input on the order details form.

If I can get the notes information to "pull forward" to these
reports,
that
will solve my problem.
It is not the inability to display more than 255 characters. It
doesn't
display with as few as 10 some of the time, and then does display
other
times.
Thanks.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Is your base issue the inability to display more than 255 characters
from
the memo field? If so, your subreport can display the memo field
from
a
record source that includes the field you need for linking to the
main
report.

--
Duane Hookom
MS Access MVP

"JNana" wrote in message
...
Thank you for your response. I will look into the sample
database.

However, I still am questioning "If I create a subreport linked
to
the
form/subform, will it print every time I print the form/subform?"
Let
me
explain further. I first enter my information into the
orders/order
details
forms from which I generate an invoice. I am also wanting to
generate
a
Bill of Lading and a Packing List from my orders/order details. I
have
created reports from this information; however, my "Notes" field
does
not
always capture the information that was input. At that point it
was
suggested that I use a subreport.

I am listing the SQL below. If you have an opportunity, will you
take
a
look at this and see if you can determine why the "Notes" field is
not
working all of the time.



SELECT Orders.*, [Order Details].OrderDetailID, [Order
Details].ProductID,
Products.ProductCode, [Order Details].Quantity, [Order
Details].UnitPrice,
Customers.CompanyName, Customers.ContactFirstName,
Customers.ContactLastName, Customers.BillingAddress,
Customers.City,
Customers.StateOrProvince, Customers.PostalCode,
Customers.[Country/Region],
Customers.PhoneNumber, Customers.PONumber,
Customers.ContactFirstName
&
"
"
& Customers.ContactLastName AS [Contact Name], [Shipping
Methods].ShippingMethod, Products.ProductName, [Order
Details].LineItem,
[Order Details].SerialNum, Customers.ControlNum,
Contracts.ContractNum,
Dealer.DealerName, [Order Details].Discount, [Order
Details].Notes
FROM (Dealer RIGHT JOIN (Customers RIGHT JOIN ([Shipping Methods]
RIGHT
JOIN
(Employees RIGHT JOIN Orders ON Employees.EmployeeID =
Orders.EmployeeID)
ON
[Shipping Methods].ShippingMethodID = Orders.ShippingMethodID) ON
Customers.CustomerID = Orders.CustomerID) ON Dealer.DealerID =
Orders.DealerID) RIGHT JOIN ((Contracts INNER JOIN Products ON
Contracts.ContractID = Products.ContractID) INNER JOIN [Order
Details]
ON
Products.ProductID = [Order Details].ProductID) ON Orders.OrderID
=
[Order
Details].OrderID
ORDER BY [Order Details].LineItem;



Thanks in advance.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
You stated "If I create a subreport linked to the form/subform,
will
it
print every time I print the form/subform?"

Forms are generally for screen displaying and editing of records
stored
in
tables. Reports are for publishing the records to paper (or
screen).
You
might want to review the Northwind sample database to find out
more
about
reports and subreports as well as orders and order details.

--
Duane Hookom
MS Access MVP

"JNana" wrote in message
...
I have a form, Customer Orders, and a subform, Customer Order
Details.
I
have a report based upon a query using information from the
form
and
subform. My problem is that one of the fields does not contain
the
information all of the time. Sometimes it does, sometimes it
does
not.
I
cannot see why it is doing this.

Suggestion has been to create a subreport and have master/child
links.

Here is my question. I did not create the first form and
subform
so
I
am
not familiar with this procedure. If I create a subreport
linked
to
the
form/subform, will it print every time I print the
form/subform?
I
am
not
wanting it to be visible on the form/subform and I do not want
it
to
print
with it - which is why I created a query/report separate from
it.

Thanks for your assistance.

JNana

After responding below, I moved the note section up to the detail section.
It does work in that section. I still have a problem though. There is a
large gap between each line item -- IF I have no notes. If I have notes, of
course that space is filled with that information. Can I add something that
would input the space for notes ONLY IF I have info in the notes field??

Duane, thank you for your patience and willingness to help me. I am
learning and am most appreciative.

"JNana" wrote in message
...
Yes they are set to allow growing.
Truncating at a particular place? I am not certain of what you mean.
They
are not being cut off; i.e. too many characters. They are not being
copied
and replaced.
Controls are in page footer section.



"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Are the controls set to allow growing?
Is the number of characters truncating at a particular place?
What section of the report are the controls in?

--
Duane Hookom
MS Access MVP

"JNana" wrote in message
...
No. I am entering the information in the order details form.

I created a query - which runs without a problem. Then created the a
Bill
of Lading report. The Packing List Report is created from the report,
"Invoice". The information displays on the query and the invoice
without
discrepancies.

The 2 reports do not always display the information. ??


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Is the information in the field being copied and pasted from another
source?

--
Duane Hookom
MS Access MVP

"JNana" wrote in message
...
I really want a separate report for the Packing List and the Bill of
Lading.
The notes from the order details is a field on each of these
reports.
Information entered into that field on the order details form
SHOULD
be
visible and print on these 2 reports. Only some of the time is
this
happening. I do not see anything different in the way the
information
was
input on the order details form.

If I can get the notes information to "pull forward" to these
reports,
that
will solve my problem.
It is not the inability to display more than 255 characters. It
doesn't
display with as few as 10 some of the time, and then does display
other
times.
Thanks.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Is your base issue the inability to display more than 255
characters
from
the memo field? If so, your subreport can display the memo field
from
a
record source that includes the field you need for linking to the
main
report.

--
Duane Hookom
MS Access MVP

"JNana" wrote in message
...
Thank you for your response. I will look into the sample
database.

However, I still am questioning "If I create a subreport
linked
to
the
form/subform, will it print every time I print the
form/subform?"
Let
me
explain further. I first enter my information into the
orders/order
details
forms from which I generate an invoice. I am also wanting to
generate
a
Bill of Lading and a Packing List from my orders/order details.
I
have
created reports from this information; however, my "Notes" field
does
not
always capture the information that was input. At that point it
was
suggested that I use a subreport.

I am listing the SQL below. If you have an opportunity, will
you
take
a
look at this and see if you can determine why the "Notes" field
is
not
working all of the time.



SELECT Orders.*, [Order Details].OrderDetailID, [Order
Details].ProductID,
Products.ProductCode, [Order Details].Quantity, [Order
Details].UnitPrice,
Customers.CompanyName, Customers.ContactFirstName,
Customers.ContactLastName, Customers.BillingAddress,
Customers.City,
Customers.StateOrProvince, Customers.PostalCode,
Customers.[Country/Region],
Customers.PhoneNumber, Customers.PONumber,
Customers.ContactFirstName
&
"
"
& Customers.ContactLastName AS [Contact Name], [Shipping
Methods].ShippingMethod, Products.ProductName, [Order
Details].LineItem,
[Order Details].SerialNum, Customers.ControlNum,
Contracts.ContractNum,
Dealer.DealerName, [Order Details].Discount, [Order
Details].Notes
FROM (Dealer RIGHT JOIN (Customers RIGHT JOIN ([Shipping
Methods]
RIGHT
JOIN
(Employees RIGHT JOIN Orders ON Employees.EmployeeID =
Orders.EmployeeID)
ON
[Shipping Methods].ShippingMethodID = Orders.ShippingMethodID)
ON
Customers.CustomerID = Orders.CustomerID) ON Dealer.DealerID =
Orders.DealerID) RIGHT JOIN ((Contracts INNER JOIN Products ON
Contracts.ContractID = Products.ContractID) INNER JOIN [Order
Details]
ON
Products.ProductID = [Order Details].ProductID) ON
Orders.OrderID
=
[Order
Details].OrderID
ORDER BY [Order Details].LineItem;



Thanks in advance.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
You stated "If I create a subreport linked to the form/subform,
will
it
print every time I print the form/subform?"

Forms are generally for screen displaying and editing of
records
stored
in
tables. Reports are for publishing the records to paper (or
screen).
You
might want to review the Northwind sample database to find out
more
about
reports and subreports as well as orders and order details.

--
Duane Hookom
MS Access MVP

"JNana" wrote in message
...
I have a form, Customer Orders, and a subform, Customer Order
Details.
I
have a report based upon a query using information from the
form
and
subform. My problem is that one of the fields does not
contain
the
information all of the time. Sometimes it does, sometimes it
does
not.
I
cannot see why it is doing this.

Suggestion has been to create a subreport and have
master/child
links.

Here is my question. I did not create the first form and
subform
so
I
am
not familiar with this procedure. If I create a subreport
linked
to
the
form/subform, will it print every time I print the
form/subform?
I
am
not
wanting it to be visible on the form/subform and I do not
want
it
to
print
with it - which is why I created a query/report separate from
it.

Thanks for your assistance.

JNana