Report Map Problem Rich!

skea

skea

Registered User.
Local time
Today, 17:12
Joined
Dec 21, 2004
Messages
342
Hello There,
on my report, i have a map with many provinces as an image and i have a query with a population sum for each province. I want each sum(number of people) to be represented in a text box placed in a particular province on a map, am failing to make this reference, can any one help me!!

I mean,how to get a value from a query and paste it on a report!!

Thanks in Advance

**********From Rich**********************************
Add the required number of unbound textboxes onto the Report one over each province, set the control source to
=Sum(IIif([Province]="Alberta",1,0)) repeat for each province

*************************************************

Rich, thanks but each district is a different record as in the qry below. So each Ppnsum
has to go to an unbound txt box placed on top of each pronvince

Province Month PPnSum

Arizona Jan 64845
Texas Jun 25632
Calorina Sep 65437
Califonia Apr 67679
 
For future reference please just stick to one post on the subject, just return to the original with further questions ;)
just place a textbox for Arizona in the correct position on the map, set its control source to Arizona, repeat for each field in your query
 
still failing

Alright Rich, i was just trying to track you back. But this is not working,Now am confused of whether its meant to be
=PPnSum(IIif([Pronvince]="Arizona",1,0)) or =Sum(IIif([Pronvince]="Arizona",1,0)) which both popup an "IIif" msg box to enter a Parameter Value!!

Remember my Report is bound to my query.
 
Since your query already Sums the values you don't need the Sum(Iif, just use the fields in your query, their names will be available from the drop down list on the toolbar
 
Rich, as you see,there is more than one field and the sums are records, if i had just one record, with may be the pronvinces as fields,then i would just reference my unbound txt boxes directly. or may be make my txtboxes as combos, which a report wouldnt display!!
 
Thanx but...

Rich, thanks for the example, but this just shows the Countries bieng counted in the query. In Mine as i have attached it, each unbound txt box is meant to pick a value from a corresponding SumPPn from a corresponding province in the query.
NB. Map was making db be too big for attachment so i never put it on report
but its description remains there.
 

Attachments

Last edited:
You'll have to create individual queries and subReports for each state, I've done two for you
 
Last edited:
Thanks Rich. It was a Hard way to go about it but at least weve got some where.

Once Again,Thanks A Billion
 
Last edited:
Another Option

hahaaa...
in Uganda. Africa!!

On the other hand i thought of using this option.

i create a user defined function in my module...

Function getProv(strSQL as string) as long

dim rs as DAO.recordset
set rs=currentdb.openRecordset("SELECT SumPpn FROM PpnSumByProv WHERE
(Province='" & Province & "')")
getProv=rs!strSQL

End function

then refer every txtbox to this user defined function as in
=getProv("MyProvince")

i think it can lead me some where but its still Jamming. Look at it and correct if possible.
Thanks
 
Skea,

Here's another take on it. I just pretended to have a map.

btw, Rich, I can't convert to A97 ... maybe Skea will.

Wayne
 

Attachments

Thanks so much WayneRyan,
This idea is very rich.... let me exploit it.

Again...
Thanx A Trillion Bucks.
 
You must log in or register to reply here.

Similar threads

J
Interesting artical about what government can and can't do. It's a bit longish, but worth the read.
2 3
Replies
43
Views
3,724
Thales750
T
C
How to Attach A VBA effectively
Replies
4
Views
1,151
theDBguy
theDBguy
C
Questions reported on veribals multiple
Replies
8
Views
1,395
moke123
moke123
B
on-the-fly Totals in Access Reports
2
Replies
21
Views
1,990
theDBguy
theDBguy
P
Struggling with Charts in Reports
Replies
9
Views
1,429
isladogs
isladogs

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom