Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
12-04-2007, 09:07 PM #1
- Join Date
- Oct 2007
- Thanked 0 Times in 0 Posts
How to make table from two dimension array
I have a report like the following- [the expenses of each item under the item heading is recorded for a date of a particular month]. I cant format my report as I want but u can realize it.
Fields/Months - 1 3 4 5 . . . . . 30 31
Staff Salary($) 4
Now could anybody tell me how to make my database table for this report. This looks like a 2 dimension array of records. Should I build a table for each dimension like one for labor including the male and female as fields of that table. OR all fields in a single table including all those fields. As u can see each item is(or can be) recorded in a particular date of a month. It means record can be inserted at any date of a month. In this case if I make a single table, how can I insert record several times in a same month. It is a little confusing to me.Pls anybody tell me how to make table out of SUCH two dimension array.There must be a conventional way to do this.