I have a query that pulls data from a table in my database and I need to be able to list out totals by month. I am getting the month from the Check Date field I have in the query that list the date in which the check was processed. I was wondering if there was a way to reformat I guess a field used in a query to display differently. So I can show totals by month even though that isn't a field directly in the query.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Formatting fields on a report 1
- Thread starter SHAWTY721
- Start date
-
1
- #2
If I understand correctly, you can create a column in your query like:
YrMth: Format([Check Date],"yymm")
This would provide a column in your report that you could sort and group by.
Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
YrMth: Format([Check Date],"yymm")
This would provide a column in your report that you could sort and group by.
Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question