If statement in query

[GetRektByNoob]

hello guys.


im trying you use the if statement to show a row of kind if an another row is euqal to something. in c# to make it more clear

if(PhoneType.euqal("32GB"))
{
//Show phone 32GB price by phone id
} else {
//Show phone 64GB price by phone id
}

the sales query https://imgur.com/a/gl9qMwH (the prices here only show the 32GB so if the phone is 64GB its going to show the 32GB version of the phone)
64GB phones http://prntscr.com/nwj9dd
32GB phones http://prntscr.com/nwj9j3

thanks for the help. (im not good in accsess to please keep it simple )

[Micron]

Not much to go on here; pictures of query results don't help at all (at least not me).
I think what you need is an expression in a query field that uses IIF function.

[June7]

If you have two tables for PhoneTypes, should be 1.

Quite possibly in IIf() expression will serve.

[moke123]

In the 3rd photo it appears you have tables - Phone Types- 64GB and Phone Types- 32GB.
Are you storing data AS tables? Are these tables the same except for 64 and 32?

[GetRektByNoob]

@Micron I know, this is what I'm trying to do... but it's not working for me because I'm not good with access.

@June7 its not 1 table because the 32 and 64 doesn't have the same stats each phone has a different stats. ()

@moke123 the only thing that is similar is the ID and the name apart from that everything should be different.

[June7]

Both tables have the same PhoneID. Build a query that joins those to the sales data and use an IIf() expression to pick the appropriate price.

What fields are different?

If you want to provide db for analysis, follow instructions at bottom of my post.

[Dave14867]

I am not good at VBA but isn't "equal" spelled wrong in the If statement? if(PhoneType.euqal("32GB"))

[June7]

Doesn't matter since it was a C# example not VBA.

In query, probably want something like:

IIf(PhoneType = "32GB", this field name, other field name)

[GetRektByNoob]

Doesn't matter since it was a C# example not VBA.

In query, probably want something like:

IIf(PhoneType = "32GB", this field name, other field name)

yes, this i what is need
i did

Price: IIf([Sales]![Phone Type]="32GB",[Phone Types 32GB]![Price],[Phone Types 64GB]![Price])

in the Field row but its not working and its asking for params when activating the query.

[GetRektByNoob]

Link to my accsess
https://drive.google.com/open?id=1Q6...XJKkBasUan9tJ2

[June7]

Query does not include the 64GB table.

The two phone tables have the same fields.

Many will not download file from other sites. Best to attach Zip file to post.

[GetRektByNoob]

Query does not include the 64GB table.

The two phone tables have the same fields.

Many will not download file from other sites. Best to attach Zip file to post.

they have the same fields but but same not same values.

ok.

how do i make it so?

[GetRektByNoob]

oh just had to include the 64 table xD tnx for the help!

[June7]

Of course they have different data. But since fields are the same, this can be 1 table. Options:

1. Two price columns and use the IIf() to pull correct one.

2. Each phone/price pair is a separate record. Have a column to identify as 32GB or 64GB. Will have to change PhoneID keys in Sales and Company Phone. No need for PhoneType field in Sales.