Using ASPX page with Access db.

When I run a query in Access it returns many records. When I run it via
ADO.NET it returns 0.

It uses a LIKE statement in the WHERE clause. Here's the statement:
SELECT [Employees].[LastName] & ', ' & [Employees].[FirstName] AS AreaMgr,
Stores.StoreName AS StoreName, Stores.StoreId AS StoreId,
Stores.NumberQCRequired AS NumberQCRequired, Plan.PlanDate AS PlanDate,
Employees.RegionalDirectorId, Stores.StoreTypeId FROM (Employees INNER JOIN
Stores ON Employees.EmployeeId = Stores.AreaManager) LEFT JOIN Plan ON
Stores.StoreId = Plan.StoreId WHERE ((Plan.PlanDate >= #9/1/2004# AND
Plan.PlanDate < #10/1/2004#) Or (Plan.PlanDate Is Null)) AND
(Stores.StoreName LIKE 'Home*') ORDER BY Stores.StoreName, Plan.PlanDate;

Any ideas?

Thanks!

Thanks.

What is the symbol for only 1 character?

"Jay Pondy" <(E-Mail Removed)> wrote in message
news:AF53B556-5309-426E-99C0-(E-Mail Removed)...
> Change the '*' to '%'
>
> "VB Programmer" wrote:
>
> > Using ASPX page with Access db.
> >
> > When I run a query in Access it returns many records. When I run it via
> > ADO.NET it returns 0.
> >
> > It uses a LIKE statement in the WHERE clause. Here's the statement:
> > SELECT [Employees].[LastName] & ', ' & [Employees].[FirstName] AS
AreaMgr,
> > Stores.StoreName AS StoreName, Stores.StoreId AS StoreId,
> > Stores.NumberQCRequired AS NumberQCRequired, Plan.PlanDate AS PlanDate,
> > Employees.RegionalDirectorId, Stores.StoreTypeId FROM (Employees INNER
JOIN
> > Stores ON Employees.EmployeeId = Stores.AreaManager) LEFT JOIN Plan ON
> > Stores.StoreId = Plan.StoreId WHERE ((Plan.PlanDate >= #9/1/2004# AND
> > Plan.PlanDate < #10/1/2004#) Or (Plan.PlanDate Is Null)) AND
> > (Stores.StoreName LIKE 'Home*') ORDER BY Stores.StoreName,
Plan.PlanDate;
> >
> > Any ideas?
> >
> > Thanks!
> >
> >
> >

I found it: _

"VB Programmer" <Dont*NoSpam-Please*@jEmail.com> wrote in message
news:%(E-Mail Removed)...
> Thanks.
>
> What is the symbol for only 1 character?
>
> "Jay Pondy" <(E-Mail Removed)> wrote in message
> news:AF53B556-5309-426E-99C0-(E-Mail Removed)...
> > Change the '*' to '%'
> >
> > "VB Programmer" wrote:
> >
> > > Using ASPX page with Access db.
> > >
> > > When I run a query in Access it returns many records. When I run it
via
> > > ADO.NET it returns 0.
> > >
> > > It uses a LIKE statement in the WHERE clause. Here's the statement:
> > > SELECT [Employees].[LastName] & ', ' & [Employees].[FirstName] AS
> AreaMgr,
> > > Stores.StoreName AS StoreName, Stores.StoreId AS StoreId,
> > > Stores.NumberQCRequired AS NumberQCRequired, Plan.PlanDate AS
PlanDate,
> > > Employees.RegionalDirectorId, Stores.StoreTypeId FROM (Employees INNER
> JOIN
> > > Stores ON Employees.EmployeeId = Stores.AreaManager) LEFT JOIN Plan ON
> > > Stores.StoreId = Plan.StoreId WHERE ((Plan.PlanDate >= #9/1/2004# AND
> > > Plan.PlanDate < #10/1/2004#) Or (Plan.PlanDate Is Null)) AND
> > > (Stores.StoreName LIKE 'Home*') ORDER BY Stores.StoreName,
> Plan.PlanDate;
> > >
> > > Any ideas?
> > >
> > > Thanks!
> > >
> > >
> > >
>
>