newbie reporting question

#1

Hello, Longtime MS Access user trying to get around FM7. I have a
computer inventory database that spans the whole state that I want to
print reports for. I only need the report by a certain city not the
whole state. In Access we had queries, but how do I create a layout
with just 1 city.

#2

In article <1125686510.511975.100210 (AT) f14g2000cwb (DOT) googlegroups.com>,
"Jake Wiley" <OEKilla (AT) msn (DOT) com> wrote:

Quote:

Hello, Longtime MS Access user trying to get around FM7. I have a
computer inventory database that spans the whole state that I want to
print reports for. I only need the report by a certain city not the
whole state. In Access we had queries, but how do I create a layout
with just 1 city.

Presumably there is a field for City.

Do a Find for the city of interest. That will take care of it.

Bill

--
For email, remove invalid.

#3

Jake Wiley <OEKilla (AT) msn (DOT) com> wrote:

Quote:

Hello, Longtime MS Access user trying to get around FM7. I have a
computer inventory database that spans the whole state that I want to
print reports for. I only need the report by a certain city not the
whole state. In Access we had queries, but how do I create a layout
with just 1 city.

In FM, queries are called "Finds" and the same layout screen (form) can
serve to display any number of found sets.

Set up the fields you want to display in addition to the City field,
then do the Find, and display the results on that report layout.

Lynn Allen
--
Allen & Allen Semiotics www.semiotics.com
FSA Associate Filemaker Design & Consulting

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

newbie reporting question

comp.databases.filemaker comp.databases.filemaker

newbie reporting question - 09-02-2005 , 01:41 PM

Re: newbie reporting question - 09-02-2005 , 02:21 PM

Re: newbie reporting question - 09-02-2005 , 02:24 PM