T
Tim Fierro
Hello,
I have a report that had been working fine, but now is not. When I go to
the design view of the query, I get the error that the field(s) could not be
represented or that something has changed.
I have even went as far as recreating the query and here is what I have.
SELECT tblOrder.ordVendor, tblOrder.ordDate, tblOrderLine.ordlineBoatId,
tblOrderLine.ordlineStatus, tblOrderLine.ordlineOrdId,
tblOrderLine.ordlineId, tblOrderLine.ordlineQtyReceived,
tblVitem.vitemDescription, tblOrderLine.ordlinePrice, tblBoat.boatName,
tblVendor.vndNameShort, tblBoat.boatpmsSpecialOrders
FROM tblVendor INNER JOIN (tblBoat INNER JOIN (tblVitem INNER JOIN (tblOrder
INNER JOIN tblOrderLine ON tblOrder.ordId=tblOrderLine.ordlineOrdId) ON
tblVitem.vitemId=tblOrderLine.ordlineVitemId) ON
tblBoat.boatId=tblOrderLine.ordlineBoatId) ON
(tblVendor.vndId=tblOrder.ordVendor) AND
(tblVendor.vndId=tblVitem.vitemVendor)
WHERE (((tblOrderLine.ordlineBoatId)=1 Or (tblOrderLine.ordlineBoatId)=5 Or
(tblOrderLine.ordlineBoatId)=7 Or (tblOrderLine.ordlineBoatId)=17) AND
((tblOrderLine.ordlineStatus)="R" Or (tblOrderLine.ordlineStatus)="P" Or
(tblOrderLine.ordlineStatus)="C"))
ORDER BY tblOrder.ordVendor, tblOrder.ordDate, tblOrderLine.ordlineBoatId,
tblOrderLine.ordlineStatus, tblOrderLine.ordlineOrdId,
tblOrderLine.ordlineId, tblOrderLine.ordlineQtyReceived;
In the design view it looks identical (as far as I can tell) to the old
query that somehow does not work now.
What is happening is that it is taking a long time for this query to run
when it used to be pretty fast. Then a glaring problem is shown. I have 2
orderlines for Boat #17 yet only 1 of them shows up in the query. Nothing
obvious either on why it only picked up one.
Another odd issue is when I get to the report using this query; it 'looks'
like it is tallying up more than it should and/or grabbing duplicates. Not
sure, but I dont' want to go into the report aspect until I find out if
there is something wrong with my query.
Anyone familiar with the language see anything peculiar that is obvious to
all but me as a newb of a few months.
Tim
I have a report that had been working fine, but now is not. When I go to
the design view of the query, I get the error that the field(s) could not be
represented or that something has changed.
I have even went as far as recreating the query and here is what I have.
SELECT tblOrder.ordVendor, tblOrder.ordDate, tblOrderLine.ordlineBoatId,
tblOrderLine.ordlineStatus, tblOrderLine.ordlineOrdId,
tblOrderLine.ordlineId, tblOrderLine.ordlineQtyReceived,
tblVitem.vitemDescription, tblOrderLine.ordlinePrice, tblBoat.boatName,
tblVendor.vndNameShort, tblBoat.boatpmsSpecialOrders
FROM tblVendor INNER JOIN (tblBoat INNER JOIN (tblVitem INNER JOIN (tblOrder
INNER JOIN tblOrderLine ON tblOrder.ordId=tblOrderLine.ordlineOrdId) ON
tblVitem.vitemId=tblOrderLine.ordlineVitemId) ON
tblBoat.boatId=tblOrderLine.ordlineBoatId) ON
(tblVendor.vndId=tblOrder.ordVendor) AND
(tblVendor.vndId=tblVitem.vitemVendor)
WHERE (((tblOrderLine.ordlineBoatId)=1 Or (tblOrderLine.ordlineBoatId)=5 Or
(tblOrderLine.ordlineBoatId)=7 Or (tblOrderLine.ordlineBoatId)=17) AND
((tblOrderLine.ordlineStatus)="R" Or (tblOrderLine.ordlineStatus)="P" Or
(tblOrderLine.ordlineStatus)="C"))
ORDER BY tblOrder.ordVendor, tblOrder.ordDate, tblOrderLine.ordlineBoatId,
tblOrderLine.ordlineStatus, tblOrderLine.ordlineOrdId,
tblOrderLine.ordlineId, tblOrderLine.ordlineQtyReceived;
In the design view it looks identical (as far as I can tell) to the old
query that somehow does not work now.
What is happening is that it is taking a long time for this query to run
when it used to be pretty fast. Then a glaring problem is shown. I have 2
orderlines for Boat #17 yet only 1 of them shows up in the query. Nothing
obvious either on why it only picked up one.
Another odd issue is when I get to the report using this query; it 'looks'
like it is tallying up more than it should and/or grabbing duplicates. Not
sure, but I dont' want to go into the report aspect until I find out if
there is something wrong with my query.
Anyone familiar with the language see anything peculiar that is obvious to
all but me as a newb of a few months.
Tim