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 Rhinorhino 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: *

  • Users: BCre8iv
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. BCre8iv

    Refering to a control on another form

    I have a products form where my control source for MSRP is as follows. =IIf(IsNull([MSRPUSD]),[MSRPCDD],([MSRPUSD]*Forms![Conversion Rate]!FieldValue)) This works great and gives me exactly what I want, mathematically, except for the fact that the Conversion Rate form has to be open. Is there...
  11. BCre8iv

    Choosing one of two fields and putting new amount into 3rd field!!

    I am new at the d/b stuff so bear with me. I want to be able to convert money from Cdn to US and vice versa. The user will input the conversion rate in a table. Now what has to happen, if possible is the following. My user purchases product from Cdn and US suppliers. The supplier table is where...
  12. BCre8iv

    Currency Conversion

    I have a dilemma!!! I need to know how to make my tables relate so that information drawn from a table can be compared to data in another table and converted to Canadian dollars based on that data. In other words if one of my customers is Canadian I need to invoice that client in Cdn dollars...

Part and Inventory Search

Back
Top