Recent content by Duane Dibbley

Gawd bless yah sah, will give this a go thank-you!

The fields aren't actually numerated, i've just named them so in this post to give a better understanding of their relationship, as the actual names would be irrelevant gibberish to anyone reading. The date field does contain actual date values. I appreciate your effort, but if you don't...

I have a query with the following structure; aDate(pkey) cost1 cost2 cost3 calc1 calc2 calc3 01/012014 ,,,,,,,,,1,,,,,, 2,,,,,,, 3,,,,,, 1,,,,,,, 2,,,,, 3 01/02/2014 ,,,,,,,,1,,,,,, 2,,,,,,,, 3,,,,,, 2,,,,,, 4,,,,,, 6 01/03/2014,,,,,,, 1 ,,,,, 2,,,,,,, 3,,,,,,, 3,,,,,, 6 ,,,,, 9 01/04/2014...

Indeed each record must have a unique value for the primary key field. But each record contains other fields?!? e.g. aDate(pkey) cost1 cost2 cost3 calc1 calc2 calc3 Jan 2014 ,,,,,,,,,1,,,,,, 2,,,,,,, 3...

The actual data structure is simple. Its a table on a spreadsheet with each row being a cost element, and columns representing an individual month. each cell has a value for the amount spent for that cost element, for that month. I have chose to normalize it as a table with a primary key as...

Indeed my task is to convert a spreadsheet into a database. However your idea of 'better normalization' seems infact much worse. To hold the data in a table I have the choice of setting the month or cost category in one field, with the other having to be seperated into individual fields. I...

The purpose of the database is financial. Each field/column in the table represents a cost category, and each numerical value in it represents an amount spent or due to be spent. Each row represents a month (hence the primary key being a date field). The first month/row is in 2013, the last...

Apologies I shall try to be more specific; I have a table called '01905', which has a primary key field of dates called 'aDate', and about 30 other numerical fields. Assume they're called 'field1' etc. I have created a query based on this table, which contains calculated fields showing the...

I have a table with a primary key as date, and various other fields with numerical values. I also have a query that calculates running totals for each of these fields, as well as including the fields from the table. I need to create a report or form in which I can select a date(primary key)...