By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,853 Members | 2,246 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,853 IT Pros & Developers. It's quick & easy.

MONTH TO DATE AND YEAR TO DATE REPORTING

P: n/a
I have a database with a Master table and a Budget table.
The Master table has all the data including these 4 fields (Enccredit,
Encdebit, Credit and Debit) and related to the Budget table.

The Budget table has the 3 fields namely:
Field 1 Category
Field 2 Budget Amt
Field 3 Costcenter Number

All these fields are related to the same fields in the Master table.

How do I create a Month-to-date column and a Year-to-date column.

Thanks

My problem is to create a report that will show Month to date

K
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
kd******@aol.com (Johnny) wrote in message news:<73************************@posting.google.co m>...
I have a database with a Master table and a Budget table.
The Master table has all the data including these 4 fields (Enccredit,
Encdebit, Credit and Debit) and related to the Budget table.

The Budget table has the 3 fields namely:
Field 1 Category
Field 2 Budget Amt
Field 3 Costcenter Number

All these fields are related to the same fields in the Master table.

How do I create a Month-to-date column and a Year-to-date column.

Thanks

My problem is to create a report that will show Month to date

K


use a query? BETWEEN DateSerial(Month(SomeDate),1,Year(SomeDate)) AND SomeDate
YTD is same idea, just between Dateserial(1,1,Year(SomeDate)) And Date()
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.