Expressions in a query

[Guest]

I am a 1 college class database user. I am struggling with queries. I have
a database that has a column for status open or close. If I want a query
that shows only "open" orders, how would I create an expression to do this.

Additionally, any tips on queries in general would be helpful.

Any help is much appreciated.

 

[Guest]

Hi

Put "open" in the criteria row
Or
Put [Please enter open or close] in the criteria row to prompt users
for input (this is better as you may want to see the closed items one day)

Good luck with your project

 

[Guest]

Thank you. I had it there but I realize my problem lies with my report. My
report is coming from my database and not the query that has the open only
orders.

Is there a way to change the report from pulling it from the database to the
query without having to create a new report? I made so many changes to the
report view, it took a long time to get it right.

Hi

Put "open" in the criteria row
Or
Put [Please enter open or close] in the criteria row to prompt users
for input (this is better as you may want to see the closed items one day)

Good luck with your project


--
Wayne
Manchester, England.

I am a 1 college class database user. I am struggling with queries. I have
a database that has a column for status open or close. If I want a query
that shows only "open" orders, how would I create an expression to do this.

Additionally, any tips on queries in general would be helpful.

Any help is much appreciated.

 

[Guest]

It simple

"providing that the names are the same in the query / table and there are no
calcuated fields in the report that contain names not in the tables.

MAKE A COPY OF YOUR REPORT 1ST - just in case <

Then on the copy
Open in design view
Select source from the data column of the properties box
On the drop down select the query containing th open option
View in noraml view and if you are lucky it will work if not you will be
prompted for any missing fields.
In this case go to the query and ensure the missing field are included in
the query.



--
Wayne
Manchester, England.

Thank you. I had it there but I realize my problem lies with my report. My
report is coming from my database and not the query that has the open only
orders.

Is there a way to change the report from pulling it from the database to the
query without having to create a new report? I made so many changes to the
report view, it took a long time to get it right.

Hi

Put "open" in the criteria row
Or
Put [Please enter open or close] in the criteria row to prompt users
for input (this is better as you may want to see the closed items one day)

Good luck with your project


--
Wayne
Manchester, England.

I am a 1 college class database user. I am struggling with queries. I have
a database that has a column for status open or close. If I want a query
that shows only "open" orders, how would I create an expression to do this.

Additionally, any tips on queries in general would be helpful.

Any help is much appreciated.