Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
artizan
Starting Member
5 Posts |
 Posted - 2008-07-28 : 07:40:35
|
| 1. I am trying to run a report which has a table called DETAILS. Within this table there is an entry "ACTION" I want to count the number of times a name appears "Liz" in the Action field as well as all the entries where the action field is empty (Blank). Can anyone please explain how I would type the formula into the value field.2. Secondly, I have used Quiries within MS Access before. Is a query within MS Query the same? ie > greater than, = equal to etc or is these a completely different set of symbols. If this is the case can you direct me to somewhere they are listed.Grateful for any help you can offer. |
|
|
VGuyz
Posting Yak Master
121 Posts |
Posted - 2008-07-28 : 07:47:00
|
| Post u'r query with some sample data.It would be helpful to understand. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-28 : 07:53:21
|
quote:
Originally posted by artizan
1. I am trying to run a report which has a table called DETAILS. Within this table there is an entry "ACTION" I want to count the number of times a name appears "Liz" in the Action field as well as all the entries where the action field is empty (Blank). Can anyone please explain how I would type the formula into the value field.2. Secondly, I have used Quiries within MS Access before. Is a query within MS Query the same? ie > greater than, = equal to etc or is these a completely different set of symbols. If this is the case can you direct me to somewhere they are listed.Grateful for any help you can offer.
Are you asking about T-sql solution or sql reporting services expression? could you specify? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-28 : 07:54:24
|
| and for 2 post it in MsAccess forum |
|
|
|
|
|
|
2 Basic SQL Questions