True or False?

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

Guest

Despite MS Access limitations, users should still be able to create queries
to meet all their query needs. Thus there is no need for users to feel that
they can't ascertain certain information. True or False?

I ask this question, because i feel that i'm very limited due to
restrictions in Access implementation of subqueries and operators. What i
want to do seems basic to me, but out of reach. Is this typical?
 
Your question begins with a "straw man" that you then try to rationalize.
What limitations are the focus of your question? Queries can be simple or
complex. Creating queries can be as "straightforward" as writing an SQL
statement or using the QBE view in ACCESS -- or they can be more
user-friendly by providing controls on a form that allow the user to set the
filtering conditions and then the form's programming creates the query.

And anything in-between and outside this.
 
Not being able to use DISTINCT with aggregation functions.
Not being able to use UNION in subqueries.
Not being able to do Correlated queries.

I've been able to avoid these by rewriting my queries. But now that they've
been rewritten, they cannot be expanded very much. Thus i have to RUN many
queries one after the other, changing a few IDs, to get the information i
need. This is time consuming.

Not to mention all the work getting around Access particularities.

I can post my queries, but to me, they are not very simple.
 
This is a fairly generic list, so I won't try to respond to them here. If
you have a specific example, post it and we'll see what we might suggest for
a different approach.
 
Back
Top