Thanks for the ideas, Dan. I'm making progress!
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "Sue Cram" <[EMAIL PROTECTED]>
Cc:
Sent: Sunday, February 13, 2005 12:34 AM
Subject: Re: Total Counts, Multi-Report Questions
In the la
I have a request for a list of database entries "Select x,y,z, etc" that is now
working OK. I have several questions, however. Here they are:
1.. Can I add a "total" line at the bottom of the report (ex: "Total
Selected: 23") for the total number of entries that are listed in the report?
Thanks to the people who helped me with my IF statement question last night.
Now I need to carry it one step further to a compound 'IF' statement. Again,
can't find much information in the manuals --
Several people sent me "IF (Adopted=1, 'Y', 'N') AS Adopted FROM Animal" and it
works great.
This is a pretty basic question, but I'm learning SQL from a book and it's very
very frustrating!
I'm writing a report listing animals from our shelter and whether they have
been adopted. I am selecting the animal name field and a field called
'adopted' from a table called 'animal'. The va
Neither my developer nor I can figure out this one! The package I'm using is
"Animal Shelter Manager" and is written in SQL. Every other installation of
the product can use the SELECT SUBSTRING command except mine! I use the
following code:
SELECT SUBSTRING (AnimalName, 1, 1)
FROM Animal
an
