Search results

good day, i have a problem and i don't know what to do with it, so plz help i am breaking down here.... here is the query SELECT Sum(QuantityFree) AS SumמתוךQuantityFree FROM ( SELECT ItemsInOrder.itemName, Item.itemPrice, (ItemsInOrder.price-ItemsInOrder.DiscountGiven) AS PriceBeforeDiscount...

thanks brian and bob i really appreciate your help, both methods worked thank u and have a great day roy

no change thanks Brian u are correct with the full date+hour issue, but even after i wrote tried to change the format there was no change SELECT Order.InvoiceNum, Order.time, Order.[Total Price], Order.[Cash/Credit], Order.Company, Order.CustomerPhone, Users.WorkerName FROM Users INNER JOIN...

hi i wish to find a date (format=general Date) in a table and for some reason it give me a blank (null) anwer here is my query: SELECT Order.InvoiceNum, Order.time, Order.[Total Price], Order.[Cash/Credit], Order.Company, Order.CustomerPhone, Users.WorkerName FROM Users INNER JOIN [Order] ON...

hello i wish to put a box in a report that gives back a single colum to a query. i already have a working query, how can i do it, maybe i am doing something wrong

hello i have a form with tabs, is there a way to adjust the tabs size? thanks

thanks, that's easy, but what can i do if i have much more complex query? SELECT "דמי משלוח" AS Name, Sum(DeliveryFee) AS fee FROM (SELECT O.OrderID, O.[Total Price]-(1+O.DiscountPercentGiven)*Sum(iio.price-iio.DiscountGiven) AS DeliveryFee, Sum(iio.price-iio.DiscountGiven) AS Sumמתוךprice...

hi i am new at this, and i have a problem in an UPDATE query every time i try it gives the message: "Operation must use an updatable query. (Error 3073)" this is my query and i couldn't find anything wrong with it, the inner query works well, so thah's not the problem UPDATE...

hello, can any1 help me with this problem i don't know what to do :confused: the error message won't stop.... here is my code: Private Sub _AfterUpdate() Dim dbsProject As Database Dim q As QueryDef Dim res As Recordset Dim strSQL As String Set dbsProject = CurrentDb strSQL = "SELECT...

thanks, i feel a bit stupid for not noticing it :)

hello i have a problem and i will appritiate your help... there is a subform which i want to use inorder to insert data to a table. i wanted it to be new with no prev records so i turn the insertdata to enable ("yes") and this seems to work. the problem is that the record is saved every time i...