[mso] Re: Access Report Unbound

/g

How about an expenses query and a costs query that groups by ID it can return 
one row with total expenses/costs per ID. You can then link and add/subtract 
from that.

-Anthony



-----Original Message-----
From: Glenda Wells [ mailto:gwells@xxxxxxxxxxx]
Sent: Thursday, May 22, 2003 11:37 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Access Report Unbound



So far, I can get all the elements in one row except the list of
Expenses.  Is there where I could use an unbound Combo Box to perhaps
display the information from the list of expenses?  /g

-----Original Message-----
From: Glenda Wells=20
Sent: Thursday, May 22, 2003 11:27 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Access Report Unbound



Maybe more info is needed.

In the P&A table, there is one row per person

In the Cost account query, there is one row per person

In the Expenses query there can be as many as 20 rows per person

When I try to combine all 3 queries, I of course get as many as 20
records per person

I need to perform calculations between Costs and Expenses and generate
one letter (report) per person but show the values of all three queries,
i.e. Name, Address, Expenses list, Calculated fields between Costs &
Expenses but not the actual costs.

When I attempt to add fields from the three sources to a report I get
field error #name?

/g




*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: