Saving Historical Data from Query Results?

sbowman

I'm in the process of creating a monthly reporting database. I've
worked out all the queries which are all counts of particular field
values. I need to store these values in a table for historical data,
problem is i have multiple count queries and each of those has up to 10
results. How can I put these results in a table?

Help is much appreciated!

Shelley

Sep 6 '06 #1

Subscribe Post Reply

2266

Rick Brandt

sbowman wrote:

I'm in the process of creating a monthly reporting database. I've
worked out all the queries which are all counts of particular field
values. I need to store these values in a table for historical data,
problem is i have multiple count queries and each of those has up to
10 results. How can I put these results in a table?

Help is much appreciated!

Shelley

What would be a lot more "typical" would be for your source data to include
a date field (or fields) and then you could query for any date range you
want eliminating any reason to use tables for "historical data".

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Sep 6 '06 #2

Similar topics

saving a query string

by: shank | last post by:

I have a search page with 7 different field options to search upon. The user can use any or all options. On the results page I'd like to put at the top of each column and ASC and DESC link to...

ASP / Active Server Pages

historical data

by: rottytooth | last post by:

A general data design question: We have data which changes every week. We had considered seperating historical records and current records into two different tables with the same columns, but...

Microsoft SQL Server

how to get historical data?

by: ÀèÎ¬ Íõ | last post by:

hi, now, i don't know how to ask a historical query? which command? thanks! __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam...

PostgreSQL Database

Saving calculated values

by: SJH | last post by:

I have been given an older database and asked to make upgrades and what not. One interesting thing I have come across with the database is that it was at one time set up so one of the tables would...

Microsoft Access / VBA

Historical data

by: Erwin | last post by:

I have a work assignment in which I have to put a historical archive within access which can be used for trendlines etc. It contains data about month, service percentages and numbers. Within a...

Microsoft Access / VBA

Saving DataTable to session vs saving a Custom object.

by: John Kandell | last post by:

Hi, I posted this in the asp.net group, but didn't get a response. Maybe someone here can help me with this... --- Would someone be able to shed some light on what is the cost of saving a...

C# / C Sharp

Handling Calculated Historical Values

by: igendreau | last post by:

I need to have a form where my users can enter job info. One thing they need to enter is "Regular Hours". What I need to do is then calculate "Regular Cost" which =Regular Hours x Regular Rate...

Microsoft Access / VBA

Edit, Reports, Saving Forms/Reports with Multiple SubForms

by: natwong | last post by:

Hi All, I'm hoping that someone could help me out since I'm new with Access. Background: Database was set up as a simple data entry and reporting tool for Program Initiatives. The data...

Microsoft Access / VBA

daylight saving time

by: bernhard Hoyler | last post by:

Hi, I would like to determine whether at a certain time point in time the daylight savings time is in effect. This means such a logic should show that today (16-Nov-2007) no daylight savings...

C / C++

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++