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.

--
Cheers,
Jon
Microsoft MVP


"Sam B." <(E-Mail Removed)> wrote in message
news:30CED289-4D08-4415-9C9C-(E-Mail Removed)...
>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

Great! Worked like a charm.

Thank you

"Jon Spivey" wrote:

> 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.
>
> --
> Cheers,
> Jon
> Microsoft MVP
>
>
> "Sam B." <(E-Mail Removed)> wrote in message
> news:30CED289-4D08-4415-9C9C-(E-Mail Removed)...
> >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
>
>
>