Very Computer

Subject: Re: New Question
Date: Sunday, June 22, 2003 6:18 PM

Hello Again Robert,

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

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.

Thank you for your patience,
Emmy

Quote:> Hello Again Robert,

Quote:> 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

Quote:> 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 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

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.

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.

Quote:> > 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

Quote:> 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.

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.

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

I was beginning to feel as if the blonde joke syndrome applied to me.!!!
(smile)

If you have other pointers I am more than willing to give then a try.

Again, thank you so much Robert,
Emmy

Quote:> > 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.

> So you added a field to your table, right ?
> 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 ?

> > 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.

> Probably - but not a big deal.
> 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

Quote:> 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

Emmy

Quote:> > 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

Emmy

Communication via newsgroup benefits everyone - the person with the
question, those trying to find the answers, lurkers who only read and
those who will come by in a few months or even years and read what
went on.  Keeping the conversations in threads and on the newsgroups
benefits all.

Unless your conversation truly needs to go private, please continue
your questions here.

Liz

PS: Some, as you've noticed, block direct email via spam traps; others
prefer not to receive unsolicited private email and either won't
respond or will respond by directing you to post to the groups (or
some in a less polite manner).  It's generally considered polite to
ask someone (on the groups) if they'd be willing to receive a private
email prior to sending said private email.  (Just an FYI on newsgroup
etiquette.)

If you just want free consulting then you have to find a chump.

If you want paid consulting outside the NG there is lots of that available for
hire.

Denn Santoro
President
Resource Development Associates
http://www.RDAWorldWide.Com
Offices in the United States and Germany
Providing solutions to health care, business, governments and non-profits since
1982

Emmy

Emmy

Quote:> The whole point of the NG is to SHARE. That way many people get the
benefit of
> the questions AND answers.

> If you just want free consulting then you have to find a chump.

> If you want paid consulting outside the NG there is lots of that available
for
> hire.

> Denn Santoro
> President
> Resource Development Associates
> http://www.RDAWorldWide.Com
> Offices in the United States and Germany
> Providing solutions to health care, business, governments and non-profits
since
> 1982

Quote:> > I would prefer if we communicated back and forth w/o the newsgroup.  I
tried
> > to respond to your e-mail but you have a block on it and the e-mail
bounced
> > back.

I was trying to take a very step by step approach to help someone learn.
and thought it would be more productive to email directly.
So I deserve the heat for that.

If the email bounced, look at my email address that bounced, and see if it
and see if you can spot the word that doesnt belong there. I think the word
antispam might need to be removed.

Robert Wiltshire