trying to create a function that return the criteria of a query

  • Thread starter Thread starter Sharon
  • Start date Start date
S

Sharon

Hi again,

In order to solve the problem I mentioned in my last
question, I tried to create a function that should return
the string with the criteria of the query and in the
criteria, I called this function.

The function looks like that:

Function GetDateCriteria()
If [Forms]![F_Menu]![DateV] = True then
GetDateCriteria = ">=[Forms]![F_Menu]![FromDate]
And <=[Forms]![F_Menu]![ToDate]"
Else
GetDateCriteria = "" 'I tried Null as well
End If
End Function

But it didn't work.....

Is it possible to do it like that?

Thanks a lot,
Sharon
 
Sharon said:
In order to solve the problem I mentioned in my last
question, I tried to create a function that should return
the string with the criteria of the query and in the
criteria, I called this function.

The function looks like that:

Function GetDateCriteria()
If [Forms]![F_Menu]![DateV] = True then
GetDateCriteria = ">=[Forms]![F_Menu]![FromDate]
And <=[Forms]![F_Menu]![ToDate]"
Else
GetDateCriteria = "" 'I tried Null as well
End If
End Function
Click to expand...


Before I get to your question, I want to mention that it is
easier for all involved if you would keep the messages about
a single question in a single thread. Creating a new thread
with your reply (to yourself) just leaves everyone (most
likely yourself included) wondering what went on before.

Now, to talk about your problem. What you posted above is a
little out of context (even considering the original
question), so it's not at all clear to me what you are
trying to accomplish. Regardless of what I understand about
your situation, I do not believe that two queries/reports
are required.

Unfortunately, your above approach is trying to simulate
what you type in the query design window (QBE). The actual
queries used anywhere in Access are really SQL statements.
The stuff you specify in the QBE is just a shorthand
convenience that Access translates into SQL (which you can
see by using the query's SQL view). When you are
constructing a query or its criteria in VBA code, you must
work within the rules of SQL.

Bottom line here is that I believe you can achieve your
objective, but all I can guess at this point is that you may
want to use a more complex arrangement in the query.
Possibly something like creating a calculated field.

TestDate: IIf(Forms!F_Menu!DateV = True, GetDateCriteria
Between Forms!F_Menu!FromDate And Forms!F_Menu!ToDate, True)

and set the calculated field's criteria to True

Beyond that raw idea, we'll need more background about the
queries and their criteria.
 
Dear Marsh,

Thank you very much for your answer.

I'll explain what and why I try to do this.

I have a main report (of the main table) that contains
the name of the subjects that suits, the status of the
suit and so on. The sub report contains all the payments
that were made.

The sub report is built out of a query. Since I wasn't
able to check whether the user wanted to determine the
dates of the payments, I devided the query of the sub
report into 2 queries - one with a constraint on the date
field of the query and one without.
That's why I have 2 main reports - one for the constraint
query and one for the other.

I think I am going a round, I have been working on it for
days.... and after this long journey I got stuck.

The problem is that this is my first time with normalized
tables, and I probably made a lot of mistakes in the
reports.

I have a report, as I already mentioned, that contains
another sub report (for the payments).

I have the information for each record, and then I sum
all the subjects of the same organization and in the end -
the total sum.

In the "detail" of the report, I put the sub report that
is built on a query that summarize all the payments for
each suitID.

In the "Organization Footer", I put a report that is
built on another query that summarize all the payments
for each organization.

And in the "Report Footer", the same for all of the
records.

I open the main report using a script (after pressing a
button) which builds the MyCriteria and opens the report
using the following command:
DoCmd.OpenReport stDocName, acViewPreview, , MyCriteria.

BUT since only the suit detalis are shown in the main
report, in the query of the sub report I put the
constraints on the payments.

Since for the organization footer, I have another query,
it sums up all of the subjects in each organization,
without paying attention to the constraints of the main
report. For example, If I choose to make a report on a
specific organization, the total sum of all of the report
ignores this request, because it is built on another
query.

That's why I need to refer to the form, to check whether
the user wanted specific data and to put it in the
criteria of the query.

Please Please Please help me,
I don't know what to do.....

Thanks a lot a lot,
Sharon
-----Original Message-----
Sharon said:
In order to solve the problem I mentioned in my last
question, I tried to create a function that should return
the string with the criteria of the query and in the
criteria, I called this function.

The function looks like that:

Function GetDateCriteria()
If [Forms]![F_Menu]![DateV] = True then
GetDateCriteria = ">=[Forms]![F_Menu]![FromDate]
And <=[Forms]![F_Menu]![ToDate]"
Else
GetDateCriteria = "" 'I tried Null as well
End If
End Function
Click to expand...


Before I get to your question, I want to mention that it is
easier for all involved if you would keep the messages about
a single question in a single thread. Creating a new thread
with your reply (to yourself) just leaves everyone (most
likely yourself included) wondering what went on before.

Now, to talk about your problem. What you posted above is a
little out of context (even considering the original
question), so it's not at all clear to me what you are
trying to accomplish. Regardless of what I understand about
your situation, I do not believe that two queries/reports
are required.

Unfortunately, your above approach is trying to simulate
what you type in the query design window (QBE). The actual
queries used anywhere in Access are really SQL statements.
The stuff you specify in the QBE is just a shorthand
convenience that Access translates into SQL (which you can
see by using the query's SQL view). When you are
constructing a query or its criteria in VBA code, you must
work within the rules of SQL.

Bottom line here is that I believe you can achieve your
objective, but all I can guess at this point is that you may
want to use a more complex arrangement in the query.
Possibly something like creating a calculated field.

TestDate: IIf(Forms!F_Menu!DateV = True, GetDateCriteria
Between Forms!F_Menu!FromDate And Forms!F_Menu!ToDate, True)

and set the calculated field's criteria to True

Beyond that raw idea, we'll need more background about the
queries and their criteria.
Click to expand...
 
I thought about it, and understood that the problem may
accur because the sub reports in the "Organization
Footer" and the sub report in the "Report Footer" are not
linked to the main report.

The reason is that when I tried to do that - to link the
organization field that appear in both report and sub
report, I got the following message:
"You must add field playerID to your record source if you
want use this link" - but I need it to be linked using
organization field.

The sub report in the "Detail" is linked through suitID
and ID.

What did I do wrong?

Thanks again for your help,
Best,
Sharon

-----Original Message-----
Sharon said:
In order to solve the problem I mentioned in my last
question, I tried to create a function that should return
the string with the criteria of the query and in the
criteria, I called this function.

The function looks like that:

Function GetDateCriteria()
If [Forms]![F_Menu]![DateV] = True then
GetDateCriteria = ">=[Forms]![F_Menu]![FromDate]
And <=[Forms]![F_Menu]![ToDate]"
Else
GetDateCriteria = "" 'I tried Null as well
End If
End Function
Click to expand...


Before I get to your question, I want to mention that it is
easier for all involved if you would keep the messages about
a single question in a single thread. Creating a new thread
with your reply (to yourself) just leaves everyone (most
likely yourself included) wondering what went on before.

Now, to talk about your problem. What you posted above is a
little out of context (even considering the original
question), so it's not at all clear to me what you are
trying to accomplish. Regardless of what I understand about
your situation, I do not believe that two queries/reports
are required.

Unfortunately, your above approach is trying to simulate
what you type in the query design window (QBE). The actual
queries used anywhere in Access are really SQL statements.
The stuff you specify in the QBE is just a shorthand
convenience that Access translates into SQL (which you can
see by using the query's SQL view). When you are
constructing a query or its criteria in VBA code, you must
work within the rules of SQL.

Bottom line here is that I believe you can achieve your
objective, but all I can guess at this point is that you may
want to use a more complex arrangement in the query.
Possibly something like creating a calculated field.

TestDate: IIf(Forms!F_Menu!DateV = True, GetDateCriteria
Between Forms!F_Menu!FromDate And Forms!F_Menu!ToDate, True)

and set the calculated field's criteria to True

Beyond that raw idea, we'll need more background about the
queries and their criteria.
Click to expand...
 
I've been trying to figure that out all day, and can't come
up with anything except that you didn't specify the link
master child properties correctly. Remember that the link
child property must specify a field in the subreport's
record source table/query, the link master property may
refer to either a field or a control on the main report,
maybe this is the issue??
--
Marsh
MVP [MS Access]


I thought about it, and understood that the problem may
accur because the sub reports in the "Organization
Footer" and the sub report in the "Report Footer" are not
linked to the main report.

The reason is that when I tried to do that - to link the
organization field that appear in both report and sub
report, I got the following message:
"You must add field playerID to your record source if you
want use this link" - but I need it to be linked using
organization field.

The sub report in the "Detail" is linked through suitID
and ID.

What did I do wrong?

-----Original Message-----
Sharon said:
In order to solve the problem I mentioned in my last
question, I tried to create a function that should return
the string with the criteria of the query and in the
criteria, I called this function.

The function looks like that:

Function GetDateCriteria()
If [Forms]![F_Menu]![DateV] = True then
GetDateCriteria = ">=[Forms]![F_Menu]![FromDate]
And <=[Forms]![F_Menu]![ToDate]"
Else
GetDateCriteria = "" 'I tried Null as well
End If
End Function
Click to expand...


Before I get to your question, I want to mention that it is
easier for all involved if you would keep the messages about
a single question in a single thread. Creating a new thread
with your reply (to yourself) just leaves everyone (most
likely yourself included) wondering what went on before.

Now, to talk about your problem. What you posted above is a
little out of context (even considering the original
question), so it's not at all clear to me what you are
trying to accomplish. Regardless of what I understand about
your situation, I do not believe that two queries/reports
are required.

Unfortunately, your above approach is trying to simulate
what you type in the query design window (QBE). The actual
queries used anywhere in Access are really SQL statements.
The stuff you specify in the QBE is just a shorthand
convenience that Access translates into SQL (which you can
see by using the query's SQL view). When you are
constructing a query or its criteria in VBA code, you must
work within the rules of SQL.

Bottom line here is that I believe you can achieve your
objective, but all I can guess at this point is that you may
want to use a more complex arrangement in the query.
Possibly something like creating a calculated field.

TestDate: IIf(Forms!F_Menu!DateV = True, GetDateCriteria
Between Forms!F_Menu!FromDate And Forms!F_Menu!ToDate, True)

and set the calculated field's criteria to True

Beyond that raw idea, we'll need more background about the
queries and their criteria.
Click to expand...
Click to expand...
 
This is the thing...
When I press the "build" in the link master child
property, just to enter the wizard in which I choose the
linking fields, it wrote me that message -
"You must add field playerID to your record source if you
want use this link"
I didn't even wanted that field, since this is a report
for organizations...

What will I do with that?
Please, any help..........
-----Original Message-----
I've been trying to figure that out all day, and can't come
up with anything except that you didn't specify the link
master child properties correctly. Remember that the link
child property must specify a field in the subreport's
record source table/query, the link master property may
refer to either a field or a control on the main report,
maybe this is the issue??
--
Marsh
MVP [MS Access]


I thought about it, and understood that the problem may
accur because the sub reports in the "Organization
Footer" and the sub report in the "Report Footer" are not
linked to the main report.

The reason is that when I tried to do that - to link the
organization field that appear in both report and sub
report, I got the following message:
"You must add field playerID to your record source if you
want use this link" - but I need it to be linked using
organization field.

The sub report in the "Detail" is linked through suitID
and ID.

What did I do wrong?

-----Original Message-----
Sharon wrote:
In order to solve the problem I mentioned in my last
question, I tried to create a function that should return
the string with the criteria of the query and in the
criteria, I called this function.

The function looks like that:

Function GetDateCriteria()
If [Forms]![F_Menu]![DateV] = True then
GetDateCriteria = ">=[Forms]![F_Menu]! [FromDate]
And <=[Forms]![F_Menu]![ToDate]"
Else
GetDateCriteria = "" 'I tried Null as well
End If
End Function


Before I get to your question, I want to mention that
Click to expand...
it
is
easier for all involved if you would keep the messages about
a single question in a single thread. Creating a new thread
with your reply (to yourself) just leaves everyone (most
likely yourself included) wondering what went on before.

Now, to talk about your problem. What you posted
Click to expand...
above
is a
little out of context (even considering the original
question), so it's not at all clear to me what you are
trying to accomplish. Regardless of what I understand about
your situation, I do not believe that two queries/reports
are required.

Unfortunately, your above approach is trying to simulate
what you type in the query design window (QBE). The actual
queries used anywhere in Access are really SQL statements.
The stuff you specify in the QBE is just a shorthand
convenience that Access translates into SQL (which you can
see by using the query's SQL view). When you are
constructing a query or its criteria in VBA code, you must
work within the rules of SQL.

Bottom line here is that I believe you can achieve your
objective, but all I can guess at this point is that
Click to expand...
you
may
want to use a more complex arrangement in the query.
Possibly something like creating a calculated field.

TestDate: IIf(Forms!F_Menu!DateV = True, GetDateCriteria
Between Forms!F_Menu!FromDate And Forms!F_Menu!ToDate, True)

and set the calculated field's criteria to True

Beyond that raw idea, we'll need more background about the
queries and their criteria.
Click to expand...
Click to expand...

.
Click to expand...
 
Like I said before, I have no idea how you can be getting
that. Maybe you should not use the builder and just set the
Link Master/Child properties yourself?
--
Marsh
MVP [MS Access]


When I press the "build" in the link master child
property, just to enter the wizard in which I choose the
linking fields, it wrote me that message -
"You must add field playerID to your record source if you
want use this link"
I didn't even wanted that field, since this is a report
for organizations...

What will I do with that?
Please, any help..........
-----Original Message-----
I've been trying to figure that out all day, and can't come
up with anything except that you didn't specify the link
master child properties correctly. Remember that the link
child property must specify a field in the subreport's
record source table/query, the link master property may
refer to either a field or a control on the main report,
maybe this is the issue??

I thought about it, and understood that the problem may
accur because the sub reports in the "Organization
Footer" and the sub report in the "Report Footer" are not
linked to the main report.

The reason is that when I tried to do that - to link the
organization field that appear in both report and sub
report, I got the following message:
"You must add field playerID to your record source if you
want use this link" - but I need it to be linked using
organization field.

The sub report in the "Detail" is linked through suitID
and ID.

What did I do wrong?


-----Original Message-----
Sharon wrote:
In order to solve the problem I mentioned in my last
question, I tried to create a function that should
return
the string with the criteria of the query and in the
criteria, I called this function.

The function looks like that:

Function GetDateCriteria()
If [Forms]![F_Menu]![DateV] = True then
GetDateCriteria = ">=[Forms]![F_Menu]! [FromDate]
And <=[Forms]![F_Menu]![ToDate]"
Else
GetDateCriteria = "" 'I tried Null as well
End If
End Function


Before I get to your question, I want to mention that it
is
easier for all involved if you would keep the messages
about
a single question in a single thread. Creating a new
thread
with your reply (to yourself) just leaves everyone (most
likely yourself included) wondering what went on before.

Now, to talk about your problem. What you posted above
is a
little out of context (even considering the original
question), so it's not at all clear to me what you are
trying to accomplish. Regardless of what I understand
about
your situation, I do not believe that two queries/reports
are required.

Unfortunately, your above approach is trying to simulate
what you type in the query design window (QBE). The
actual
queries used anywhere in Access are really SQL
statements.
The stuff you specify in the QBE is just a shorthand
convenience that Access translates into SQL (which you
can
see by using the query's SQL view). When you are
constructing a query or its criteria in VBA code, you
must
work within the rules of SQL.

Bottom line here is that I believe you can achieve your
objective, but all I can guess at this point is that you
may
want to use a more complex arrangement in the query.
Possibly something like creating a calculated field.

TestDate: IIf(Forms!F_Menu!DateV = True, GetDateCriteria
Between Forms!F_Menu!FromDate And Forms!F_Menu!ToDate,
True)

and set the calculated field's criteria to True

Beyond that raw idea, we'll need more background about
the
queries and their criteria.
Click to expand...
Click to expand...
Click to expand...
 
Dear Marsh,

I tried to do that, but it didn't work as well.

After thinking a lot, I tried to link the queries in the
report itself using the suitID and than do just sum, and
it worked!!!!!!!!

I don't know why we need to use the sub reports, because
it looks like it just makes things more complicated (or
to someone who doesn't know how to use them....).
However, I managed to achieve what I wanted.

Thank you very much for your guidance and support,
Best Regards,
Sharon
-----Original Message-----
Like I said before, I have no idea how you can be getting
that. Maybe you should not use the builder and just set the
Link Master/Child properties yourself?
--
Marsh
MVP [MS Access]


When I press the "build" in the link master child
property, just to enter the wizard in which I choose the
linking fields, it wrote me that message -
"You must add field playerID to your record source if you
want use this link"
I didn't even wanted that field, since this is a report
for organizations...

What will I do with that?
Please, any help..........
-----Original Message-----
I've been trying to figure that out all day, and can't come
up with anything except that you didn't specify the link
master child properties correctly. Remember that the link
child property must specify a field in the subreport's
record source table/query, the link master property may
refer to either a field or a control on the main report,
maybe this is the issue??


Sharon wrote:
I thought about it, and understood that the problem may
accur because the sub reports in the "Organization
Footer" and the sub report in the "Report Footer" are not
linked to the main report.

The reason is that when I tried to do that - to link the
organization field that appear in both report and sub
report, I got the following message:
"You must add field playerID to your record source if you
want use this link" - but I need it to be linked using
organization field.

The sub report in the "Detail" is linked through suitID
and ID.

What did I do wrong?


-----Original Message-----
Sharon wrote:
In order to solve the problem I mentioned in my last
question, I tried to create a function that should
return
the string with the criteria of the query and in the
criteria, I called this function.

The function looks like that:

Function GetDateCriteria()
If [Forms]![F_Menu]![DateV] = True then
GetDateCriteria = ">=[Forms]![F_Menu]! [FromDate]
And <=[Forms]![F_Menu]![ToDate]"
Else
GetDateCriteria = "" 'I tried Null as well
End If
End Function


Before I get to your question, I want to mention
Click to expand...
that
it
is
easier for all involved if you would keep the messages
about
a single question in a single thread. Creating a new
thread
with your reply (to yourself) just leaves everyone (most
likely yourself included) wondering what went on before.

Now, to talk about your problem. What you posted above
is a
little out of context (even considering the original
question), so it's not at all clear to me what you are
trying to accomplish. Regardless of what I understand
about
your situation, I do not believe that two queries/reports
are required.

Unfortunately, your above approach is trying to simulate
what you type in the query design window (QBE). The
actual
queries used anywhere in Access are really SQL
statements.
The stuff you specify in the QBE is just a shorthand
convenience that Access translates into SQL (which you
can
see by using the query's SQL view). When you are
constructing a query or its criteria in VBA code, you
must
work within the rules of SQL.

Bottom line here is that I believe you can achieve your
objective, but all I can guess at this point is that you
may
want to use a more complex arrangement in the query.
Possibly something like creating a calculated field.

TestDate: IIf(Forms!F_Menu!DateV = True, GetDateCriteria
Between Forms!F_Menu!FromDate And Forms!F_Menu! ToDate,
True)

and set the calculated field's criteria to True

Beyond that raw idea, we'll need more background about
the
queries and their criteria.
Click to expand...
Click to expand...
.
Click to expand...
 
Now, that is good news.

I still have no idea why you were having so much trouble
with the subreport, but if you can Join the two tables in a
query to get the desired data, that is often the better
approach anyway. It may have been a long way around, but I
think you learned something significant during this
confusing exercise.

Way to go,
 
Thanks a lot.
Indeed, it is a good experience, but I wish I knew what
went wrong.

One more question, if that's OK, I encountered another
problem, hope that this can be solved.

I currently put in the report query the following:
the main table, a query on estimations and a query of
payment.
Both queries have the field of the ID of the main table -
that's how they are linked.

When I want to get the estimations and payments in a
range of given dates, it gives ONLY the records that have
BOTH estimations and payments in this range. ie, records
that have only estimations in the given dates or only
payment in the given date, don't appear in the
query/report.

After thinking about it, I realized that because I join
the queries it is as "AND" and not "OR".

How can I solve this?
If I make the calculations in another query and then join
them together afterwards, will it solve the problem?
If so, for an empty query on payments, for example, I
would like to put '0' in order that in the final query,
it will appear. How can I do that?

Thanks a lot again, for everything,
Best Regards,
Sharon
-----Original Message-----
Now, that is good news.

I still have no idea why you were having so much trouble
with the subreport, but if you can Join the two tables in a
query to get the desired data, that is often the better
approach anyway. It may have been a long way around, but I
think you learned something significant during this
confusing exercise.

Way to go,
--
Marsh
MVP [MS Access]


I tried to do that, but it didn't work as well.

After thinking a lot, I tried to link the queries in the
report itself using the suitID and than do just sum, and
it worked!!!!!!!!

I don't know why we need to use the sub reports, because
it looks like it just makes things more complicated (or
to someone who doesn't know how to use them....).
However, I managed to achieve what I wanted.

Thank you very much for your guidance and support,
Best Regards,
Sharon
Click to expand...

.
Click to expand...
 
Ah ha! A question I can answer ;-)

You need to use an outer join instead of an inner join
between the main table and the related tables/queries.

Open the query in design view, right click on the line (not
easy to get the mouse on such a thin line) between the main
table and a query. Choose the properties item and then
select the join option that includes all records in the main
table and any matching records in the the related query.
Repeat with the line to the other query. The lines should
now have arrow heads on the query side.
--
Marsh
MVP [MS Access]


Thanks a lot.
Indeed, it is a good experience, but I wish I knew what
went wrong.

One more question, if that's OK, I encountered another
problem, hope that this can be solved.

I currently put in the report query the following:
the main table, a query on estimations and a query of
payment.
Both queries have the field of the ID of the main table -
that's how they are linked.

When I want to get the estimations and payments in a
range of given dates, it gives ONLY the records that have
BOTH estimations and payments in this range. ie, records
that have only estimations in the given dates or only
payment in the given date, don't appear in the
query/report.

After thinking about it, I realized that because I join
the queries it is as "AND" and not "OR".

How can I solve this?
If I make the calculations in another query and then join
them together afterwards, will it solve the problem?
If so, for an empty query on payments, for example, I
would like to put '0' in order that in the final query,
it will appear. How can I do that?

Thanks a lot again, for everything,
Best Regards,
Sharon
-----Original Message-----
Now, that is good news.

I still have no idea why you were having so much trouble
with the subreport, but if you can Join the two tables in a
query to get the desired data, that is often the better
approach anyway. It may have been a long way around, but I
think you learned something significant during this
confusing exercise.

Way to go,
--
Marsh
MVP [MS Access]


I tried to do that, but it didn't work as well.

After thinking a lot, I tried to link the queries in the
report itself using the suitID and than do just sum, and
it worked!!!!!!!!

I don't know why we need to use the sub reports, because
it looks like it just makes things more complicated (or
to someone who doesn't know how to use them....).
However, I managed to achieve what I wanted.

Thank you very much for your guidance and support,
Best Regards,
Sharon

-----Original Message-----
Like I said before, I have no idea how you can be getting
that. Maybe you should not use the builder and just set
the Link Master/Child properties yourself?
Click to expand...

.
Click to expand...
Click to expand...
 
I can't tell how happy I was to read your first
sentence :-) :-) :-)

I did it and it's working!!!!

Thanks a lot!!!

Best and Warm Regards,
Sharon

btw - If I encounter another problem concerning this
matter, I will send to this message if that's OK by you.
-----Original Message-----
Ah ha! A question I can answer ;-)

You need to use an outer join instead of an inner join
between the main table and the related tables/queries.

Open the query in design view, right click on the line (not
easy to get the mouse on such a thin line) between the main
table and a query. Choose the properties item and then
select the join option that includes all records in the main
table and any matching records in the the related query.
Repeat with the line to the other query. The lines should
now have arrow heads on the query side.
--
Marsh
MVP [MS Access]


Thanks a lot.
Indeed, it is a good experience, but I wish I knew what
went wrong.

One more question, if that's OK, I encountered another
problem, hope that this can be solved.

I currently put in the report query the following:
the main table, a query on estimations and a query of
payment.
Both queries have the field of the ID of the main table -
that's how they are linked.

When I want to get the estimations and payments in a
range of given dates, it gives ONLY the records that have
BOTH estimations and payments in this range. ie, records
that have only estimations in the given dates or only
payment in the given date, don't appear in the
query/report.

After thinking about it, I realized that because I join
the queries it is as "AND" and not "OR".

How can I solve this?
If I make the calculations in another query and then join
them together afterwards, will it solve the problem?
If so, for an empty query on payments, for example, I
would like to put '0' in order that in the final query,
it will appear. How can I do that?

Thanks a lot again, for everything,
Best Regards,
Sharon
-----Original Message-----
Now, that is good news.

I still have no idea why you were having so much trouble
with the subreport, but if you can Join the two tables in a
query to get the desired data, that is often the better
approach anyway. It may have been a long way around, but I
think you learned something significant during this
confusing exercise.

Way to go,
--
Marsh
MVP [MS Access]



Sharon wrote:
I tried to do that, but it didn't work as well.

After thinking a lot, I tried to link the queries in the
report itself using the suitID and than do just sum, and
it worked!!!!!!!!

I don't know why we need to use the sub reports, because
it looks like it just makes things more complicated (or
to someone who doesn't know how to use them....).
However, I managed to achieve what I wanted.

Thank you very much for your guidance and support,
Best Regards,
Sharon

-----Original Message-----
Like I said before, I have no idea how you can be getting
that. Maybe you should not use the builder and just set
the Link Master/Child properties yourself?

.
Click to expand...
Click to expand...

.
Click to expand...
 
Back
Top