Creation of A table

[Guest]

Hello,
I have a report from a database which contain 11 activities (column header)
related to 283 sites with all the actual dates of each activity, I want to
import it to access to have the count of the records for each activity to
create a ressources planning based on that count. How can I do it , I don't
want to have a table with all the fields which are in the report and all the
sites.
Any help will be appreciated.
Nawel

 

[Joseph Meehan]

Hello,
I have a report from a database which contain 11 activities (column
header) related to 283 sites with all the actual dates of each
activity, I want to import it to access to have the count of the
records for each activity to create a ressources planning based on
that count. How can I do it , I don't want to have a table with all
the fields which are in the report and all the sites.
Any help will be appreciated.
Nawel

Tell us more about the report. Is it a flat field text file?

My guess is you will want to import the report into Access as a table
and work from there.

 

[Guest]

The report is made by a roll-+out tool for GSM networks, the report is an
excell file with the activities as columns and with sites as rows, every site
has or has date for each activity, I don't want to import it to access
because then I will have a table with 283 records (sites in excell) , what I
need is just the number of sites in each activity to know the actual number
of sites/activity to use it in soma calculation for the number of ressources,
I hope that you can help me

 

[Joseph Meehan]

The report is made by a roll-+out tool for GSM networks, the report
is an excell file with the activities as columns and with sites as
rows, every site has or has date for each activity, I don't want to
import it to access because then I will have a table with 283 records
(sites in excell) , what I need is just the number of sites in each
activity to know the actual number of sites/activity to use it in
soma calculation for the number of ressources, I hope that you can
help me

Cool. You can bring the data in from Excel easily. I suggest you just
bring it all in and then normalize the table. Access will help. Use
"Tools" - "Analyze" - "Table" and follow the wizard.

 

[Guest]

hello,
It is not really what I need, It will just split my table into several
tables, waht I need is just the number of records for each activity to use it
in an other table to make calculations, because if I used the calculation in
this table when I make an export I had all the fields repeated 283 times.
What is the best way for that???

 

[Joseph Meehan]

hello,
It is not really what I need, It will just split my table into several
tables, waht I need is just the number of records for each activity
to use it in an other table to make calculations, because if I used
the calculation in this table when I make an export I had all the
fields repeated 283 times. What is the best way for that???

The point is poorly designed tables makes all kinds of functions more
difficult. It is almost always best to start any project by correcting the
table design when it is faulty.