August 14, 2018 at 7:08 am
Not all that many folks are willing to open an Excel spreadsheet from the internet, so not many will open it and look at your problem. The best way to get help here is to post what we refer to as "consumable" data, which means CREATE TABLE statements along with INSERT statements with SAMPLE data representative of the domain of your problem, and ideally, also provide the expected results. Pictures and spreadsheets are not the way to go. However, those things said, I think you need a calendar table that identifies the school day of the year for each school. Depending on the number of schools involved, you might have a table for each school, or you might consolidate to a single table with either a set of columns for each school (you only need ONE column for the date), or a date column and a school id column plus the day number for that school. Think about how you would write the queries for each thing that you need to report, and design accordingly.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing post 1 (of 2 total)
You must be logged in to reply to this topic. Login to reply