Date control on reports and other stuff

[dazedandconfused]

Hi everyone,

I'm new on here so please forgive any dull questions!

I have started using Access 97 for the very first time, and have no other experience of using database building software. I am writing a database to record our organisation's casework which includes person information, incidents, actions, outcomes, reports and a knowledge base. I need to ask a couple of questions but I'll just put the reporting one in here - forgive the duplicated posts in other areas!

I think I pretty much have the production of reports sussed, apart from a few minor things. In the Servicecall management template the database asks for a date range field before producing the report - I can't for the life of me work out how. I'd also quite like to put a separate filter to output a report by certain fields as well. Can anyone enlighten me?

Secondly, how do I get totals for certain fields, whether they are text or number?

Finally, the chart report wizard isn't very good. Can I edit the charts themselves when they are produced?

Many thanks in advance for any help!

 

[GaryPanic]

Hi everyone,

I'm new on here so please forgive any dull questions!

I have started using Access 97 for the very first time, and have no other experience of using database building software. I am writing a database to record our organisation's casework which includes person information, incidents, actions, outcomes, reports and a knowledge base. I need to ask a couple of questions but I'll just put the reporting one in here - forgive the duplicated posts in other areas!

I think I pretty much have the production of reports sussed, apart from a few minor things. In the Servicecall management template the database asks for a date range field before producing the report - I can't for the life of me work out how. I'd also quite like to put a separate filter to output a report by certain fields as well. Can anyone enlighten me?

Secondly, how do I get totals for certain fields, whether they are text or number?

Finally, the chart report wizard isn't very good. Can I edit the charts themselves when they are produced?

Many thanks in advance for any help!

you need to understand qrys and tieing them to forms to ask for date ranges
you can build a form with from and to fields on them , then add a button to your your report , your query on which your report is run then has to look back to the form for the date range to run from it would look like
between Forms ![formname]![fieldname1[ And Forms ![formname]![fieldname2]

totals are easy but only ffor figures - cannot total text = example = sum[fieldonreport]


chart wizard is way out of my league - but most posts seem to have a real problem with charts - dump the info in xls and do your charts from here

 

[dazedandconfused]

If I need to understand qrys and tieing them to forms for date ranges, that´s probably why I asked the question in the first place?

´How´ is really the big issue here...