Search results

The first record,I had two records. After I set group by, Records sum up to one and the qty should be 2000.But here just 1000. Why? Please help!!

[qty]*[price] <---work find but , i want to sum up the total, it comes an error =sum([qty]*[price]) Please take a look of the attachments. is anyone can help me? Thank you very much

i fixed it.

i have a table , [order]![date] I want to calculate which client didn't place order over 30 days =Datediff("d",[order]![date],now())>30 But this didn't show any result in the query. Who can tell me what is the problem? Thank you