no. of months and no.of days

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

in my Query i have the following fields dateofS,stationName,PetrolSales...
dateofS field have date values like 02/09/2005, 03/09/2005.....etc.

in my report and chart (yearly report and monthly report) i have to display

no.of months and also days. exactly.(because some time data not available
for all dates in that month) kindly please help me..in this issue.


Thanks
 
I'm afraid I don't understand what you're looking for. What do you mean by
"no. of months and also days" in terms of a single date?
 
ismail said:
in my Query i have the following fields dateofS,stationName,PetrolSales...
dateofS field have date values like 02/09/2005, 03/09/2005.....etc.

in my report and chart (yearly report and monthly report) i have to display

no.of months and also days. exactly.(because some time data not available
for all dates in that month) kindly please help me..in this issue.


Thanks
Click to expand...

Perhaps:

http://groups.google.com/group/microsoft.public.access/msg/cf857b8e3aa9c6b0

will help get you started. Are you sure you need to do it this way?

James A. Fortune
(e-mail address removed)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

no. of days and month 13
How to reference a field of a recordset with a variable 4
Populate a table 2
Last day of month in query 15
Access Count dates within a Month 4
Multi field of date filter 2
Group by Month 2
Excel Message box with days of month & date. 1

Back
Top