Best Practiice for Table Design (1 Viewer)

[lcook1974]

Hey All,
I have a spreadsheet that will no longer be used after this month due to the new year. We are capturing all the data now in an SQL database through a website.

I need to re-create the report the Access but will be creating functions in the back end to count each "outcome" (column header)

I'm attaching the spreadsheet so you can see what I'm up against.

my first thought is to create a union query for each one then do a cross tab query based on the month and "title", but that seems like a long way around.

any suggestions?

When it's all said and done the report has to look like the excel spreadsheet.

 

[HiTechCoach]

Without knowing the table structures it will be impossible to give you any specific suggestions.

Please post your table structures

 

[lcook1974]

There is no table structure yet. I have to build that or a view in SQL. Just looking for ideas on the best way to handle that.

 

[HiTechCoach]

There is no table structure yet. I have to build that or a view in SQL. Just looking for ideas on the best way to handle that.

You origianlly stated:

Hey All,
We are capturing all the data now in an SQL database through a website.

Will you using this SQL database for your reports?

If not then where will your data code from for the reports?

TIP: Remeber that we know nothing about your project. Don't assume we know anything about what you need.

 

[Simon_MT]

It Should be fairly straightforward to create a table to cover your requirement.

There a two Types of Donation:

[T] Tissue
[E] Eye

Approval?

Yes/No

No Perm Don't know what that is

Yes/No

ME Could guess but would probably be wrong

Family Support

Yes/No

Simon

 

[lcook1974]

I think I have it....there's been a lot going on with an Audit in the office and my brain has stopped for the time being.

I'll post my solution to see what you think and/or see if there is a better way.

No Perm: no permission for donation
ME: medical examiner