[mso] Re: Access Report Unbound :VSMail mx2

Glenda,

If you choose to use Sorting and grouping you can create a query that has
everything you want in it.  Put the Expenses in Details and your information
you only want once in one of the headers.  That way you can get your
individual with their Costs in the header and the Detailed Expenses
attributed to them.

James

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



Sorting & Grouping?  I can give that a shot.  Would the field containing
the 20 records per person go in Detail or elsewhere?

In the meantime, I'm working with a sub-report based upon a table.  I
don't want to see the ID field that establishes the link but can't
figure out how to hide it.  Should I just color it white like my
background or is there a more sophisticated method?

/g

-----Original Message-----
From: James LaBorde [mailto:jlaborde@xxxxxxxxx]=20
Sent: Thursday, May 22, 2003 12:45 PM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Access Report Unbound :VSMail mx2



Glenda,

A sub-report would do the job or you can have fun with the Sorting and
Grouping Options.  Either way you should get exactly what you need.  The
Sub-report would probably be the best option, but Sorting and Grouping
options will get you where you want to go if you combine everything in
one query.  Its simply a matter of where you put everything.

James

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



ahhhh...a clue

-----Original Message-----
From: Colli, Anthony G [mailto:Anthony.Colli@xxxxxxx]=3D20
Sent: Thursday, May 22, 2003 11:54 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Access Report Unbound


OK, why not have a subreport that details the expenses? It's kind of
like a subform, you can link by ID. Then GroupBy ID in the report.

-Anthony

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



I can get the totals from Costs & Expenses and the various calculations
on one row in a query, but in my report, I need the list of expenses as
well.  That's why I was thinking Unbound Control but for some reason
it's not working for me.  /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=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=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
*************************************************************
*************************************************************
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: