By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,550 Members | 2,725 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,550 IT Pros & Developers. It's quick & easy.

Narrowing a report using pre-defined criteria - how?

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Simon Pleasants <pl*****@hotmail.com> wrote in message news:<e0********************************@4ax.com>. ..
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.


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
Nov 12 '05 #2

P: n/a
> 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 ").


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*").
Nov 12 '05 #3

P: n/a
On 27 Apr 2004 09:43:22 -0700, bs**********@hotmail.com (neptune)
wrote:
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 ").


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*").


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.
Nov 12 '05 #4

P: n/a
On Thu, 29 Apr 2004 14:38:40 +0100, Simon Pleasants
<pl*****@hotmail.com> wrote:
On 27 Apr 2004 09:43:22 -0700, bs**********@hotmail.com (neptune)
wrote:
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 ").


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*").


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.


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

This discussion thread is closed

Replies have been disabled for this discussion.