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.
 
Back
Top