Database

Re: sql statement in microsoft access to include IIF statement

6-Jun-09 10:53

As I understand you then you want to display Status to OFF for some records which contain one certain data in field Date ?

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

modified on Saturday, June 6, 2009 5:12 PM

johnnysmith16-Jun-09 18:01

johnnysmith1

6-Jun-09 18:01

yes you are correct

Re: sql statement in microsoft access to include IIF statement

Blue_Boy6-Jun-09 23:42

Re: sql statement in microsoft access to include IIF statement [modified]

6-Jun-09 23:42

here it is

select iif(value='2009.01.02','OFF',value)  from table1

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

johnnysmith17-Jun-09 0:54

johnnysmith1

7-Jun-09 0:54

unfortunately this did not solve problem
I have partNumber Date and Status
I have tried Select partNumber,Date IIF(partNumber= 1011 and Date = #01/01/2006#,"OFF,ON) From table1
but still gettng errors-your sql statement is missing partNumber
thank you

modified on Sunday, June 7, 2009 7:34 AM

Re: sql statement in microsoft access to include IIF statement

Blue_Boy8-Jun-09 0:09

Re: sql statement in microsoft access to include IIF statement

8-Jun-09 0:09

johnnysmith1 wrote:
Date IIF(partNumber= 1011 and Date = #01/01/2006#,"OFF,ON)

Should be

Date <big>,</big> IIF(partNumber= 1011 and Date = #01/01/2006#,'OFF','ON')

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

johnnysmith18-Jun-09 15:33

johnnysmith1

8-Jun-09 15:33

thank you it works

Re: sql statement in microsoft access to include IIF statement

Blue_Boy8-Jun-09 21:09

HOW TO EXPORT CRYSTAL REPORT WITH IMAGE

8-Jun-09 21:09

You are welcome.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Identity Column....

Isaac Gordon6-Jun-09 0:45

Isaac Gordon

6-Jun-09 0:45

Hi Experts
How to alter Column To On Identity on Column
i am try this but not working
ALTER TABLE TEST ALTER COLUMN iD IDENTITY (200, 2)

Re: Identity Column....

Aman Bhullar6-Jun-09 1:44

Aman Bhullar

6-Jun-09 1:44

Sharma Dinesh Kumar wrote:
How to alter Column To On Identity on Column

ALTER TABLE Foo
ALTER COLUMN FooKey
ADD CONSTRAINT IDENTITY(100,1)

Regards
Aman Bhullar
www.arlivesupport.com[^]

Re: Identity Column....

Isaac Gordon11-Jun-09 23:42

Isaac Gordon

11-Jun-09 23:42

This is not Working Give Me Error on CONSTRAINT

Re: Identity Column....

nhughes21117-Jun-09 14:32

nhughes2111

7-Jun-09 14:32

Does anyone have any ideas?

kruti.support5-Jun-09 19:42

kruti.support

5-Jun-09 19:42

Hi friends

I m getting replicated images when I export crystal report having images in Word,PDF,Rtf etc.

Kindly suggest solution

Re: HOW TO EXPORT CRYSTAL REPORT WITH IMAGE

Mycroft Holmes6-Jun-09 4:23

Mycroft Holmes

6-Jun-09 4:23

And the relevance to a database is?

Never underestimate the power of human stupidity
RAH

Help with SQL in MS Access

xx77abs5-Jun-09 1:28

5-Jun-09 1:28

Hello ! I'm doing little project and I need database for it, but not whole server. So I choose Access ... But that's pain in the a** Frown | :(

I have a relatively simply query in which I need to do LEFT JOIN:

SELECT a.*, b.*
FROM a LEFT JOIN b ON (a.pid = b.pretplatnik_id) AND (a.iid = b.izdanje_id);

a and b are booth some other queries. I needed to do this because I can't do query inside a query in access Frown | :(

And there's problem. It all works, except it shows only data from query a and nothing from query b. Everything from b is NULL. Interesting thing is that if I change part "LEFT JOIN" to "INNER JOIN" it returns booth results from query a and b. So does anyone have an idea why LEFT JOIN isn't working ?

Thanks for your time and help Smile | :)

Blue_Boy5-Jun-09 1:38

5-Jun-09 1:38

try to use

LEFT OUTER JOIN

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

xx77abs5-Jun-09 2:40

5-Jun-09 2:40

Thanks for help Smile | :)

But it's not working Frown | :(

Same result as just using "LEFT JOIN"

Blue_Boy5-Jun-09 3:51

5-Jun-09 3:51

Well,if you don't mind then post here some tables data, and result which you want to get and we will try to give you hand on query. Smile | :)

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

xx77abs5-Jun-09 9:02

5-Jun-09 9:02

Thanks, but I've solved it Big Grin | :-D

In b query I've had GROUP BY statement, and it was something like SELECT blabla FROM bla GROUP BY pid, iid;
Now I've changed it to SELECT blabla FROM bla GROUP BY iid, pid; and everything works ... Although I don't think there's any difference, but ok ... if there is, please explain it to me Big Grin | :-D

Blue_Boy5-Jun-09 9:14

5-Jun-09 9:14

It's possible to use DISTINCT instead of GROUP BY but when you had solution then let it as it is.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

xx77abs6-Jun-09 2:46

6-Jun-09 2:46

Yes, but can I use distinct with two fields ? And I also did use SUM with GROUP, I think that I can't use sum with distinct ...

Blue_Boy6-Jun-09 3:15

6-Jun-09 3:15

When you have case to use agregate functions then better use GROUP BY but still you can use DISTINC and with subquery you can get SUM or any else agregate function.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

xx77abs7-Jun-09 3:42