Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BCre8iv

    IIf(IsNull) query producing unwanted parameter in report

    Okay this is what I put: Extended: ([Price]*[Qty]) and I still get an #error in the field. Tina
  2. BCre8iv

    IIf(IsNull) query producing unwanted parameter in report

    Sorry the tax field reads: Tax: IIf(IsNull([Price]*[Qty]*(1/100*[Rate])*100)," ",([Price]*[Qty]*(1/100*[Rate])*100)) Thx again Tina
  3. BCre8iv

    IIf(IsNull) query producing unwanted parameter in report

    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...
  4. BCre8iv

    IIf(IsNull) query producing unwanted parameter in report

    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
  5. BCre8iv

    IIf(IsNull) query producing unwanted parameter in report

    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...
  6. BCre8iv

    IIf(IsNull) query producing unwanted parameter in report

    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...
  7. BCre8iv

    Hi there... I have an invoice that

    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...
  8. BCre8iv

    Null values that need to be blank not zero???

    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...
  9. BCre8iv

    Invoice that includes Null values?

    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...
  10. BCre8iv

    Invoice that includes Null values?

    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...
  11. BCre8iv

    Hi there... I have an invoice that

    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...
  12. BCre8iv

    Qry not working? Retrieving via last date?

    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...
  13. BCre8iv

    Qry not working? Retrieving via last date?

    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...
  14. BCre8iv

    Still having problems getting the records I need?!

    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...
  15. BCre8iv

    Latest date qry....

    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...
  16. BCre8iv

    Latest date qry....

    I am still getting two records for each company....showing both dates that data was inputted....
  17. BCre8iv

    Latest date qry....

    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...
  18. BCre8iv

    Qry:Grouping by dates

    Thx Bill that worked out great however it drew it in on the first pass...
  19. BCre8iv

    Qry:Grouping by dates

    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...
  20. BCre8iv

    DLookup/Combo Box criteria from another table

    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...

Part and Inventory Search

Back
Top