|
 |
asp_databases thread: SV: Please help!-- Running Access Query--Combined criteria!!
Message #1 by "Kim Iwan Hansen" <kimiwan@k...> on Mon, 25 Mar 2002 16:11:27 +0100
|
|
hey julia,
could it be that you're looking for a string that starts with BOTH "Rock"
and "Proquest", or have i misunderstood you?
try and go "WHERE fldTitle LIKE '%Rockhurst University%' AND fldTitle LIKE
'%Proquest%'" (you may have to replace % with *, of that i'm not sure)
hope that helps,
Kim
-----Oprindelig meddelelse-----
Fra: Wang, Julia [mailto:Julia.Wang@R...]
Sendt: 25. marts 2002 15:53
Til: ASP Databases
Emne: [asp_databases] Please help!-- Running Access Query--Combined
criteria!!
Any suggestions are appreciated!!
** We have a master table named "Maetro" which holds around 1,6000 records
of journal titles of both print and electronic. The table consists of Title
column, Format (e.g. "Print" or "Electronic")column, and Location (e.g.
Library name (here "Rockhurst Unversity", and Electronic Database names like
"First Search", "Gale", "Proquest", etc.") Since there are obvious overlaps
in certain titles for both print and electronic, I need to run a combined
query to extract titles that shows up BOTH in line with "Rockhurst
University" and with one of the e-databases such as "Gale", or "Proquest",
etc. so that we can make decisions to unsubscribe the duplicate print titles
due to increasing prices.
I tried using, under criteria, Like "Rock*" and Like "Gale*" or another set
Like "Rock*" and Like "Proquest *", etc. for Print to match each type of
electronics, but it returns me "0"!!! If I run single query, there is just
no problem. And I know there are definitely duplicates!
Could any of you take some time and help me as to how to run a combined
Query?
--Thank You! Thank You! Thank You!
Please ask questions if this is not clearly stated!--Appreciated!
Message #2 by "Wang, Julia" <Julia.Wang@R...> on Mon, 25 Mar 2002 12:32:26 -0600
|
|
Kim, thanks for the response.
We subscribe to a title for instance, "Science" journal. But we also pay for
an electronic database "Peridical Abstracts.." which covers this "Science".
If I can pull out all the titles that have overlaps, we can decide to cancel
the print subscriptions and use the e-databases alone. That will save us
money. But the problem is when I use the combined criteria, it gives me "0"
record!
This is what I did:
SELECT MasterHoldings.Title, MasterHoldings.Format, MasterHoldings.Location
FROM MasterHoldings
WHERE (((MasterHoldings.Location) Like "Rock*" And (MasterHoldings.Location)
Like "Periodical *"));
Dose this help?
Thanks!
Julia
-----Original Message-----
From: Kim Iwan Hansen [mailto:kimiwan@k...]
Sent: Monday, March 25, 2002 9:11 AM
To: ASP Databases
Subject: [asp_databases] SV: Please help!-- Running Access
Query--Combined criteria!!
hey julia,
could it be that you're looking for a string that starts with BOTH "Rock"
and "Proquest", or have i misunderstood you?
try and go "WHERE fldTitle LIKE '%Rockhurst University%' AND fldTitle LIKE
'%Proquest%'" (you may have to replace % with *, of that i'm not sure)
hope that helps,
Kim
-----Oprindelig meddelelse-----
Fra: Wang, Julia [mailto:Julia.Wang@R...]
Sendt: 25. marts 2002 15:53
Til: ASP Databases
Emne: [asp_databases] Please help!-- Running Access Query--Combined
criteria!!
Any suggestions are appreciated!!
** We have a master table named "Maetro" which holds around 1,6000 records
of journal titles of both print and electronic. The table consists of Title
column, Format (e.g. "Print" or "Electronic")column, and Location (e.g.
Library name (here "Rockhurst Unversity", and Electronic Database names like
"First Search", "Gale", "Proquest", etc.") Since there are obvious overlaps
in certain titles for both print and electronic, I need to run a combined
query to extract titles that shows up BOTH in line with "Rockhurst
University" and with one of the e-databases such as "Gale", or "Proquest",
etc. so that we can make decisions to unsubscribe the duplicate print titles
due to increasing prices.
I tried using, under criteria, Like "Rock*" and Like "Gale*" or another set
Like "Rock*" and Like "Proquest *", etc. for Print to match each type of
electronics, but it returns me "0"!!! If I run single query, there is just
no problem. And I know there are definitely duplicates!
Could any of you take some time and help me as to how to run a combined
Query?
--Thank You! Thank You! Thank You!
Please ask questions if this is not clearly stated!--Appreciated!
Message #3 by "Drew, Ron" <RDrew@B...> on Mon, 25 Mar 2002 13:54:42 -0500
|
|
Not sure yet what you mean...can u give me an example of a duplicate
record? You may be able to do a:
Select Title, Format, Location from MasterHoldings
Where ..to be determined if you need it
Group by Title, Format, Location
Having count(*) > 1
Order by Title, Format, Location
-----Original Message-----
From: Wang, Julia [mailto:Julia.Wang@R...]
Sent: Monday, March 25, 2002 1:32 PM
To: ASP Databases
Subject: [asp_databases] RE: SV: Please help!-- Running Access
Query--Comb ined criteria!!
Kim, thanks for the response.
We subscribe to a title for instance, "Science" journal. But we also pay
for an electronic database "Peridical Abstracts.." which covers this
"Science". If I can pull out all the titles that have overlaps, we can
decide to cancel the print subscriptions and use the e-databases alone.
That will save us money. But the problem is when I use the combined
criteria, it gives me "0" record!
This is what I did:
SELECT MasterHoldings.Title, MasterHoldings.Format,
MasterHoldings.Location FROM MasterHoldings WHERE
(((MasterHoldings.Location) Like "Rock*" And (MasterHoldings.Location)
Like "Periodical *"));
Dose this help?
Thanks!
Julia
-----Original Message-----
From: Kim Iwan Hansen [mailto:kimiwan@k...]
Sent: Monday, March 25, 2002 9:11 AM
To: ASP Databases
Subject: [asp_databases] SV: Please help!-- Running Access
Query--Combined criteria!!
hey julia,
could it be that you're looking for a string that starts with BOTH
"Rock" and "Proquest", or have i misunderstood you?
try and go "WHERE fldTitle LIKE '%Rockhurst University%' AND fldTitle
LIKE '%Proquest%'" (you may have to replace % with *, of that i'm not
sure)
hope that helps,
Kim
-----Oprindelig meddelelse-----
Fra: Wang, Julia [mailto:Julia.Wang@R...]
Sendt: 25. marts 2002 15:53
Til: ASP Databases
Emne: [asp_databases] Please help!-- Running Access Query--Combined
criteria!!
Any suggestions are appreciated!!
** We have a master table named "Maetro" which holds around 1,6000
records of journal titles of both print and electronic. The table
consists of Title column, Format (e.g. "Print" or "Electronic")column,
and Location (e.g. Library name (here "Rockhurst Unversity", and
Electronic Database names like "First Search", "Gale", "Proquest",
etc.") Since there are obvious overlaps in certain titles for both print
and electronic, I need to run a combined query to extract titles that
shows up BOTH in line with "Rockhurst University" and with one of the
e-databases such as "Gale", or "Proquest", etc. so that we can make
decisions to unsubscribe the duplicate print titles due to increasing
prices.
I tried using, under criteria, Like "Rock*" and Like "Gale*" or another
set Like "Rock*" and Like "Proquest *", etc. for Print to match each
type of electronics, but it returns me "0"!!! If I run single query,
there is just no problem. And I know there are definitely duplicates!
Could any of you take some time and help me as to how to run a combined
Query? --Thank You! Thank You! Thank You!
Please ask questions if this is not clearly stated!--Appreciated!
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
Message #4 by "Kim Iwan Hansen" <kimiwan@k...> on Mon, 25 Mar 2002 20:12:01 +0100
|
|
Julia,
* acts as a wild card - but only on the side of the word it's placed.
Rock* fits every field that BEGINS with "Rock"
Periodical * fits every field that BEGINS with "Periodical "
So in effect you're saying "pick format and location from the table
masterholdings, where the field location begins with "Rock" and also begins
with "periodical".
One field can't BEGIN with more than one thing.
What you want is to find anything that CONTAINS "Rock" or "Periodical"
*Rock* fits every field that CONTAINS "Rock"
*periodical* fits every field that CONTAINS "periodical"
To complete the examples, *Rock fits every field that ENDS on "Rock".
Better? :o)
-----Original Message-----
From: Wang, Julia [mailto:Julia.Wang@R...]
Sent: 25. marts 2002 19:32
To: ASP Databases
Subject: [asp_databases] RE: SV: Please help!-- Running Access
Query--Comb ined criteria!!
Kim, thanks for the response.
We subscribe to a title for instance, "Science" journal. But we also pay for
an electronic database "Peridical Abstracts.." which covers this "Science".
If I can pull out all the titles that have overlaps, we can decide to cancel
the print subscriptions and use the e-databases alone. That will save us
money. But the problem is when I use the combined criteria, it gives me "0"
record!
This is what I did:
SELECT MasterHoldings.Title, MasterHoldings.Format, MasterHoldings.Location
FROM MasterHoldings
WHERE (((MasterHoldings.Location) Like "Rock*" And (MasterHoldings.Location)
Like "Periodical *"));
Dose this help?
Thanks!
Julia
-----Original Message-----
From: Kim Iwan Hansen [mailto:kimiwan@k...]
Sent: Monday, March 25, 2002 9:11 AM
To: ASP Databases
Subject: [asp_databases] SV: Please help!-- Running Access
Query--Combined criteria!!
hey julia,
could it be that you're looking for a string that starts with BOTH "Rock"
and "Proquest", or have i misunderstood you?
try and go "WHERE fldTitle LIKE '%Rockhurst University%' AND fldTitle LIKE
'%Proquest%'" (you may have to replace % with *, of that i'm not sure)
hope that helps,
Kim
-----Oprindelig meddelelse-----
Fra: Wang, Julia [mailto:Julia.Wang@R...]
Sendt: 25. marts 2002 15:53
Til: ASP Databases
Emne: [asp_databases] Please help!-- Running Access Query--Combined
criteria!!
Any suggestions are appreciated!!
** We have a master table named "Maetro" which holds around 1,6000 records
of journal titles of both print and electronic. The table consists of Title
column, Format (e.g. "Print" or "Electronic")column, and Location (e.g.
Library name (here "Rockhurst Unversity", and Electronic Database names like
"First Search", "Gale", "Proquest", etc.") Since there are obvious overlaps
in certain titles for both print and electronic, I need to run a combined
query to extract titles that shows up BOTH in line with "Rockhurst
University" and with one of the e-databases such as "Gale", or "Proquest",
etc. so that we can make decisions to unsubscribe the duplicate print titles
due to increasing prices.
I tried using, under criteria, Like "Rock*" and Like "Gale*" or another set
Like "Rock*" and Like "Proquest *", etc. for Print to match each type of
electronics, but it returns me "0"!!! If I run single query, there is just
no problem. And I know there are definitely duplicates!
Could any of you take some time and help me as to how to run a combined
Query?
--Thank You! Thank You! Thank You!
Please ask questions if this is not clearly stated!--Appreciated!
Message #5 by "Wang, Julia" <Julia.Wang@R...> on Tue, 26 Mar 2002 08:24:16 -0600
|
|
Thank you all for offering help and suggestions!
It dawned on me last night that Kim and Thomas were right! The only thing i
can use is OR! There is no "Rock" and "Periodical" in the same field! But
this is also what I have tried to avoid because instead of giving me every
title ONCE that meets both conditions, it lists me the title seperately for
"Periodical" after it finishes all the "Rock" match! So this makes it a
tremendous long list and hundreds of pages to print.
I guess it will get more complicated to format to the way I want it such as:
Title Location Location
Journal of Medicine Rockhurst Periodical
Music Rockhurst
...
Sincerely,
Julia
-----Original Message-----
From: Kim Iwan Hansen [mailto:kimiwan@k...]
Sent: Monday, March 25, 2002 1:12 PM
To: ASP Databases
Subject: [asp_databases] RE: SV: Please help!-- Running Access
Query--Comb ined criteria!!
Julia,
* acts as a wild card - but only on the side of the word it's placed.
Rock* fits every field that BEGINS with "Rock"
Periodical * fits every field that BEGINS with "Periodical "
So in effect you're saying "pick format and location from the table
masterholdings, where the field location begins with "Rock" and also begins
with "periodical".
One field can't BEGIN with more than one thing.
What you want is to find anything that CONTAINS "Rock" or "Periodical"
*Rock* fits every field that CONTAINS "Rock"
*periodical* fits every field that CONTAINS "periodical"
To complete the examples, *Rock fits every field that ENDS on "Rock".
Better? :o)
-----Original Message-----
From: Wang, Julia [mailto:Julia.Wang@R...]
Sent: 25. marts 2002 19:32
To: ASP Databases
Subject: [asp_databases] RE: SV: Please help!-- Running Access
Query--Comb ined criteria!!
Kim, thanks for the response.
We subscribe to a title for instance, "Science" journal. But we also pay for
an electronic database "Peridical Abstracts.." which covers this "Science".
If I can pull out all the titles that have overlaps, we can decide to cancel
the print subscriptions and use the e-databases alone. That will save us
money. But the problem is when I use the combined criteria, it gives me "0"
record!
This is what I did:
SELECT MasterHoldings.Title, MasterHoldings.Format, MasterHoldings.Location
FROM MasterHoldings
WHERE (((MasterHoldings.Location) Like "Rock*" And (MasterHoldings.Location)
Like "Periodical *"));
Dose this help?
Thanks!
Julia
-----Original Message-----
From: Kim Iwan Hansen [mailto:kimiwan@k...]
Sent: Monday, March 25, 2002 9:11 AM
To: ASP Databases
Subject: [asp_databases] SV: Please help!-- Running Access
Query--Combined criteria!!
hey julia,
could it be that you're looking for a string that starts with BOTH "Rock"
and "Proquest", or have i misunderstood you?
try and go "WHERE fldTitle LIKE '%Rockhurst University%' AND fldTitle LIKE
'%Proquest%'" (you may have to replace % with *, of that i'm not sure)
hope that helps,
Kim
-----Oprindelig meddelelse-----
Fra: Wang, Julia [mailto:Julia.Wang@R...]
Sendt: 25. marts 2002 15:53
Til: ASP Databases
Emne: [asp_databases] Please help!-- Running Access Query--Combined
criteria!!
Any suggestions are appreciated!!
** We have a master table named "Maetro" which holds around 1,6000 records
of journal titles of both print and electronic. The table consists of Title
column, Format (e.g. "Print" or "Electronic")column, and Location (e.g.
Library name (here "Rockhurst Unversity", and Electronic Database names like
"First Search", "Gale", "Proquest", etc.") Since there are obvious overlaps
in certain titles for both print and electronic, I need to run a combined
query to extract titles that shows up BOTH in line with "Rockhurst
University" and with one of the e-databases such as "Gale", or "Proquest",
etc. so that we can make decisions to unsubscribe the duplicate print titles
due to increasing prices.
I tried using, under criteria, Like "Rock*" and Like "Gale*" or another set
Like "Rock*" and Like "Proquest *", etc. for Print to match each type of
electronics, but it returns me "0"!!! If I run single query, there is just
no problem. And I know there are definitely duplicates!
Could any of you take some time and help me as to how to run a combined
Query?
--Thank You! Thank You! Thank You!
Please ask questions if this is not clearly stated!--Appreciated!
Message #6 by "Peter Foti (PeterF)" <PeterF@S...> on Tue, 26 Mar 2002 10:24:31 -0500
|
|
Hi Julia,
That's precisely why I was suggesting a 2nd query that runs only if the
first one gets results. :)
I think the best thing to do would be to normalize the data a little
better and redesign the database. It won't solve your problem, but it
might make it a little easier to work with, and will reduce the size of
the database. But that might take more time than you can put into it.
I would start by pulling out the Title and the Format into their own
tables.
Table Titles:
-------------
TitleID
Title
Table Formats:
--------------
FormatID
Format
Table Maestro:
--------------
mID
TitleID
YearsA
Holdings
FormatID
Location
But that's just me. :)
Good luck,
Pete
> -----Original Message-----
> From: Wang, Julia [mailto:Julia.Wang@R...]
> Sent: Tuesday, March 26, 2002 9:24 AM
> To: ASP Databases
> Subject: [asp_databases] RE: SV: Please help!-- Running Access Query--
> Comb ined criteria!!
>
>
> Thank you all for offering help and suggestions!
>
> It dawned on me last night that Kim and Thomas were right!
> The only thing i
> can use is OR! There is no "Rock" and "Periodical" in the
> same field! But
> this is also what I have tried to avoid because instead of
> giving me every
> title ONCE that meets both conditions, it lists me the title
> seperately for
> "Periodical" after it finishes all the "Rock" match! So this
> makes it a
> tremendous long list and hundreds of pages to print.
>
> I guess it will get more complicated to format to the way I
> want it such as:
>
> Title Location Location
> Journal of Medicine Rockhurst Periodical
> Music Rockhurst
>
> ...
>
>
> Sincerely,
>
> Julia
> -----Original Message-----
> From: Kim Iwan Hansen [mailto:kimiwan@k...]
> Sent: Monday, March 25, 2002 1:12 PM
> To: ASP Databases
> Subject: [asp_databases] RE: SV: Please help!-- Running Access
> Query--Comb ined criteria!!
>
>
> Julia,
>
> * acts as a wild card - but only on the side of the word it's placed.
>
> Rock* fits every field that BEGINS with "Rock"
> Periodical * fits every field that BEGINS with "Periodical "
>
>
> So in effect you're saying "pick format and location from the table
> masterholdings, where the field location begins with "Rock"
> and also begins
> with "periodical".
>
> One field can't BEGIN with more than one thing.
>
>
> What you want is to find anything that CONTAINS "Rock" or "Periodical"
>
> *Rock* fits every field that CONTAINS "Rock"
> *periodical* fits every field that CONTAINS "periodical"
>
>
> To complete the examples, *Rock fits every field that ENDS on "Rock".
>
> Better? :o)
>
>
> -----Original Message-----
> From: Wang, Julia [mailto:Julia.Wang@R...]
> Sent: 25. marts 2002 19:32
> To: ASP Databases
> Subject: [asp_databases] RE: SV: Please help!-- Running Access
> Query--Comb ined criteria!!
>
>
> Kim, thanks for the response.
>
> We subscribe to a title for instance, "Science" journal. But
> we also pay for
> an electronic database "Peridical Abstracts.." which covers
> this "Science".
> If I can pull out all the titles that have overlaps, we can
> decide to cancel
> the print subscriptions and use the e-databases alone. That
> will save us
> money. But the problem is when I use the combined criteria,
> it gives me "0"
> record!
>
> This is what I did:
>
> SELECT MasterHoldings.Title, MasterHoldings.Format,
> MasterHoldings.Location
> FROM MasterHoldings
> WHERE (((MasterHoldings.Location) Like "Rock*" And
> (MasterHoldings.Location)
> Like "Periodical *"));
>
> Dose this help?
>
> Thanks!
>
> Julia
> -----Original Message-----
> From: Kim Iwan Hansen [mailto:kimiwan@k...]
> Sent: Monday, March 25, 2002 9:11 AM
> To: ASP Databases
> Subject: [asp_databases] SV: Please help!-- Running Access
> Query--Combined criteria!!
>
>
> hey julia,
>
> could it be that you're looking for a string that starts with
> BOTH "Rock"
> and "Proquest", or have i misunderstood you?
>
> try and go "WHERE fldTitle LIKE '%Rockhurst University%' AND
> fldTitle LIKE
> '%Proquest%'" (you may have to replace % with *, of that i'm
> not sure)
>
> hope that helps,
>
> Kim
>
>
>
>
> -----Oprindelig meddelelse-----
> Fra: Wang, Julia [mailto:Julia.Wang@R...]
> Sendt: 25. marts 2002 15:53
> Til: ASP Databases
> Emne: [asp_databases] Please help!-- Running Access Query--Combined
> criteria!!
>
>
>
> Any suggestions are appreciated!!
>
> ** We have a master table named "Maetro" which holds around
> 1,6000 records
> of journal titles of both print and electronic. The table
> consists of Title
> column, Format (e.g. "Print" or "Electronic")column, and
> Location (e.g.
> Library name (here "Rockhurst Unversity", and Electronic
> Database names like
> "First Search", "Gale", "Proquest", etc.") Since there are
> obvious overlaps
> in certain titles for both print and electronic, I need to
> run a combined
> query to extract titles that shows up BOTH in line with "Rockhurst
> University" and with one of the e-databases such as "Gale",
> or "Proquest",
> etc. so that we can make decisions to unsubscribe the
> duplicate print titles
> due to increasing prices.
>
> I tried using, under criteria, Like "Rock*" and Like "Gale*"
> or another set
> Like "Rock*" and Like "Proquest *", etc. for Print to match
> each type of
> electronics, but it returns me "0"!!! If I run single query,
> there is just
> no problem. And I know there are definitely duplicates!
>
> Could any of you take some time and help me as to how to run
> a combined
> Query?
> --Thank You! Thank You! Thank You!
>
> Please ask questions if this is not clearly stated!--Appreciated!
>
>
>
>
>
>
>
>
>
>
Message #7 by "Wang, Julia" <Julia.Wang@R...> on Tue, 26 Mar 2002 09:50:07 -0600
|
|
Thanks a lot, Peter! This is a very good piece of advice and suggestion! I
will refresh myself more on ACCESS before I can start this new project, and
probably will raise more questions by then.
I sincerely appreciate your time and willing to share your wealth of
knowledge!
Have a good day!
Julia
-----Original Message-----
From: Peter Foti (PeterF) [mailto:PeterF@S...]
Sent: Tuesday, March 26, 2002 9:25 AM
To: ASP Databases
Subject: [asp_databases] RE: SV: Please help!-- Running Access Query--
Comb ined criteria!!
Hi Julia,
That's precisely why I was suggesting a 2nd query that runs only if the
first one gets results. :)
I think the best thing to do would be to normalize the data a little
better and redesign the database. It won't solve your problem, but it
might make it a little easier to work with, and will reduce the size of
the database. But that might take more time than you can put into it.
I would start by pulling out the Title and the Format into their own
tables.
Table Titles:
-------------
TitleID
Title
Table Formats:
--------------
FormatID
Format
Table Maestro:
--------------
mID
TitleID
YearsA
Holdings
FormatID
Location
But that's just me. :)
Good luck,
Pete
> -----Original Message-----
> From: Wang, Julia [mailto:Julia.Wang@R...]
> Sent: Tuesday, March 26, 2002 9:24 AM
> To: ASP Databases
> Subject: [asp_databases] RE: SV: Please help!-- Running Access Query--
> Comb ined criteria!!
>
>
> Thank you all for offering help and suggestions!
>
> It dawned on me last night that Kim and Thomas were right!
> The only thing i
> can use is OR! There is no "Rock" and "Periodical" in the
> same field! But
> this is also what I have tried to avoid because instead of
> giving me every
> title ONCE that meets both conditions, it lists me the title
> seperately for
> "Periodical" after it finishes all the "Rock" match! So this
> makes it a
> tremendous long list and hundreds of pages to print.
>
> I guess it will get more complicated to format to the way I
> want it such as:
>
> Title Location Location
> Journal of Medicine Rockhurst Periodical
> Music Rockhurst
>
> ...
>
>
> Sincerely,
>
> Julia
> -----Original Message-----
> From: Kim Iwan Hansen [mailto:kimiwan@k...]
> Sent: Monday, March 25, 2002 1:12 PM
> To: ASP Databases
> Subject: [asp_databases] RE: SV: Please help!-- Running Access
> Query--Comb ined criteria!!
>
>
> Julia,
>
> * acts as a wild card - but only on the side of the word it's placed.
>
> Rock* fits every field that BEGINS with "Rock"
> Periodical * fits every field that BEGINS with "Periodical "
>
>
> So in effect you're saying "pick format and location from the table
> masterholdings, where the field location begins with "Rock"
> and also begins
> with "periodical".
>
> One field can't BEGIN with more than one thing.
>
>
> What you want is to find anything that CONTAINS "Rock" or "Periodical"
>
> *Rock* fits every field that CONTAINS "Rock"
> *periodical* fits every field that CONTAINS "periodical"
>
>
> To complete the examples, *Rock fits every field that ENDS on "Rock".
>
> Better? :o)
>
>
> -----Original Message-----
> From: Wang, Julia [mailto:Julia.Wang@R...]
> Sent: 25. marts 2002 19:32
> To: ASP Databases
> Subject: [asp_databases] RE: SV: Please help!-- Running Access
> Query--Comb ined criteria!!
>
>
> Kim, thanks for the response.
>
> We subscribe to a title for instance, "Science" journal. But
> we also pay for
> an electronic database "Peridical Abstracts.." which covers
> this "Science".
> If I can pull out all the titles that have overlaps, we can
> decide to cancel
> the print subscriptions and use the e-databases alone. That
> will save us
> money. But the problem is when I use the combined criteria,
> it gives me "0"
> record!
>
> This is what I did:
>
> SELECT MasterHoldings.Title, MasterHoldings.Format,
> MasterHoldings.Location
> FROM MasterHoldings
> WHERE (((MasterHoldings.Location) Like "Rock*" And
> (MasterHoldings.Location)
> Like "Periodical *"));
>
> Dose this help?
>
> Thanks!
>
> Julia
> -----Original Message-----
> From: Kim Iwan Hansen [mailto:kimiwan@k...]
> Sent: Monday, March 25, 2002 9:11 AM
> To: ASP Databases
> Subject: [asp_databases] SV: Please help!-- Running Access
> Query--Combined criteria!!
>
>
> hey julia,
>
> could it be that you're looking for a string that starts with
> BOTH "Rock"
> and "Proquest", or have i misunderstood you?
>
> try and go "WHERE fldTitle LIKE '%Rockhurst University%' AND
> fldTitle LIKE
> '%Proquest%'" (you may have to replace % with *, of that i'm
> not sure)
>
> hope that helps,
>
> Kim
>
>
>
>
> -----Oprindelig meddelelse-----
> Fra: Wang, Julia [mailto:Julia.Wang@R...]
> Sendt: 25. marts 2002 15:53
> Til: ASP Databases
> Emne: [asp_databases] Please help!-- Running Access Query--Combined
> criteria!!
>
>
>
> Any suggestions are appreciated!!
>
> ** We have a master table named "Maetro" which holds around
> 1,6000 records
> of journal titles of both print and electronic. The table
> consists of Title
> column, Format (e.g. "Print" or "Electronic")column, and
> Location (e.g.
> Library name (here "Rockhurst Unversity", and Electronic
> Database names like
> "First Search", "Gale", "Proquest", etc.") Since there are
> obvious overlaps
> in certain titles for both print and electronic, I need to
> run a combined
> query to extract titles that shows up BOTH in line with "Rockhurst
> University" and with one of the e-databases such as "Gale",
> or "Proquest",
> etc. so that we can make decisions to unsubscribe the
> duplicate print titles
> due to increasing prices.
>
> I tried using, under criteria, Like "Rock*" and Like "Gale*"
> or another set
> Like "Rock*" and Like "Proquest *", etc. for Print to match
> each type of
> electronics, but it returns me "0"!!! If I run single query,
> there is just
> no problem. And I know there are definitely duplicates!
>
> Could any of you take some time and help me as to how to run
> a combined
> Query?
> --Thank You! Thank You! Thank You!
>
> Please ask questions if this is not clearly stated!--Appreciated!
>
>
>
>
>
>
>
>
>
>
|
|
|
View Cart
