Parameter query for monthly report

[Guest]

I created a database to track cell phone bills and minute usage. I would like
to create a monthly report. How do I create a parameter query that will allow
the user to print only the selected month column? (i.e., columns set up are
Jan, Feb, Mar etc.)

Hope this makes sense.

 

[Guest]

You need to change your dtabase structure from spreadsheet to relational
database. Use a separate record and not a different field to indicate the
month.

 

[Guest]

Ida,
Not sure if I am undestanding the question correctly, but it looks like you
may have a bad table design. Do you have columns in your table named Jan,
Feb, March, ....?
If so you really need to change the table design. You should have a column
that stores the month/Date (and I would suggest year), one for the minutes,
and one for the cost if so desired, and any other items you would like to
track (user?). Then the queary becomes very simple. You would then select
the name of the month field and in the criteria area enter the month you are
interested in.

 

[Mgurner]

Try placing the following criteria in your query under the date field (eliminate the quotes)
"Between [Enter Start Date:] and [Enter End Date:]"

When the query is executed it will ask you for a START DATE and an END DATE