Recent content by clubcar
-
C
One Field, or multiple fields?
That's what I was thinking as I work through this... I see that it is much easier to transform the data... Wonder why my old employer, who really has a jammin IT department, went the other way. I can only assume thier IT wasn't so swift when they developed this years ago, or transform was...- clubcar
- Post #5
- Forum: Theory and practice of database design
-
C
One Field, or multiple fields?
I was going to make a data table for the balance sheet and income statement (and then several additional schedules to follow). It would show the following fields: Company, Date, Type (Qtrly,Annual), Version (p or f), Cash, Accounts receivable, derivative assets, .... 80 fields each representing...- clubcar
- Post #3
- Forum: Theory and practice of database design
-
C
One Field, or multiple fields?
I was working with IT. I suggested tables built for various financial statements. A table for the balance sheet with fields (columns)for alll the accounts (cash, accounts receivable... 80 accounts). A table for income statement with associated fields. This was how my last employer did this...- clubcar
- Thread
- Replies: 5
- Forum: Theory and practice of database design
-
C
Running Query With Like In Ado
You are a genius... I was trying to get ADO with Transform statement pulling into excel to work. When my query was using *, it failed, continually. I was going to go with Left([item],4) = xxxx... but what a pain to keep up... instead, I used Alike (never heard of it) and %... and I'll be...