By using this site, you agree to our Privacy Policy and our Terms of Use. Close

Forums - General - Can anyone who has experience in Microsoft Access help me?

NiKKoM on 23 January 2014
GdaTyler said:
NiKKoM said:
GdaTyler said:

Actually, I've found out what's wrong. If I multiply the field by anything other than 1 it doesn't show. Any solutions?

I'm actually at home where i don't have a PC.. (Mac only) so I'm winging this from memory..

did you place the iif statement in the Criteria row on the query design view? Delete that. Instead, you need to make the Iif statement its own field in query.

It then tells me enter parameter value. >:(

click cancel and check your rows and columns somewhere there should be a [identifier] or something like that popped up somewhere



 

Face the future.. Gamecenter ID: nikkom_nl (oh no he didn't!!) 

Around the Network
GdaTyler on 23 January 2014
NiKKoM said:
GdaTyler said:
NiKKoM said:
GdaTyler said:

Actually, I've found out what's wrong. If I multiply the field by anything other than 1 it doesn't show. Any solutions?

I'm actually at home where i don't have a PC.. (Mac only) so I'm winging this from memory..

did you place the iif statement in the Criteria row on the query design view? Delete that. Instead, you need to make the Iif statement its own field in query.

It then tells me enter parameter value. >:(

click cancel and check your rows and columns somewhere there should be a [identifier] or something like that popped up somewhere

nope don't see it. :(



3DS Friend Code: 0533 - 6146 - 0418
PSN ID: atylerman5

NiKKoM on 23 January 2014
GdaTyler said:
NiKKoM said:
GdaTyler said:
NiKKoM said:
GdaTyler said:

Actually, I've found out what's wrong. If I multiply the field by anything other than 1 it doesn't show. Any solutions?

I'm actually at home where i don't have a PC.. (Mac only) so I'm winging this from memory..

did you place the iif statement in the Criteria row on the query design view? Delete that. Instead, you need to make the Iif statement its own field in query.

It then tells me enter parameter value. >:(

click cancel and check your rows and columns somewhere there should be a [identifier] or something like that popped up somewhere

nope don't see it. :(

Strange.. what does the dialog popup say? Enter parameter value [SomeIdentifier]?



 

Face the future.. Gamecenter ID: nikkom_nl (oh no he didn't!!) 

GdaTyler on 23 January 2014
NiKKoM said:
GdaTyler said:
NiKKoM said:
GdaTyler said:

Actually, I've found out what's wrong. If I multiply the field by anything other than 1 it doesn't show. Any solutions?

I'm actually at home where i don't have a PC.. (Mac only) so I'm winging this from memory..

did you place the iif statement in the Criteria row on the query design view? Delete that. Instead, you need to make the Iif statement its own field in query.

It then tells me enter parameter value. >:(

click cancel and check your rows and columns somewhere there should be a [identifier] or something like that popped up somewhere

Everything is alright except for the fact that I can't multiply anything by a number other than 1. For example if I put 2 or a decimal, 0.9 everything comes up blank. I even formatted total payment as a number in design view. Wtf is this crap, lol.



3DS Friend Code: 0533 - 6146 - 0418
PSN ID: atylerman5

GdaTyler on 23 January 2014
NiKKoM said:
GdaTyler said:
NiKKoM said:
GdaTyler said:
NiKKoM said:
GdaTyler said:

Actually, I've found out what's wrong. If I multiply the field by anything other than 1 it doesn't show. Any solutions?

I'm actually at home where i don't have a PC.. (Mac only) so I'm winging this from memory..

did you place the iif statement in the Criteria row on the query design view? Delete that. Instead, you need to make the Iif statement its own field in query.

It then tells me enter parameter value. >:(

click cancel and check your rows and columns somewhere there should be a [identifier] or something like that popped up somewhere

nope don't see it. :(

Strange.. what does the dialog popup say? Enter parameter value [SomeIdentifier]?

It said the name of the column. :(

Wait, should I make a field called discount and multiply two fields together as a workaround? is it possible?



3DS Friend Code: 0533 - 6146 - 0418
PSN ID: atylerman5

Around the Network
NiKKoM on 23 January 2014
GdaTyler said:
NiKKoM said:

click cancel and check your rows and columns somewhere there should be a [identifier] or something like that popped up somewhere

Everything is alright except for the fact that I can't multiply anything by a number other than 1. For example if I put 2 or a decimal, 0.9 everything comes up blank. I even formatted total payment as a number in design view. Wtf is this crap, lol.

so when it's *1 the correct value (in numbers) is displayed? but not with 0.9 hmmm try something like

iif ([Tour specified]="asian", [discount], [total payment]*1)


and then add "discount" calculated field with [total payment]*.9



 

Face the future.. Gamecenter ID: nikkom_nl (oh no he didn't!!) 

GdaTyler on 23 January 2014
NiKKoM said:
GdaTyler said:
NiKKoM said:

click cancel and check your rows and columns somewhere there should be a [identifier] or something like that popped up somewhere

Everything is alright except for the fact that I can't multiply anything by a number other than 1. For example if I put 2 or a decimal, 0.9 everything comes up blank. I even formatted total payment as a number in design view. Wtf is this crap, lol.

so when it's *1 the correct value (in numbers) is displayed? but not with 0.9 hmmm try something like

iif ([Tour specified]="asian", [discount], [total payment]*1)


and then add "discount" calculated field with [total payment]*.9

FINALLY!!! THANKS SO MUCH!!!!!!! I THANK YOU A LOT!!! Finally it's over.



3DS Friend Code: 0533 - 6146 - 0418
PSN ID: atylerman5