New Database...Please help!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andre Adams - 31 Jan 2007 16:10 GMT

I'm trying to create a new database. I have information if various fields
for a complete year. (2006). Would I want to break this information down
into i.e. days, weeks, and months, or should I keep all of the information
together. I need to pull information from this data to create other queries
and reports for my users to access.

Reply to this Message

Jeff Boyce - 31 Jan 2007 16:12 GMT

Andre

If you have "detail" records, store detail records.

You can use Access' date/time functions, queries, and report groupings to
summarize for various periods.

Regards

Jeff Boyce
Microsoft Office/Access MVP

> I'm trying to create a new database. I have information if various fields
> for a complete year. (2006). Would I want to break this information down
> into i.e. days, weeks, and months, or should I keep all of the information
> together. I need to pull information from this data to create other
> queries
> and reports for my users to access.

Reply to this Message