Can't Get Simple Query to work on Site

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

Guest

I have created a simple query using Access. This is the query:

SELECT Labels.Label, Labels.Name, Labels.Picture
FROM Labels
WHERE ((Labels.Name) Like "N*");

When I go through the Database Result Wizard I enter this query in manually
through the edit button. When I publish my site the page says that no
results can be found. When I run the query in access I see the results as
intended. Is there something I'm doing wrong?

Sam
 
Hi,
* only works for Access on the desktop - on the web you need %
SELECT Labels.Label, Labels.Name, Labels.Picture
FROM Labels
WHERE Labels.Name Like 'N%'

It's not always obvious but Access as part of office is a different product
to access you use on the web.
 
Great! Worked like a charm.

Thank you

Jon Spivey said:
Hi,
* only works for Access on the desktop - on the web you need %
SELECT Labels.Label, Labels.Name, Labels.Picture
FROM Labels
WHERE Labels.Name Like 'N%'

It's not always obvious but Access as part of office is a different product
to access you use on the web.
Click to expand...
 
Back
Top