Question about query. (1 Viewer)

[GaDauBac]

Hi everybody!
I have 1 database with the following error:
- At the query "qrGiaTriHD" when opened, it reported an error that did not enter "TongTT" and "TienGiamGia" but still reported correctly. How to not get such an error?
- How does Query display like this?

I attached the database.
Thank you everyone!

 

[The_Doc_Man]

The items TongTT and TienGiamGia would appear to have been either spelled incorrectly or not properly qualified as to where they can be found. The "Input Box" that kicks in when you open the query is telling you that the items it is asking for were not available to it from a table when Access tried to open the query. You should verify the spelling of the items that are missing. Note that since the two items you called out are, in fact, aliases for another field, it may be that the underlying field to the alias is the problem.

You may also have a second problem, OR it might be related to the first one. You have three tables in your query with one relationship directly from the 1st to the 3rd table, but the other relationship goes through the 2nd table. This means that you have an ambiguous path from beginning to end for that relationship, and that can confuse Access. So I can't guarantee you that the error of the missing data isn't due to this ambiguous path.

 

[GaDauBac]

The items TongTT and TienGiamGia would appear to have been either spelled incorrectly or not properly qualified as to where they can be found. The "Input Box" that kicks in when you open the query is telling you that the items it is asking for were not available to it from a table when Access tried to open the query. You should verify the spelling of the items that are missing. Note that since the two items you called out are, in fact, aliases for another field, it may be that the underlying field to the alias is the problem.

You may also have a second problem, OR it might be related to the first one. You have three tables in your query with one relationship directly from the 1st to the 3rd table, but the other relationship goes through the 2nd table. This means that you have an ambiguous path from beginning to end for that relationship, and that can confuse Access. So I can't guarantee you that the error of the missing data isn't due to this ambiguous path.

But after query, the returned result is true??

 

[arnelgp]

check the query and report.

 

[GaDauBac]

check the query and report.

Hello!
After I edited the Query it failed again please review it for me and tell me why it failed.
Now Query does not group ?
Thank you!

 

[arnelgp]

see your query.

 

[GaDauBac]

see your query.

Thank you!
Can you tell me why?

 

[arnelgp]

see the query, the answer is in there.

 

[GaDauBac]

see the query, the answer is in there.

Hi!
I see when the Query query returns the results as shown, I want to group SHD 14, 15, 16 (which is 2 items but only in 1 invoice)
Please help me check. Thanks!

 

[arnelgp]

they have 2 records in tb2_ChiTietHopDong table?

 

[GaDauBac]

they have 2 records in tb2_ChiTietHopDong table?

These 2 records have 1 HD number, so they are in 1 invoice (so they must be grouped in the same invoice)

 

[arnelgp]

on your query (qr_Dt-CN) ThanhTien is being used from table tb2_ChiTietHopDong.
do you need to Sum() the 2 records of same invoice?

 

[GaDauBac]

Yes! that's exactly it, thank you for understanding

 

[arnelgp]

here i made another query and use it in replacement of table tb2_ChiTietHopDong.

 

[GaDauBac]

here i made another query and use it in replacement of table tb2_ChiTietHopDong.

Really thank you very much!