Make sure there is no Default Values Specified in the Store Parameter Area.

Thank you Micky

You have defined very simply using PIVOT command. I understood first time how to use PIVOT very well from your code.

I can see that PIVOT reduce...

Woul this help ?

USE AdventureWorks;

GO

SET ANSI_WARNINGS OFF;

SET NOCOUNT ON;

GO

WITH agg AS

(

SELECT

[object_id],

...

Please refer :

http://msdn.microsoft.com/en-us/library/ms188754(v=sql.90).aspx

•On 2008: using the new Server Auditing feature

•On 2005: using Dynamic Management Views (DMV)

Please follow below article helps you how to provide more clarity for your post

http://www.sqlservercentral.com/articles/Best+Practices/61537/

I am not a DBA. Here are my two cents as per developer's point of view.

1. Create 4 databases for 4 different application and create tables?

Pros - it is easy...

Sorry for the previous post.Added count was not right. Here is a solution using CASE Statement.

SELECT Region_Code, Original = Max(CASE WHEN description = 'Original' THEN WholeACNet END),

RiverLakes_WWFL = max(CASE...

SELECT Region_Code, Original = COUNT(CASE WHEN description = 'Original' THEN 1 ELSE 0 END),

RiverLakes_WWFL = COUNT(CASE WHEN description = 'RiverLakes_WWFL' then 1 ELSE 0 END),

RiverLakesSev123_WWFL = count(CASE WHEN description...

Thanks. Could you please create a sample in excel including your columns values and position and post here for better understanding.

I am new here. I need your advise.

In my previous reply I designed queryin my SQL Server and copy paste here. It is looking flat text in my reply. I...

Would this work for you ?

SELECT Original = CASE WHEN description = 'Original' THEN Region_Code ELSE '' END,

RiverLakes_WWFL = CASE WHEN description = 'RiverLakes_WWFL' then Region_Code ELSE '' END,

RiverLakesSev123_WWFL =...

Sir,

I would be glad to help you out but for accurate result please read below article and repost according to Post Etiquette

that way more people would be interested to provide...

Yes thats the idea making your accessdb as a frontend and you will be linking table from sql server into MS Access.

All you need to do coding using DAO...

You don't need to reference your access form into SQL Server to create new records from

your form's textboxes. Please Link your SS Table in MS Access and Write Code...