Select a day in a month

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

Guest

H

My query needs to select a day in a month so that I can calculate the percentage change for the month on the last day of any particular month. The data is entered daily (working days only) for a number of client accounts. The fields are, [Date], [Client], [PortfolioValue]. The portfolio performance is the required answer to the query

thank you
 
Shaheed

If you have a field named "Date", both you and Access will be confused --
this is a reserved word in Access. Consider changing the fieldname to
something else, perhaps RecordingDate.

To select a specific date, add a parameter to your query's criterion under
your date/recordingdate field. Prompt the user for a date.
 
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

Excel Message box with days of month & date. 1
Calculating the days in a month 3
Week, monthly, quarterly 2
Excel Monthly Spread sheet. 12
Days in part of the month 1
Month, DATE, Week 7
Access Count dates within a Month 4
Excel Vba to change displayed year automatically. 14

Back
Top