Rabu, 27 Juli 2011

RE: [MS_AccessPros] Re: Back with reports problems

There is no "last record on the field" that I understand. Do you mean the last character of a field? If so, you can sort/group on expressions like:
=Right([Your Field Name],1)

Duane Hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: xtintores@yahoo.com
Date: Wed, 27 Jul 2011 22:23:51 +0000
Subject: [MS_AccessPros] Re: Back with reports problems


Thank you Duane, I found the Grouping & Sorting and it worked. Now, one more thing, how do I specify the report to group and sort only by the last record on the field?

--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
>
> Use the Sorting and Grouping dialog or the Group & Sort functionality. This depends on your version of Access.
>
> You can also GROUP BY in your reports record source but this will possibly remove some granularity of your data.
>
> Duane Hookom
> MS Access MVP
>
>
>
>
> From: xtintores@...
>
>
>
>
>
>
> Hello group...
> I'm back with a small problem with my report. It's almost complete but I'm having problems with duplicate values in the report. How do I group the report results by date?
>
>
>
>
> [Non-text portions of this message have been removed]
>


[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

Tidak ada komentar:

Posting Komentar