470,624 Members | 2,538 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,624 developers. It's quick & easy.

calculations in access

I'd appreciate your ideas on this. I need to make the calculation for
unemployment rate for three different
data sources (A,B,C) for many countries and age groupings:

unemployment rate = number of unemployed/number of labour force

Right now, these are the tables I have:

source A unemployed (number)
source A labour force (number)
source B unemployed (number)
source B labour force (number)
source C unemployment rate

I`d like to be able to put the unemployment rate data and calculations
for all the data sources in one table in order to make an analysis of
source differences in the figures.

How could this be done? How do you suggest is the best way to set up my
tables, data, query, etc for SQL in Access.

Thanks.

Brian

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #1
2 5811
TblDataSource
DataSourceID
DataSource

TblUnEmploymentStatistics
UnEmploymentStatisticsID
DataSourceID
LaborForce
UnEmployed

Create a query based on both tables so you can include the DataSource field.
Create a crosstab query based on this query and you will put data sources
across the top and a row for LaborForce and a row for Unemployed.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"brian kaufmann" <br************@hotmail.com> wrote in message
news:41**********************@news.newsgroups.ws.. .
I'd appreciate your ideas on this. I need to make the calculation for
unemployment rate for three different
data sources (A,B,C) for many countries and age groupings:

unemployment rate = number of unemployed/number of labour force

Right now, these are the tables I have:

source A unemployed (number)
source A labour force (number)
source B unemployed (number)
source B labour force (number)
source C unemployment rate

I`d like to be able to put the unemployment rate data and calculations
for all the data sources in one table in order to make an analysis of
source differences in the figures.

How could this be done? How do you suggest is the best way to set up my
tables, data, query, etc for SQL in Access.

Thanks.

Brian

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 13 '05 #2
Thanks for the suggestion on the sql code. I must admit I'm a newbie to
sql and access, and I'm not sure I see how the calculation of
unemployment rate actually is accomplished in the query.

Perhaps I need to clarify as well on the tables which I've already
created. They are:

Table 1 (data on number of unemployed as reported by source A)
Table 2 (data on number of people in the labour force as reported by
source A)
Table 3 (data on number of unemployed as reported by source B)
Table 4 (data on number of people in the labour force as reported by
source B)
Table 5 (data on unemployment rate as reported by source C)

Each table is basically the following format:

country year agegroup indicator measurement value

Here the field "indicator" can either be unemployment or labour force
depending on the table.
The field "measurement" can be number or rate depending on the table.
value is the actual absolute rate or percentage if rate.

The labour force data and the unemployment data have corresponding age
groups for different countries and years. Each data source (A and B)
have their own values for the same age groups for different countries
and years. So I'd like to compare the difference in calculated
unemployment rates between data source A and B.

Could you clarify the best way to create the query in order to generate
a new table in which the unemployment rate has been calculated for each
data source for corresponding country, year and agegroups.

Thanks again, and looking forward to hearing from you.

Brian
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by brian kaufmann | last post: by
3 posts views Thread by John M | last post: by
4 posts views Thread by debi.robarts | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.