how to add data to specific records

[basilyos]

hello guys
i have a table
ID - File Type - Source - Delivery - Return
1 - X - LB - ROY - LB via Roy
2 - Y - USA - Smith - USA via Smith
3 - Z - LB - -

my question is how can i make the last column (Return) to fill like the data above

what i mean if (Delivery) not null So the return will be filled like the above if the (Delivery) is null the return will be null too

i don't know if i explained my problem


the user will fill only the columns (File Type - Source - Delivery)
the column (Return) will be filled automatically if (Delivery) not null

 

[basilyos]

thanks guys i found the solution from this post

http://www.access-programmers.co.uk/forums/showthread.php?t=263826

iif(is null([confirmedfield],"N/A",[confirmedfield])

 

[CJ_London]

Looks like return is a calculated value so should not be stored in your table.

Your query would look something like

SELECT *, iif(IsNull(Source),"",[File Type] & " via ") & Source AS Return FROM myTable

 

[plog]

Generally you don't store calculated date, instead you calculate it. This seems to be calculated data.

What you would do is create a query to generate the 'Return' value. It would look like this:

Return: [Source] & " via " & [Delivery]

Actually, you would need a conditional statement on there to make it show blank if [Delivery] is null. Use these functions to add that part:

IIf - http://www.techonthenet.com/access/functions/advanced/iif.php
IsNull - http://www.techonthenet.com/access/functions/advanced/isnull.php

 

[basilyos]

many thanks guys I appreciate your help