Life is one big Query

[Sproul]

Is it possible to write a query within Access, Have frontpage activate the
query and return all of the results, or would that involve using VB code too.



Al....

 

[Kevin Spencer]

You can query a Query.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Everybody picks their nose,
But some people are better at hiding it.

 

[Kevin Spencer]

To be more specific, treat the Query like a table.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Everybody picks their nose,
But some people are better at hiding it.

 

[Sproul]

I'll be a bit more specific, if i create query in access which is the result
of three querys sent to a number of different tables within the same
database, can i get front page to initilise that query and return all of the
results in a table.

What i've got at the moment is a table with 24 individual querys on the one
page each with a WHERE clause, chances are i'm gonna be adding more query's
to this page.

I'm assuming that i will have to do some code editing to do this, so before
i attempt it i would like to know if it is possible, and as i only started
playing about with this it would be good if i could get a pointer of roughly
how to do it.


Al....

 

[Kevin Spencer]

An Access Query is similar to a SQL Server View. In other words, you can
treat it like a table, and perform queries on it, as long as it doesn't use
parameters.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Everybody picks their nose,
But some people are better at hiding it.

 

[Sproul]

Ok, i'll give it a go then.

Thanks for your help Kevin



Al....