Will IF THEN statement work

[wheels27]

what i need to do is when the description says computer A
i ned to put this date when the description says Computer b put this date. also i will have multiple descriptions for
each date so will i use an or statement for the descriptions while i use an if then for the date matching

thanks

 

[BattleDroid42]

I would use either a select case or an immediate if:

Dim strCompName as String

Select Case strCompName
Case A
Your Date #1
Case B
Your Date #2
End Select

...in a query you can use IIf()

IIf([CompName] = "A", YourDate#1, YourDate#2)

Try that!