Next Step Unclear

  • Thread starter Thread starter Carol
  • Start date Start date
C

Carol

How many tables relating to this report do you have ?
Are you creating the report from a query or directly from
the tables? Are you selecting "UNIQUE" records ?
 
This can be from a table or query. The information is
stored in one table like this....

Customer_Name1 Date Store1

Customer_Name2 Date-1 Store2

Customer_Name3 Date+2 Store 3

Customer_Name4 Date Store2

Customer_Name5 Date Store1

I used a query to pivot the table, so that Date is the
row headings. Each record is Unique. I also tried
splitting up the table by store in 3 different queries.
Is that sufficient informatin? Thanks.
 
Back
Top