I want to ask that here but I think it will be easy for some people.
Okay I have a query that records records of two related tables (multiple from one)
In this query I have around 3 to 4 counted areas which are used on fields from 2 tables Are based on.
Now let me segment
"You tried to execute a query that is not part of the total work"
So I only query the query Decided to run (i.e. any group, amount etc.,): And then I created another query which adds to my previous query. (I.e. the name of the group and the fields for the calculated fields ... no calculation ...) It is fine (I use to do this) but I do not like to get a total of two questions in a nutshell Is this a way to do it in any other way in the design view and only create a query? I highly appreciate it.
Thankyou:
JM
looks like query Thinking fields should be a part of the group or something. You may have to ask a sub-question
Can you post SQL (before and after) This will help you understand what this problem is.
Comments
Post a Comment