how to format records ?

[Beginner0]

I use form like a continuous recordset.

For example i have a table TABLE1:
field id, value = 1
field status, value = 0

values of status field means: value 1 = job complete, value = 0 job not complete.

for my form i use record source = select * from TABLE1

after query execution in the form i dont want to see exact data from field STATUS (data like '1' or '0'), i want to do a 'IF' statement. For example: If form.recordset.fields('status')=1 then text20.value = 'job complete' else text20.value='job not complete'

 

[unclejoe]

Hi,

Welcome to Access World.

Use a IIF(expression, true, false) in your SQL like...

Select Status, col2, col3.......IIF(Status =1, "Job complete", "Job not complete") as Expr1 FROM Table1

Bound text20 to the "Expr1".

I use form like a continuous recordset.
For example i have a table TABLE1:
field id, value = 1
field status, value = 0
values of status field means: value 1 = job complete, value = 0 job not complete.
for my form i use record source = select * from TABLE1
after query execution in the form i dont want to see exact data from field STATUS (data like '1' or '0'), i want to do a 'IF' statement. For example: If form.recordset.fields('status')=1 then text20.value = 'job complete' else text20.value='job not complete'