A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

criteria NOT working



 
 
Thread Tools Display Modes
  #1  
Old May 25th, 2004, 11:11 AM
angie
external usenet poster
 
Posts: n/a
Default criteria NOT working

i have created a report based on a query (based on another query) for which i have specified certain criteria.

the query is working but the report i have created based on that query does not meet the criteria. it "ignores" them.

what may be not working well?
  #2  
Old May 25th, 2004, 11:39 AM
Tom Lake
external usenet poster
 
Posts: n/a
Default criteria NOT working

i have created a report based on a query (based on another query) for
which i have specified certain criteria.

the query is working but the report i have created based on that query

does not meet the criteria. it "ignores" them.

what may be not working well?


It's hard to say without knowing what fields you have and what the data and
criteria are.

Tom Lake


  #3  
Old May 25th, 2004, 12:56 PM
angie
external usenet poster
 
Posts: n/a
Default ΘΕΜΑ: criteria NOT working

the original query combines data from multiple tables. then another query (on which the report is based) uses certain fields from the original query. among these fields i have set simple criteria for two of the fields: i.e. to a paricular field value. the query is working fine but the report isn't. if there was something wrong with the criteria shouldn't the report not be working also?

----- Tom Lake *γραψε: -----

i have created a report based on a query (based on another query) for

which i have specified certain criteria.
the query is working but the report i have created based on that query

does not meet the criteria. it "ignores" them.
what may be not working well?


It's hard to say without knowing what fields you have and what the data and
criteria are.

Tom Lake



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:45 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.