Sorry for the lack of detail.This is what I have for the Extended price:
Extended: IIf(IsNull([Price]*[Qty])," ",[Price]*[Qty])
This is for the Tax Amount:
Tax: IIf(IsNull([Order Details].[UnitPrice]*[Quantity]*(1/100*[Rate])*100)," ",([Order...
I figured out the parameter box thing. Stupid mistake, had the wrong fields on the report. Now I just need to solve the calculated fields on the reports when dealing with nulls.
My time and that is in about 13 hrs or so.
Thx
Tina
This is the entire query. And Extended detail and tax amount fields are based on calculated fields from the Order Detail Query.
QrySELECT [Orders Qry].OrderID, [Orders Qry].CustomerID, [Orders Qry].OrderDate, [Orders Qry].[Tax Total], [Orders Qry].Freight, [Orders Qry].ShipName, [Orders...
Hi, I have a report that is based on a query where I have used IIf(IsNull). When I look at the query it is giving me the records that I want, however when I open the report that is based on the query I get a parameter dialog box. If I click OK to close the box and open the report, the report...
Okay, Rick I did the first two things. Thx
I also tried the Nz([Order Details Extended].[field name]) but my report now comes up with a Enter parameter value box. Not good. Just so you know, nulls and I don't get along very well. ;)
And without the Nz blurp My report doesn't open at all, I get...
Hi there...I forgot to give this a title the other day, sorry.
I have an invoice that is printed off daily. The invoice is based on the query below. Now if the client actually has a preorder and this information is filled out in the order form, my invoice prints out fine. My problem is, most of...
Hi
I have the right join in place and I get invalid use of nulls, which i expected. I'm not very good with dealing with Nulls, getting better though. Neway, doesn't NZ()'s put a zero in the field? I need the quantities, values, etc to remain blank so that the drivers can write in the info on the...
Hi there...I forgot to give this a title the other day, sorry.
I have an invoice that is printed off daily. The invoice is based on the query below. Now if the client actually has an preorder and this information is filled out in the order form, my invoice prints out fine. My problem is, most of...
Hi there...
I have an invoice that is printed off daily. The invoice is based on the query below. Now if the client actually has an preorder and this information is filled out in the order form, my invoice prints out fine. My problem is, most of the time a blank invoice with only customers...
Hi,
Well the new query works fine, but as soon as I join it with the main query I end up with all records showing for the individual customer but the Date is the last date used. In other words, instead of having the different dates that the transactions actually happened they all have the last...
I am still having problems getting the records I need to display via last date entered which is DateDepositMade. I get the record I want however the OnSite field is a sum of all records for a particular company. This is not the result I need. I need the OnSite to show the last amount entered on...
I am still having problems getting the records I need to display via last date entered which is DateDepositMade. I get the record I want however the OnSite field is a sum of all records for a particular company. This is not the result I need. I need the OnSite to show the last amount entered on...
It works if I sum total records in the OnSite field but I don't want that. I also tired DMax("[DateDepositMade]","BottlePaymentsSubform") which worked great as long as I was summing the records in the OnSite field. Unfortunately for me that isn't what is wanted. Any...
I am trying to get a query to return the record with the latest date: The user will input many records for one company but the only record that is needed in the report is the last date data is entered. I thought I had it figured out but I can't get it to give me just one record per customer. Any...
Hi there,
Below is a query that I have in place. Works great except that I need it to only select the record for the last date of entry in the DateDepositMade. Any help would be great! Thx
SELECT Customers.CompanyName, BottlePaymentsTable.BottleDeposit, BottlePaymentsTable.AmountofDeposit...
Hi there,
DLookup is new to me but from what I understand it is probably my best bet. I have a Products table that has three different prices, Key is ProductID.
Prices: Retail, Wholesale1, and Wholesale2.
Now I have a customers table where the user selects the CustomerType using a combo box...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.