Create Microsoft Access Report/Query - Simple Job

Closed Posted Aug 30, 2011 Paid on delivery
Closed Paid on delivery

This job is to create queries/reports that tells us response rates from advertisements we run.

We have a table in MS Access. It contains one of about ten different types of text, e.g. ABC1, XYZ, FGR4, etc.

This text is the code for the magazine someone read, who then responded to our advertisement.

For example, if the person/record responded from magazine ABC1, we put that in this column in the table. It's like a code that tells us which magazine they responded from.

This is all in one column.

We want to create a query that tells us how many of 'ABC1', or 'XYZ' are in that particular column. For example there might be 400 records in the table in total - 30 of those are ABC1, 310 are XYZ, and 12 are FGR4 etc.

This therefore tells us how many responses we got from each magazine.

Once that is complete, we also have another table that we want to link to this.

That data will have two columns.

The magazine code, e.g. ABC1, and the total number of people the magazine went to.

So the first column would have 'ABC1' - the second column might say '50,000' (the number of people that received magazine ABC1).

The next record might say 'XYZ' and the corresponding number (in the second column) would say '18,500' - the number of people that received magazine XYZ.

Finally, then the final report will show this:

Magazine name - number of people mailed with that magazine - number of responses - percentage % response rate.

At the very bottom of the report we will also have a sum of all figures - total number of magazines mailed, total reponses, total % response.

Engineering Software Architecture Software Testing

Project ID: #3543286

About the project

19 proposals Remote project Active Sep 21, 2011

19 freelancers are bidding on average $28 for this job

gribfritz

See private message.

$34 USD in 5 days
(461 Reviews)
7.6
amcsummers

See private message.

$34 USD in 5 days
(53 Reviews)
5.3
emova

See private message.

$25 USD in 5 days
(31 Reviews)
5.0
izharuislam

See private message.

$24 USD in 5 days
(22 Reviews)
4.4
ratzparam

See private message.

$30 USD in 5 days
(29 Reviews)
4.0
Baxter2008

See private message.

$25 USD in 5 days
(14 Reviews)
3.8
SHhadun

See private message.

$25 USD in 5 days
(21 Reviews)
3.6
hussiensharafite

See private message.

$34 USD in 5 days
(1 Review)
2.8
ahmedgamil2

See private message.

$30 USD in 5 days
(11 Reviews)
2.4
EFIS

See private message.

$30 USD in 5 days
(8 Reviews)
2.4
vorticesoft

See private message.

$30 USD in 5 days
(3 Reviews)
2.1
legumeofdoom

See private message.

$20 USD in 5 days
(1 Review)
0.0
fluentcoder

See private message.

$30 USD in 5 days
(0 Reviews)
0.0
mmitservices

See private message.

$29.9 USD in 5 days
(0 Reviews)
0.0
rwlane051973

See private message.

$28 USD in 5 days
(0 Reviews)
0.0
inaworks

See private message.

$30 USD in 5 days
(0 Reviews)
0.0
daveconway3

See private message.

$25 USD in 5 days
(0 Reviews)
0.0
shuva420

See private message.

$30 USD in 5 days
(0 Reviews)
0.0
Maneesh6

See private message.

$22 USD in 5 days
(0 Reviews)
0.0