Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Sep 2002
    London, England
    Thanked 0 Times in 0 Posts

    Crosstab in reverse (2003)

    Is there a neat way of doing a crosstab in reverse, by which I mean to take a table and create a query that returns one record for each of certain columns in that table? I have a table of store opening times. Each record contains a store id, then a set of boolean fields that tell me whethwer the store is meant to be open on Mon, Tue, Wed .. Sun. What I need to do is to compare this with a sales and footfall table, which has one record per store per day, to see if sales and footfall data exists in this table for each of the days that the various stores are open. I could union together seven individual queries, one for each day of the week, based on the store opening times table, but this seems a bit messy. I'm sure that this kind of thing must have come up before and I wondered if there was a more efficient way of doing it.


  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 30 Times in 30 Posts

    Re: Crosstab in reverse (2003)

    You can use VBA code to "normalize" a table. Free sample code can be downloaded from NormalizeDenormalize on Roger's Access Library. Post back if you have problems.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts