Help me with query...........Please

[Dennis Franco]

I have a access2000 data base and in one field, the "descripion"
field, I have data like:

1920 St. Louis geophysical Map

1988 England CIA map

I want to run a report that will separate all the CIA maps or all the
geophysical maps in the data base from other items.

Thanks

Dennis Franco
dm******@hotmail.com

[Fredg]

Dennis,
Use a query as report record source.

If there are only 2 choices, CIA or Geophysical, then as criteria for the
Description field, write:
Like IIf([Enter choice c/g] = "c","*CIA*","*geophysical*")

When prompted, enter a c for CIA records. Any other entry will return
geophysical records.

If you have more choices, use a combo box on a form to select the value and
change the criteria to something like:
Like "*" & forms!FormName!ComboName & "*"
The combo box in this case should show the full "CIA" or "geophysical", or
other name.

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.
"Dennis Franco" <dm******@hotmail.com> wrote in message
news:a6**************************@posting.google.c om...

I have a access2000 data base and in one field, the "descripion"
field, I have data like:

1920 St. Louis geophysical Map

1988 England CIA map

I want to run a report that will separate all the CIA maps or all the
geophysical maps in the data base from other items.

Thanks

Dennis Franco
dm******@hotmail.com

[Rui Patinha]

hi!

you can try the SPLIT function to split the string into one array... the go
to the array index that you need and do a IF to check if it is a geowhatever
or a cia map...

hth
Rui Patinha

"Dennis Franco" <dm******@hotmail.com> escreveu na mensagem
news:a6**************************@posting.google.c om...

I have a access2000 data base and in one field, the "descripion"
field, I have data like:

1920 St. Louis geophysical Map

1988 England CIA map

I want to run a report that will separate all the CIA maps or all the
geophysical maps in the data base from other items.

Thanks

Dennis Franco
dm******@hotmail.com

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

In the reports Group/Sort dialog box put something like this:

=InStr([Description],"CIA")>0 Ascending
=InStr([Description],"geophy")>0 Ascending

This will sort the detail section by the Description field. The sort
will separate the CIA maps from the geophysical maps.

HTH,

MGFoster:::mgf
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP7WbZYechKqOuFEgEQKuvwCfT56Pez4WCONB1i+F7vGqG8 3bRlQAoIg/
ZnfOSrGJ+4amKsHJuvQ/MTKv
=6uHx
-----END PGP SIGNATURE-----
Rui Patinha wrote:

hi!

you can try the SPLIT function to split the string into one array... the go
to the array index that you need and do a IF to check if it is a geowhatever
or a cia map...

hth
Rui Patinha

"Dennis Franco" <dm******@hotmail.com> escreveu na mensagem
news:a6**************************@posting.google.c om...

I have a access2000 data base and in one field, the "descripion"
field, I have data like:

1920 St. Louis geophysical Map

1988 England CIA map

I want to run a report that will separate all the CIA maps or all the
geophysical maps in the data base from other items.

Thanks

Dennis Franco
dm******@hotmail.com