Querying in Access Page

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to use an Access Page to query a list of Subdivisions. But I try
to use a query that I have to input part of the subdivision name and it won't
find a single record. I am using Like "*" & [Enter a character(s) in
Subdivision name: ] & "*" for my query....is there a reason that the
records do not appear? If I run the query alone it works fine, but it
doesn;'t work within a data access page. Any help would be great!
 
Data Access Pages uses ADO recordsets, not DAO recordsets. As such, you must
the % as the wildcard character, not *.
 
Back
Top