J
JNana
Can anyone direct me in creating some query, etc. to locate a problem that I
am having? I have an Order Entry database. This has been used for
approximately 1 year. The reports in question have been functioning
properly. Now, for some unknown reason, I am not getting all of the
information. All of the fields look the same.
My reports are using the following tables:
Contracts - 3 different contract #s; one or all can be specific to an order.
SIN - each product has a SIN (special item number); each SIN pertains to a
specific contract.
Dealer - company delivering order
Order - summary listing customer name, billto info, orderID, shipdate,total
of order, payments, balance
OrderDetails - line item, productcode, product name,serial number, quantity,
unit price, extended price, notes
Products - items available for sale with description, codes, unit prices,
contract #, SIN #.
My reports are Invoice, Bill of Lading, Packing List, Authorization to
Deliver, and Dealer Daily Delivery Info.
My first problem was that line items 5 and 6 would display on the order
details screen, but would not print on any report. The only way I
temporarily solved this was to remove the Contracts and SIN tables from the
query. I still need this on my reports.
Now, my Dealer Daily Delivery Info report displays for some customers and
does not display for others. Customers prior to my deleting the Contracts
and SIN tables all display and print okay. I did not run this report when
the first problem appeared.
How do I go about searching for the problem? I have looked at each
customer - the info does not appear to be any different. The products look
like they have all the information. My reports are based upon control
number which relates to a specific contract. If it were this relationship
being the problem, why would some of the information be okay and others
not??
The query does the same thing also. I can go to the tables and the
information is there.
I don't understand why this has suddenly appeared and why some display and
others do not.
Thank you in advance for any assistance you give.
JNana
am having? I have an Order Entry database. This has been used for
approximately 1 year. The reports in question have been functioning
properly. Now, for some unknown reason, I am not getting all of the
information. All of the fields look the same.
My reports are using the following tables:
Contracts - 3 different contract #s; one or all can be specific to an order.
SIN - each product has a SIN (special item number); each SIN pertains to a
specific contract.
Dealer - company delivering order
Order - summary listing customer name, billto info, orderID, shipdate,total
of order, payments, balance
OrderDetails - line item, productcode, product name,serial number, quantity,
unit price, extended price, notes
Products - items available for sale with description, codes, unit prices,
contract #, SIN #.
My reports are Invoice, Bill of Lading, Packing List, Authorization to
Deliver, and Dealer Daily Delivery Info.
My first problem was that line items 5 and 6 would display on the order
details screen, but would not print on any report. The only way I
temporarily solved this was to remove the Contracts and SIN tables from the
query. I still need this on my reports.
Now, my Dealer Daily Delivery Info report displays for some customers and
does not display for others. Customers prior to my deleting the Contracts
and SIN tables all display and print okay. I did not run this report when
the first problem appeared.
How do I go about searching for the problem? I have looked at each
customer - the info does not appear to be any different. The products look
like they have all the information. My reports are based upon control
number which relates to a specific contract. If it were this relationship
being the problem, why would some of the information be okay and others
not??
The query does the same thing also. I can go to the tables and the
information is there.
I don't understand why this has suddenly appeared and why some display and
others do not.
Thank you in advance for any assistance you give.
JNana