|
|
How do you sort 2 date fields in assending order (query or report)
I have 2 DOB fields (client and spouse) in a table that I currently print off
the birth month and call them on their b-day. I really wish I could figure
out how to get them to print/display in assending order of date (ie: 11/1
followed by 11/2) even if the spouse is before the client. Is this possible
without having to do a bunch of programming? Thanks!
|
|
0
|
|
|
|
Reply
|
 Utf
|
11/17/2009 7:27:01 PM |
|
Yep. Use a calculated field like this --
DOB_Sort: IIF([Client_DOB]<[Spouse_DOB], [Client_DOB], [Spouse_DOB])
--
Build a little, test a little.
"KnowEnough2BDangerous" wrote:
> I have 2 DOB fields (client and spouse) in a table that I currently print off
> the birth month and call them on their b-day. I really wish I could figure
> out how to get them to print/display in assending order of date (ie: 11/1
> followed by 11/2) even if the spouse is before the client. Is this possible
> without having to do a bunch of programming? Thanks!
|
|
|
0
|
|
|
|
Reply
|
Utf
|
11/17/2009 7:32:01 PM
|
|
|
1 Replies
588 Views
(page loaded in 2.258 seconds)
Similiar Articles: How do you sort 2 date fields in assending order (query or report ...I have 2 DOB fields (client and spouse) in a table that I currently print off the birth month and call them on their b-day. I really wish I could f... Sort Report by Month - microsoft.public.access.reportsHow do you sort 2 date fields in assending order (query or report ... I have 2 DOB fields (client and spouse) in a table that I currently print off the birth month and ... OrderBy two fields - microsoft.public.access.formsHow do you sort 2 date fields in assending order (query or report ... OrderBy two fields - microsoft.public.access.forms How do you sort 2 date fields in assending order ... Sort months in calendar order - microsoft.public.access.reports ...How do you sort 2 date fields in assending order (query or report ... Sort months in calendar order - microsoft.public.access.reports ... How do you sort 2 date fields in ... How do I sort by calculated field - microsoft.public.access ...How do you sort 2 date fields in assending order (query or report ... Yep. Use a calculated field like this -- DOB_Sort: IIF([Client_DOB]<[Spouse_DOB], [Client_DOB ... How do I sort on a calculated field in a report? - microsoft ...How do you sort 2 date fields in assending order (query or report ... Yep. Use a calculated field like this -- DOB_Sort: IIF([Client_DOB]<[Spouse_DOB], [Client_DOB ... Showing month of the year in chronological order in a report ...How do you sort 2 date fields in assending order (query or report ... Showing month of the year in chronological order in a report ... How do you sort 2 date fields in ... Dates do not sort correctly - microsoft.public.access.reports ...Dates do not sort correctly - microsoft.public.access.reports ... Showing month of the year in chronological order in a report ... If you sort on the date field using the ... Sorting on a Calculated Field in a Report - microsoft.public ...How do you sort 2 date fields in assending order (query or report ... Yep. Use a calculated field like this -- DOB_Sort: IIF([Client_DOB]<[Spouse_DOB], [Client_DOB ... Sorting Month-Year in Query - microsoft.public.accessHow do you sort 2 date fields in assending order (query or report ... Sorting Month-Year in Query - microsoft.public.access How do you sort 2 date fields in assending ... How do you sort 2 date fields in assending order (query or report ...I have 2 DOB fields (client and spouse) in a table that I currently print off the birth month and call them on their b-day. I really wish I could f... Using MS Access: How to sort two date fields in a query, date ...date ascending order, query design, location history: A Null value will sort last in chronological descending order. The only way you might make ... concerning two date fields ... Save a sort order with a table, query, form, or report - Access ...When you sort the data in a table, query, form, or report, you can save the sort order with ... whether you want to sort the field in ascending order ... numeric, or date ... Sort records on text, numeric, or date values - Access - Office.com... sort them the way you want. A calendar or a dayplanner is sorted on date. ... You can sort the records in a table, query, form, or a report on one or more fields. ... ascending order ... How to Sort Dates in Ascending Order in a Subform in Microsoft ...How to Sort Dates in Ascending Order in ... making a report based on a table with date fields. After... How Do I Sort & Count Records in a Query in Microsoft Access? When you ... 7/25/2012 12:44:15 PM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
16 followers. 