05ddg06

M VisData:E: WB4\Biblio.mdb

File Jet LJtilily Preferences Window Help

unin

Recordset (* Dynaset Type:    C Snapshot

r Table

Form

Type:

Dala Conlrol No Dala Conlrol DBGrid Conlrol

BeginTrans

| User: admin

SQL Statement

Refresh

Sorl

Filier

Close

	PubID	Name	Zip	Zip Times 3
	70	Business	60430	181290
	71	Chapman	10001-2291	30003
	72	Futurę	11791	35373
	73	Glencoe	91345	274035
	74	Gupta	94025	282075
	75	Hayden	46032	138096
	76	Irwin	13027	39081
	77	Logical	14610	43830
	78	MIDI	30033	90099
	79	MIS	97208-5277	291624
	80	Mitchell	95076	285228
*

[7 AllowAddNew [7 AllowDelele [7 AllowUpdate

| N | 4 | Righl Click for Data Conlrol Properlies

^ SQL Statement

Execute		Clear

SELECT PubID, Name, Zip, 3“Val(Zip] AS Zip_Times_3 FROM Publishers

|Ready