simple code problem

Access_help_rob

Registered User.
Local time
Today, 06:08
Joined
Jul 3, 2003
Messages
66
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
 
Run an update query. Look in the Access help or the query section of the forum for more info.
 
Or, at real time,

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


i.e.


NewField: IIf(IsNull([FaxNumber]), "123456789", [FaxNumber])
 
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. :eek:
 
hey guys thanx very much i went for miles option, stars guys absolute stars
rob
 

Users who are viewing this thread

Back
Top Bottom