Max Across Fields

[Derrick T. Davidson]

I have a query that shows Field1 [appointment dates] Field2 [Actual Date] Field3 [Next Due Date] is there a way to show [Next Due Date] ACROSS all the records showing only the latest [Next Due Date] as opposed to Down A Field? I know it's easy in Excell so I am assuming it is possible in Access. Hope this is clear to you experts and not to dumb a question.

[Beetle]

Hard to be specific without knowing more about exactly what you're trying to do, but a crosstab query might get you the results you're after. You can use the query wizard for this if you're unfamiliar with creating one.

If you don't think this will solve the issue then post back with an example of the data in its current form and an example of what you want to see.

[Derrick T. Davidson]

I figured it out from this link, however it works great BUT the format is "5/4/13" is there any way to format into a long date the format drop down in the query is just blank no options???

[Derrick T. Davidson]

http://support.microsoft.com/default...b;en-us;209857

[Beetle]

Try;

Format([YourDateField], "Long Date")