Hi<BR><BR>How can I search a keyword for two memo fields and one text field. In other words, what is the syntax to do that command?<BR><BR>Thanks
text = Request("keyword")<BR>SQL = "Select * From Table Where textfield Like '%" & text & "%' Or memo1 Like '%" & text & "%' Or memo2 Like '%" & text & "%';"
..can we have 2 "memo" fields in Access database?
You can have as many as you want. I have tables with a dozen of 'em.