Creating a report that has criteria

[Gar44]

Hi all,

I'm hoping someone can help me. I have created a small database for error
tracking but I need to be able to send the contents of one table as a report
every week. I only want to send the information from that specific week every
time I send it.

My first approach was to create a query that asks for criteria i.e. between
[start date] and [end date] and then create a report based on this query.
Sounds good right? The problem I’m having is that I want the report to look
really well and formatted, but each time I run the report and it asks for
input it goes back to the standard format which looks so bad.

Is there a way to create a report and format it and then after this put the
criteria into it? I will be sending the same fields every week but just with
different information. Any ideas or help anyone could offer would be really
great.

Thanks guys.

 

[John W. Vinson]

Hi all,

I'm hoping someone can help me. I have created a small database for error
tracking but I need to be able to send the contents of one table as a report
every week. I only want to send the information from that specific week every
time I send it.

My first approach was to create a query that asks for criteria i.e. between
[start date] and [end date] and then create a report based on this query.
Sounds good right? The problem I’m having is that I want the report to look
really well and formatted, but each time I run the report and it asks for
input it goes back to the standard format which looks so bad.

Is there a way to create a report and format it and then after this put the
criteria into it? I will be sending the same fields every week but just with
different information. Any ideas or help anyone could offer would be really
great.

Thanks guys.

Base the report on a Query which uses parameters for the date, i.e. set the
Report's Recordsource property to the name of the query. How are you doing it
now? What's the "standard format"? What's happened to the nice report that you
created earlier?

I would suggest going a step beyond the [start date] and [end date] prompts,
though. Instead, create a small form named (say) frmCrit, with textboxes
txtStartDate (defaulting to =DateAdd("d", -6-Weekday(Date()), Date()) to get
the previous week's Sunday) and txtEndDate (defaulting to
=DateAdd("d", 1-Weekday(Date()) to get last Sunday), and use a criterion

= [Forms]![frmCrit]![txtStart] AND < [Forms]![frmCrit]![txtEnd]

to get all the records between midnight on the two Sundays.