how to pull out reports for a certain month from a calculated fiel

G

Guest

Hi, I need to pull out a monthly report on a calculated field. Before I had
the calculated field, I used to input the data directly in the column so the
table column was getting populated so i was able to query on a monthy basis.

My field is a renewal date field which has this formula:

=DateAdd("yyyy",1,[carte de membre])

My query formula to pull by month reports of that field (basically to see
who is coming up for renewal) goes like this:

SELECT [Members].[Prenom], [Members].[Nom], [Members].[Date de renouvellement]
FROM Members, Inscription
WHERE (((Month([Date de renouvellement]))=[Mois]));

But since I don't populate my table with the renewal date, (it only comes
out in the report ), I don't know how to pull out reports for a certain month
only.

Any idea?

Tracy
 

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

My table field is not being populated 4
Pull Month from Full Date 10
Problem with report using IIF statement 1
How to design table for query info I need 2
Pull calculated fields from one report to another 3
Acess2000: How to get reports filter condition into reports header? 2
Obtaining Month from a Date Field 3
look for certain data on three different fields in a query 4

Top