Recent content by confuse

Please help me with the union query,, It consist of 2 queries and 1 table. (Petshop orders,clinic orders and orders). This query calculate the total sales, (petshop orders.total+clinic orders.totalcharges), this works fine. But if one of the field dont have value then no value will display. I...

so much headache with this.. i use Nz([fieldname],0), it works with both field are null, but if one field have value then it Nz doesnt work..and it will affect my report... Please do help guys.....

i got it rich....thanks for your idea....anyway i got another problem, how to put ZERO value if no data in one of the field??

sorry.... Is this correct?? SELECT [OrderID], [OrderDate] FROM [Orders] UNION SELECT [OrderID], [Total] AS [Petshop] FROM [Order Details Petshop Query]; UNION SELECT [OrderID],[TotalCharges] AS [Klinik] FROM [Order Details Query Query]; It doesnt work to me.... Apology....:o

Thanks for your idea rich.... i applied that, but im not sure if i got the correct syntax, because instead of displaying 4 fields(orderid,orderdate,total,totalcharges) it display two fields only the value of total and totalcharges field was inserted to orderdate. here is my sample code...

The common field is OrderId.yeah its possible that one query dont have the value. Thanks for the reply....Hope you can help me....:)

I have a query named netincome query, c0mpose of two query named petshop query and clinic query. I want to display the total value of this two query. Following are example of data that i want to display Date--------Petshop query------Klinik Query--- Sales 09/10/08----260.00--...

thanks for the help the dock man, i got it......:o

hi Skwilliams can you share to me how you solve this problem??? Hope to hear from you... Thanks

tnx for immediate reply bob.... attached here my sample database.... thanks again...

Hi To all!! I need again your help guyz... I have an error in my query which i name it Product Sold Query, it is compose of 3 tables named: Inventory Transactions Query, Order Details and products which the 2 tables are being related. In Inventory Transactions Query fields are: ProductID Name...

Oppss,sorry rabbie....here take a look,hope you can help..

Hi to all.. I'd like to ask some help again, first : how to eliminate the redundant value in a query. I have query named product sold, the calculate works fine but then it will show redundant values. Like example: Products Query Products Query Product ID Product Name Quantity...

Hi to all.. I'd like to ask some help again, first : how to eliminate the redundant value in a query. I have query named product sold, the calculate works fine but then it will show redundant values. See attached files.. i want to eliminate the redundancy of data. its waste of space...

Wayne,, Thanks a lot... It works...Thank you very much:D