Parameters Table in Access

[Bullman2000_uk]

I am setting up a database that is merging and grouping a "Global Spend" by my company from 7 different systems. In order to present this data I want to be able to append all the data together but also add in 2 new fields that represent the quarter that the data was loaded and grouped, also the year and possibly the month. I can't work out how to do this can anyone help?

 

[DCrake]

It seems to me that each record will be date related, if so, you do not need the extra fields. You can calculate them based on the source date.

Look at the Format Function, such as Format([YourDateField],"mmmm")


David

 

[Bullman2000_uk]

There is no date within the download that I need to mark, is there any way to get round this?

 

[DCrake]

If you are appending the data into an existing table then create an extra field to hold the date/time stamp when the data hit the table. Go to the properties of the field and set the default value to either

Date()

Or

Now()

Depending if you want just the data or the date and time. Then when you append records to the table the hit date will appear for each record then use can use the Format() function to derive the month / quarter.

David