 | |
#1
 
| |||
| |||
|
Re: Querying list of music -
06-23-2003
, 09:41 AM
|
Hello Again Robert, Hi, it would have been fine to keep this going on the previous thread. Plus others can respond if I dont read this for a while. After reading some of the replies I am dumbfounded. I don't know what they are talking about. UseYN Artist Title Label No Genre Year I probably would have added the column as the last column in the table. But that is a matter of taste, it really doesnt matter where you put the column. These are the headers for my CD table. I put a + in the UseYN column on each entry I wanted to save to a new table. I re-sorted the table and all the + signs disappeared. I don't think this was what you were trying to explain to me. I feel so frustrated. It made sense to me to make a new column but now I feel so frustrated and dumb that it would not work for me. When you sorted the table, maybe all the + signs moved to the bottom of the table. You could try a new query on the table, and only check the useYN column to see what the different values in that field are. When I call a column useYN, the intention was that you fill it with "Y" and "N". My advice is to not use the "+" plus sign. It doesnt make it any easier, probably causes problems, and in my opinion, does not make as much sense as a Y in the field. If you have a "Y" in the useYN field, that means you want to use it , does that make sense. Lets take this real slow, a step or two at a time. Once you add a field called useYN , it has a data type of Alpha size 1, right ? Do you know how to populate that field with all N ? If you dont, let me try to tell you how to do it. You need to use a changeto query. Start a new query, move to the useYN field in the query image, type in changeto N then press F8, which will run the query. Now view your table. All records should now have a N. Let me know if you had a changed table pop up when you press F8 when you do this. When you get this far, post back, and we can go to the next step. Robert Wiltshire |
#2
| |||
| |||
|
|
Am I supposed to enter a N or Y in the CD table in each entry or in the query or put a N in the ones I do not want and a Y in the ones I do want? I have 58 CDs of Muddy Waters. His name is listed 58 times along with the other information. The table is in column form. |
What name did you give it ?
Did you call it useYN ?
If you called it that, then I would do what you said :
N = ones you do not want to use
Y = ones you do want to use
First step is to turn every record to N.
How did you make out with doing this, did you try the changeto query yet ?
Quote:
|
I may have neglected to mention that my ultimate goal is to be able to combine all the queries alphabetically and have one printout for this information. |
I know more about queries than reports,
so I will concentrate on queries for this thread.
It is worth the time to step through some initial tasks.
You will get better at paradox and then the sky will be your limit.
If you can do one query, then you can do two queries.
And if you can do 2 queries, then you can do 3 or 4 or 8 or a 100 if you
felt like it.
If you take the time to get the hang of interactive queries,
I am sure others would agree that you will have a great foundation to build
on.
Try the following if you like , they will probably help you.
creating a few queries - including the changeto N one
save a query to a file so you can run the query again at a later date
editing a previously saved query.
Cheers
#3
| |||
| |||
|
|
If you have other pointers I am more than willing to give then a try. |
go to the artists field
type in
Several queries to try,
notice how the AS word renames the field in the answer table.
when you are creating a query, pressing F8 will run the query,
so when you see F8 , that means run the query
you can click the gear icon on the toolbar also if you want,
but i find it slightly easier to press F8
#1 calc count unique, Press F8 to run query
#2 calc count unique as uniqArtitsts,F8
#3 calc count all,F8
#4 calc count all as allArtists
Helpful hint :
While you are entering a query, CTRL-DELETE, will delete the entire line in
the query that you are working on. This is useful if you want to make sure
no prior query specs remain to influence your current query.
Now a 2 field query
moveto "artists" field in query image
select this field for query by pressing F6 or getting a checkmark
then, moveto title field
typein "calc N as useYN" in this field
Press F8
You should have 2 fields in answer table.
Artist name and useYN with a N in it.
In summary, we used the "calc" query keyword to
1. summarize - unique record counts
2. summarize - total record count
3. create a new field in answer table already populated with a value.
R
#4
| |||
| |||
|
|
If you have other pointers I am more than willing to give then a try. Start a new query, go to the artists field type in Several queries to try, notice how the AS word renames the field in the answer table. when you are creating a query, pressing F8 will run the query, so when you see F8 , that means run the query you can click the gear icon on the toolbar also if you want, but i find it slightly easier to press F8 #1 calc count unique, Press F8 to run query #2 calc count unique as uniqArtitsts,F8 #3 calc count all,F8 #4 calc count all as allArtists Helpful hint : While you are entering a query, CTRL-DELETE, will delete the entire line in the query that you are working on. This is useful if you want to make sure no prior query specs remain to influence your current query. Now a 2 field query moveto "artists" field in query image select this field for query by pressing F6 or getting a checkmark then, moveto title field typein "calc N as useYN" in this field Press F8 You should have 2 fields in answer table. Artist name and useYN with a N in it. In summary, we used the "calc" query keyword to 1. summarize - unique record counts 2. summarize - total record count 3. create a new field in answer table already populated with a value. R |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.