P
Phil Smith
I can open this query, and it workds perfectly well. If I try to export
it directly to Excel, I get an error:
Cannot define field more than once.
While doing some websearch, I came across one contention that Access can
only export 10 characters worth of fieldname. I definitely have a few
entries which have the 1st ten characters the same. Is this really a
(truly incredibly unjustifiably lame,)limitation on the part of Access 2003?
------------
TRANSFORM
Sum([item_warehouse_link]![onhand_qty]*[item_warehouse_link]![average_cost])
AS Expr1
SELECT category.name AS Category, item.old_sku, item.item_id,
item.short_desc
FROM category RIGHT JOIN ((item_warehouse_link RIGHT JOIN item ON
item_warehouse_link.item_id = item.item_id) LEFT JOIN warehouse ON
item_warehouse_link.warehouse_id = warehouse.warehouse_id) ON
category.category_id = item.master_category_id
GROUP BY category.name, item.old_sku, item.item_id, item.short_desc
ORDER BY category.name, item.old_sku, item.item_id, item.short_desc
PIVOT warehouse.name;
it directly to Excel, I get an error:
Cannot define field more than once.
While doing some websearch, I came across one contention that Access can
only export 10 characters worth of fieldname. I definitely have a few
entries which have the 1st ten characters the same. Is this really a
(truly incredibly unjustifiably lame,)limitation on the part of Access 2003?
------------
TRANSFORM
Sum([item_warehouse_link]![onhand_qty]*[item_warehouse_link]![average_cost])
AS Expr1
SELECT category.name AS Category, item.old_sku, item.item_id,
item.short_desc
FROM category RIGHT JOIN ((item_warehouse_link RIGHT JOIN item ON
item_warehouse_link.item_id = item.item_id) LEFT JOIN warehouse ON
item_warehouse_link.warehouse_id = warehouse.warehouse_id) ON
category.category_id = item.master_category_id
GROUP BY category.name, item.old_sku, item.item_id, item.short_desc
ORDER BY category.name, item.old_sku, item.item_id, item.short_desc
PIVOT warehouse.name;