Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Access issue: Query a Crosstab Query [Date]

  • 22-08-2011 11:58AM
    #1
    gerryg80
    Registered Users, Registered Users 2 Posts: 98 ✭✭


    Hi,
    Im currently encountering an issue with access and was wondering if anyone had any ideas
    My Database is built on linked tables to an excel file which changes weekly. The excel file contains details of customer orders.
    Im trying to build a report to detail what supplies i need to meet demand etc.
    The reports required output is (Order_Ingredient, Supplier, Monday, Tuesday, Wednesday, Thursday, Friday, Total)
    Order_Ingredient can contain different fields from the main orders table(i.e Drink, Snack etc)
    The Orders table i am running querys off has the structure (OrderID, Date, Order_Name, Drink, Snack,).
    I know i can run crosstab query's on the orders table to get the quantity for days of the week for each order_ingredient.
    These come out with the structure (Order_Ingredient, 12/05, 13/05, 14/05, 16/05/ 17/05). I then run querys to add these details to a table which i run the report off.
    The issue i am having is when the excel file in the back end changes (i.e. to next weeks), the date names obviously change in the crosstab queries,
    which makes the queries on the crosstab queries obsolete.
    If anyone has any recommentdations the would be great.


Advertisement