Solved Duplicate Records in Order Query

[arnelgp]

is it possible for you to Zip your latest db that you have?
i am confused of all the db i have downloaded and don't know
if i have deleted it from my pc.

 

[Sarah.M]

is it possible for you to Zip your latest db that you have?
i am confused of all the db i have downloaded and don't know
if i have deleted it from my pc.

Hi, thank you for your help!
plz find the attached file

 

[arnelgp]

is this the latest? it seems where back to square 1.
you can't have a query like that without Joins, otherwise
it will multiply your records by each records on each table
as you can see on the datasheet.

 

[Sarah.M]

is this the latest? it seems where back to square 1.
you can't have a query like that without Joins, otherwise
it will multiply your records by each records on each table
as you can see on the datasheet.

Hi, thanks for ur reply,
I feel shy to ask you again for help
Thanks for ur understanding

 

[arnelgp]

I feel shy to ask you again for help

you don't need to be.
i will help if i know how.

from your last post, do you only want to be able to
filter on those 3 calculated columns?
if so, i add them to your query.
see if you can now.

 

[Sarah.M]

you don't need to be.
i will help if i know how.

from your last post, do you only want to be able to
filter on those 3 calculated columns?
if so, i add them to your query.
see if you can now.

Thank you very much!!!!