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!

  • Congratulations gkittelson 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. lorenzor

    HOW CAN I DELETE AN EXTRA PAGE ON PRINTING

    Hi there, It seems that my database is running ok, but, when I want to print my inform, it prints the data ok but at the end it jumps to the next page like page and a half, and I just want to stop printing in the last data. Can you help me, Thanks in advanced, Erick.
  2. lorenzor

    HOW CAN I GET A TOTAL IN A REPORT

    Thank you mike, I did right now, Erick.
  3. lorenzor

    HOW CAN I GET A TOTAL IN A REPORT

    I have done everything I know to get a total in my main invoice report, but still cant make it right. I tried to repeat the process I did when I calculate the total in my main form, but I couldn't made it. I send you a sample of my database for you to know exactly where is my problem and how...
  4. lorenzor

    HOW CAN I PRINT ONE RECORD IN A REPORT

    Gracias (thanks) John! everything is doing good now. Erick.
  5. lorenzor

    HOW CAN I PRINT ONE RECORD IN A REPORT

    Hola Linda, your help was really good, but still cant make it work. if you want I can send you a sample of what I've done, for you to know exactly, where is the problem. Thanks your help. Erick.
  6. lorenzor

    HOW CAN I PRINT ONE RECORD IN A REPORT

    Hello John, I have searched about this unique identifier, but I couldn't find where its located, I got in the macro window, and I tried to filter the registers , but I couldn't do it, I read the access help about this, but still dont know how to do it. I have the report, but still shows all...
  7. lorenzor

    HOW CAN I PRINT ONE RECORD IN A REPORT

    Hello, I've been trying to print a single record of a form with the specific data on the screen but with different format on printing. I have done a report with the wizard, with the two queries I needed in the form, but the thing is that the report gets all the records and I just need: the...
  8. lorenzor

    CALCULATE A TOTAL ON A SUBFORM

    hello, Gus! Northwind, was helpfull to get the mystake that I had on my subform, but still can't make it right. I did what you told me, step by step on your last 2 messages, but, as I see a control with the Sum() function does not sum controls with operations. I just get an Error# message in...
  9. lorenzor

    CALCULATE A TOTAL ON A SUBFORM

    I believe i found the problem, the thing is that the function SUM( ), does not sum an unbound control with an operation, and i have a division to sum. what i have in the unbound control "des" : [price]/1.15 and i want to get a subtotal of : sum [qty]*[des] but cant make it right, just...
  10. lorenzor

    HOW CAN I SUM AND OPERATION

    I have to sum a control that has a division, but it seems that the function sum() does not sum a unbounded control with an operation. Can you help me? Thanks in advance. Erick.
  11. lorenzor

    CALCULATE A TOTAL ON A SUBFORM

    If you want to Sum fields in a form, put the unbound control in the footer of the form. Or if it is a subform, put it in the footer of the subform. Your calculation above should be SUM([Price]*[Qty]) (notice the brackets around EACH field name) As to why you can't see the field...do you maybe...
  12. lorenzor

    CALCULATE A TOTAL ON A SUBFORM

    i have to calculate the sum of many records on a subform for an invoice form. I been doing everything I found possible with the access help , but still can make it right. Dont know exactly where is the root of the problem! What should i use? the "total" control must to be an...

Part and Inventory Search

Back
Top