In a Report - Search and report only on inputed field

  • Thread starter Thread starter Toan Chau
  • Start date Start date
T

Toan Chau

Hi All!

I have a database with a field for 3 of our remote office
branches (Anaheim, Sacramento, Fresno).

Currently, if I wanted to sort my database based on one of
these branches I would have to create 3 separte queries
for each of these branches as well as 3 separate reports.

So that brings us to my question. Is it possible to allow
the user to input what office branch they want to view and
a report will generated based on their choice?

A Thousand thanks in advance!

--Toan
 
Toan

In the criteria line of your branch office field your query builder,
instead of typing "anaheim" to sect anaheim data put the following [Which
Office] (be sure to include the square brackets).

When you run your query, it will ask you for a value for "Which Office"
type in Anahiem, or sacramento or fresno to get what you need.

Build a report based on that query.

Tom
 
A thousand thanks sir! It worked!

-----Original Message-----
Toan

In the criteria line of your branch office field your query builder,
instead of typing "anaheim" to sect anaheim data put the following [Which
Office] (be sure to include the square brackets).

When you run your query, it will ask you for a value for "Which Office"
type in Anahiem, or sacramento or fresno to get what you need.

Build a report based on that query.

Tom

Hi All!

I have a database with a field for 3 of our remote office
branches (Anaheim, Sacramento, Fresno).

Currently, if I wanted to sort my database based on one of
these branches I would have to create 3 separte queries
for each of these branches as well as 3 separate reports.

So that brings us to my question. Is it possible to allow
the user to input what office branch they want to view and
a report will generated based on their choice?

A Thousand thanks in advance!

--Toan
Click to expand...


.
Click to expand...
 
It is a trick you will surely find many uses for


Toan Chau said:
A thousand thanks sir! It worked!

-----Original Message-----
Toan

In the criteria line of your branch office field your query builder,
instead of typing "anaheim" to sect anaheim data put the following [Which
Office] (be sure to include the square brackets).

When you run your query, it will ask you for a value for "Which Office"
type in Anahiem, or sacramento or fresno to get what you need.

Build a report based on that query.

Tom

Hi All!

I have a database with a field for 3 of our remote office
branches (Anaheim, Sacramento, Fresno).

Currently, if I wanted to sort my database based on one of
these branches I would have to create 3 separte queries
for each of these branches as well as 3 separate reports.

So that brings us to my question. Is it possible to allow
the user to input what office branch they want to view and
a report will generated based on their choice?

A Thousand thanks in advance!

--Toan
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top