blank field in ascending sort-blank fields last?

[Sheltie Lover]

I need to sort records by ascending date and have the records with the blank date fields appear at the end of the report rather than at the first. There has to be a way to do this, but I can't find it. I'm looking at a FMPro 6 bible, and it even says "If a record contains nothing in the sort field and you perform an ascending sort, it will appear at the beginning of the set of sorted records". O.K., but we don't want these records at the beginning of the set. Help, please.

[Sheltie Lover]

I need to sort records by ascending date and have the records with the blank date fields appear at the end of the report rather than at the first. There has to be a way to do this, but I can't find it. I'm looking at a FMPro 6 bible, and it even says "If a record contains nothing in the sort field and you perform an ascending sort, it will appear at the beginning of the set of sorted records". O.K., but we don't want these records at the beginning of the set. Help, please.

[Sheltie Lover]

I need to sort records by ascending date and have the records with the blank date fields appear at the end of the report rather than at the first. There has to be a way to do this, but I can't find it. I'm looking at a FMPro 6 bible, and it even says "If a record contains nothing in the sort field and you perform an ascending sort, it will appear at the beginning of the set of sorted records". O.K., but we don't want these records at the beginning of the set. Help, please.

[NYPoke]

Not sure if this will work. BUT, you could create a value list based on your Date Field. You can then use the "Customer Order based on Value List".

According to the FM Documentation (version 6), it will put the values not found at the end of the sort.

Only caveat is whether the blank records get a value in the list or not.

Worth a try.

[NYPoke]

Not sure if this will work. BUT, you could create a value list based on your Date Field. You can then use the "Customer Order based on Value List".

According to the FM Documentation (version 6), it will put the values not found at the end of the sort.

Only caveat is whether the blank records get a value in the list or not.

Worth a try.

[NYPoke]

Not sure if this will work. BUT, you could create a value list based on your Date Field. You can then use the "Customer Order based on Value List".

According to the FM Documentation (version 6), it will put the values not found at the end of the sort.

Only caveat is whether the blank records get a value in the list or not.

Worth a try.

[NYPoke]

Gave it a quick try & it looked successful.

[NYPoke]

Gave it a quick try & it looked successful.

[NYPoke]

Gave it a quick try & it looked successful.

[Sheltie Lover]

Thanks. I'll give it a try.

[Sheltie Lover]

Thanks. I'll give it a try.

[Sheltie Lover]

Thanks. I'll give it a try.

[Sheltie Lover]

PERFECT! Thanks so much!

[Sheltie Lover]

PERFECT! Thanks so much!

[Sheltie Lover]

PERFECT! Thanks so much!

[Vaughan]

I have blank values. They always screw up reports.

So I make a calculation field along the lines of

If( IsEmpty( field ), "<default>", field )

and use this calc field in the reports. All blank entries then display the <default> value, which looks much better then nothing.

[Vaughan]

I have blank values. They always screw up reports.

So I make a calculation field along the lines of

If( IsEmpty( field ), "<default>", field )

and use this calc field in the reports. All blank entries then display the <default> value, which looks much better then nothing.

[Vaughan]

I have blank values. They always screw up reports.

So I make a calculation field along the lines of

If( IsEmpty( field ), "<default>", field )

and use this calc field in the reports. All blank entries then display the <default> value, which looks much better then nothing.

[dwins]

Also, a calc field just for sorting doesn't need to be in the layout.

If(IsEmpty(date);1000000;GetAsDate(date)).

[dwins]

Also, a calc field just for sorting doesn't need to be in the layout.

If(IsEmpty(date);1000000;GetAsDate(date)).

[dwins]

Also, a calc field just for sorting doesn't need to be in the layout.

If(IsEmpty(date);1000000;GetAsDate(date)).