Hi, I have a table which contains (week Number, start date, end date) - this has a number of weeks with their respective start and end dates.
I then have a second table with customer information. Part of this customer information is a date (lets call it "dateJoined"). In addition to this there are many variables which for the purpose of this thread, might as well be booleans (lets call them Var1, Var2, Var3)
I need a report to display all data in the week table - i.e. week number, start date and end date - then against each I need a count of the specific boolean variables (Var1, Var2 and Var3) only for the customers whoes dateJoined is between the specified week start and end date.
It gets a bit more complicated than that, as in I also need to calculate percentages and running totals, but trying to take it one step at a time.
I would have thought that in a report you would be able to query data on that specific row... in which case I would just right a query for each variable that I am trying to calculate, and it would just take the start and end date from the Week table.. Is this even possible, if not is there another solution?
Any help would be appreciated
I then have a second table with customer information. Part of this customer information is a date (lets call it "dateJoined"). In addition to this there are many variables which for the purpose of this thread, might as well be booleans (lets call them Var1, Var2, Var3)
I need a report to display all data in the week table - i.e. week number, start date and end date - then against each I need a count of the specific boolean variables (Var1, Var2 and Var3) only for the customers whoes dateJoined is between the specified week start and end date.
It gets a bit more complicated than that, as in I also need to calculate percentages and running totals, but trying to take it one step at a time.
I would have thought that in a report you would be able to query data on that specific row... in which case I would just right a query for each variable that I am trying to calculate, and it would just take the start and end date from the Week table.. Is this even possible, if not is there another solution?
Any help would be appreciated
