Multi Part Query = No records

[RebekahK20_pontiac via AccessMonster.com]

I have a database created by getting external data (outlook folder) and
creating a table I've got this linked to the actuall outlook folder so it is
updating.

However in the table it generates I have a ton of excess data. So I started
putting together a query to pull out just what I want.

This is just a snippet of the code I am using. I am pulling out several diff
chunks of info in 6 total columns.

First Column
Right([Contents],InStr([Contents],'Route'))

Second Column
Just shows value from field: Date Received

Third Column
Right([Body],InStr([Body],"Route")) And Right([Body],InStr([Body],'owned_by'))


Forth Column
Just returns value from field: Route Owner

Fifth Column
Right([Normalized Subject],InStr("Normailzed Subject]","To find out more
about the Route, use the following URL:"))

Sixth Column
Just returns value from field: Accept Date



This works (no errors when I run the query)- in the fact that it creates the
column, but returns no results?.
And I currently have over 1500 entries.

Thanks again!

 

[Guest]

Post your actual query SQL statement.

 

[RebekahK20_pontiac via AccessMonster.com]

OK - you asked for it.
But I've also just been informed that there will be 2 instances of some info
and that needs to appear in the same record... Getting a little messy if you
ask me..

SELECT z_try2VendorTechTasks.Subject AS TaskID, z_try2VendorTechTasks.
Received AS TaskAssignDate, z_try2VendorTechTasks.Body AS TaskRoute,
z_try2VendorTechTasks.Body AS TaskOwner, z_try2VendorTechTasks.[Normalized
Subject] AS RouteURL, z_try2VendorTechTasks.[Last Modification Time] AS
TaskAcceptDate, z_try2VendorTechTasks.[Normalized Subject] AS TaskAcceptBy
FROM z_try2VendorTechTasks
WHERE (((z_try2VendorTechTasks.Subject)=Right([Body],Len([Body])-InStr([Body],
"Buisness Object: Inbox Task")))) OR (((z_try2VendorTechTasks.Body)=Right(
[Body],InStr([Body],"Route")))) OR (((z_try2VendorTechTasks.Body)=Right([Body]
,InStr([Body],'owned_by')))) OR (((z_try2VendorTechTasks.[Normalized Subject])
=Right([Normalized Subject],InStr("Normailzed Subject]","To find out more
about the Route, use the following URL:")))) OR (((z_try2VendorTechTasks.
[Normalized Subject])=Right([Normalized Subject],InStr("Normalized Subject]",
"accepted by "))));

Post your actual query SQL statement.

I have a database created by getting external data (outlook folder) and
creating a table I've got this linked to the actuall outlook folder so it is

[quoted text clipped - 30 lines]

Thanks again!

 

[Guest]

One error I see twice --
InStr("Normailzed Subject]", - wrong use of quotes - InStr([Normailzed
Subject],

Try removing all criteria to see if you get any records. Then add one
criteria at a time to see where your error is.

 

[RebekahK20_pontiac via AccessMonster.com]

I get my 1500+ records when all criteria is removed, as soon as I add 1 thing,
nada.... i see empty columns?

One error I see twice --
InStr("Normailzed Subject]", - wrong use of quotes - InStr([Normailzed
Subject],

Try removing all criteria to see if you get any records. Then add one
criteria at a time to see where your error is.

 

[Guest]

Maybe the error is that [z_try2VendorTechTasks].[Subject] is not equal but
that you should use Like.
Try this ---
WHERE [z_try2VendorTechTasks].[Subject] Like “*†&
Right([Body],Len([Body])-InStr([Body], "Buisness Object: Inbox Task")) &â€*â€

--
KARL DEWEY
Build a little - Test a little

I get my 1500+ records when all criteria is removed, as soon as I add 1 thing,
nada.... i see empty columns?

One error I see twice --
InStr("Normailzed Subject]", - wrong use of quotes - InStr([Normailzed
Subject],

Try removing all criteria to see if you get any records. Then add one
criteria at a time to see where your error is.