Narrowing a report using pre-defined criteria - how?

[Simon Pleasants]

Newbie question ref a database tracking orders and shipments from our
foreign factories to their final destinations:

I have a problem with a report I am trying to run. I have created a
report, and customised it to the enth degree, to display all active
shipments grouped by arrival week number and then ETA (date). This
will then be faxed to the factory who will make the various amendments
which are required.

The problem is that the report works from the entire database and
therefore includes items which have already been delivered and are
therefore no longer relevent. It also, therefore, includes deliveries
from both factories and should not.

I need to be able to narrow the report criteria down to ignore those
shipments which are completed (status field "delivered" ) and remove
reference to shipments from the other factory (order ref field
beginning "DM ").

I have read the help files but cannot work out how to limit the report
to this. It does not need to ask for user input before running the
report as the criteria for the report will always be the same.

Any help appreciated.

[Edward]

Re: Narrowing a report using pre-defined criteria - how?

Simon Pleasants <plesbit@hotmai l.com> wrote in message news:<e0fs80h25 72sj0g9hr1d8ldd d4kgqho0iu@4ax. com>...[color=blue]
> Newbie question ref a database tracking orders and shipments from our
> foreign factories to their final destinations:
>
> I have a problem with a report I am trying to run. I have created a
> report, and customised it to the enth degree, to display all active
> shipments grouped by arrival week number and then ETA (date). This
> will then be faxed to the factory who will make the various amendments
> which are required.
>
> The problem is that the report works from the entire database and
> therefore includes items which have already been delivered and are
> therefore no longer relevent. It also, therefore, includes deliveries
> from both factories and should not.
>
> I need to be able to narrow the report criteria down to ignore those
> shipments which are completed (status field "delivered" ) and remove
> reference to shipments from the other factory (order ref field
> beginning "DM ").
>
> I have read the help files but cannot work out how to limit the report
> to this. It does not need to ask for user input before running the
> report as the criteria for the report will always be the same.
>
> Any help appreciated.[/color]

What is the data source for the report? Whatever, change it to a
query such as:

<AIR CODE>

SELECT * FROM MyTable WHERE (StatusField <> "Delivered" ) AND
(OrderRefField NOT LIKE "DM*")

</AIR CODE>

HTH

Edward
--
The reading group's reading group:

http://www.bookgroup.org.uk

[neptune]

Re: Narrowing a report using pre-defined criteria - how?

> I need to be able to narrow the report criteria down to ignore those[color=blue]
> shipments which are completed (status field "delivered" ) and remove
> reference to shipments from the other factory (order ref field
> beginning "DM ").[/color]

The report should be based off a query. In the query criteria, under
the status field type <>"delivered" and in the order ref field type
<>like ("DM*").

[Simon Pleasants]

Re: Narrowing a report using pre-defined criteria - how?

On 27 Apr 2004 09:43:22 -0700, bsimmons1482@ho tmail.com (neptune)
wrote:
[color=blue][color=green]
>> I need to be able to narrow the report criteria down to ignore those
>> shipments which are completed (status field "delivered" ) and remove
>> reference to shipments from the other factory (order ref field
>> beginning "DM ").[/color]
>
>The report should be based off a query. In the query criteria, under
>the status field type <>"delivered" and in the order ref field type
><>like ("DM*").[/color]

I have been trying to do that but so far failed to make it work. I
have been pouring through the related help files to no avail. It
strikes me as something which should be really basic and easy to do
and I getting very frustrated at not being able to find it.

Any further help appreciated.

[Simon Pleasants]

Re: Narrowing a report using pre-defined criteria - how?

On Thu, 29 Apr 2004 14:38:40 +0100, Simon Pleasants
<plesbit@hotmai l.com> wrote:
[color=blue]
>On 27 Apr 2004 09:43:22 -0700, bsimmons1482@ho tmail.com (neptune)
>wrote:
>[color=green][color=darkred]
>>> I need to be able to narrow the report criteria down to ignore those
>>> shipments which are completed (status field "delivered" ) and remove
>>> reference to shipments from the other factory (order ref field
>>> beginning "DM ").[/color]
>>
>>The report should be based off a query. In the query criteria, under
>>the status field type <>"delivered" and in the order ref field type
>><>like ("DM*").[/color]
>
>I have been trying to do that but so far failed to make it work. I
>have been pouring through the related help files to no avail. It
>strikes me as something which should be really basic and easy to do
>and I getting very frustrated at not being able to find it.
>
>Any further help appreciated.[/color]

And indeed it was staring me in the face. I shall now go away and
kick myself repeatedly - no further help required.