[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

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


Hi.
=3D20
I've never done this before but now I'm thinking perhaps I need to make
an unbound report with data coming from several tables and queries. =
=3D20
How do I make sure I get the right record with the right pieces of
information? =3D20 I have person & address information in one query and
account information in two queries. =3D20 All three queries have the =
same
unique ID for the record. =3D20 Is there a better way? =3D20 Any advice
appreciated.  /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=3D20
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
*************************************************************
*************************************************************
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=20
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
*************************************************************
*************************************************************
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: