querying from 2 dynasets

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

Guest

hi community :)
Condition:
Every paper there are more than 1 author

trying to make queries based on 2 queries

where / what is the common fault whenever a query is made based on 2
dynasets and the return value does not show all the result ?

any assistance much appreciated :)


thanks community --
oldLearner57
 
We aren't there. We won't be able to help if we don't have a clear idea of
what you have and what you are trying to do.

What does "paper" have to do with queries?

What are you trying to do?

What does "common fault" mean?

What does "all the result" have to do with queries? Queries return the
recordset you describe to Access, with the selection criteria and sorting
options and the fields selected.

More specific description will lead to more specific suggestion.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
hi community

my apology for not being concise, here i wrote down the expression from the
Expression Builder:

Expr1:[qrySeniorAuthor.author] & IIf([qryGetSecond.author1]=",",','
&[qryGetSecondAuthor.author1]
&IIf([qryGetThirdAuthor.author1]=",",',' &[qryGetThirdAuthor.author1])

with the above query, my return is only 1 n it suppose to return more than 1

and

this part -( Expr1:[qrySeniorAuthor.author] &
IIf([qryGetSecond.author1]=",",',' )
after the { = } i observe that it shows ","
what does that mean ?

thanks again for the assistance render

thanks community for guidance :)
 
I'll suggest that you check Access HELP on the IIF() function. What you are
seeing is what your expression is telling Access to do.

By the way, if I'm reading the expression correctly, it looks like it says
to show a comma (',') plus a " , " if qryGetSecondAuthor has only " , ", and
the same again for ThirdAuthor.

Check the syntax of the expression...

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

oldLearner57 said:
hi community

my apology for not being concise, here i wrote down the expression from the
Expression Builder:

Expr1:[qrySeniorAuthor.author] & IIf([qryGetSecond.author1]=",",','
&[qryGetSecondAuthor.author1]
&IIf([qryGetThirdAuthor.author1]=",",',' &[qryGetThirdAuthor.author1])

with the above query, my return is only 1 n it suppose to return more than 1

and

this part -( Expr1:[qrySeniorAuthor.author] &
IIf([qryGetSecond.author1]=",",',' )
after the { = } i observe that it shows ","
what does that mean ?

thanks again for the assistance render

thanks community for guidance :)


--
oldLearner57


Jeff Boyce said:
We aren't there. We won't be able to help if we don't have a clear idea of
what you have and what you are trying to do.

What does "paper" have to do with queries?

What are you trying to do?

What does "common fault" mean?

What does "all the result" have to do with queries? Queries return the
recordset you describe to Access, with the selection criteria and sorting
options and the fields selected.

More specific description will lead to more specific suggestion.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
Click to expand...
Click to expand...
 
Back
Top