simple code problem

[Access_help_rob]

hey , k i have a quearie which brings up suppliers names and fax numbers, for any supplier who doesnt hae a fax number i want to enter a "123456789" please help thanks
rob

 

[dcx693]

Run an update query. Look in the Access help or the query section of the forum for more info.

 

[Mile-O]

Or, at real time,

make a calculated field in the query that has an IIf statement:


i.e.


NewField: IIf(IsNull([FaxNumber]), "123456789", [FaxNumber])

 

[dcx693]

Ooops. Good catch Mile. Only run an update query if you want to permanently change the data. I'd suggest not doing that unless you absolutely need to.

 

[Access_help_rob]

hey guys thanx very much i went for miles option, stars guys absolute stars
rob