Search results

  1. E

    Date Add Function

    Try this in your control sorce: =([Form]![form Admission]![Admission Date])+10 If it does not work let me know I may have another idea. [This message has been edited by eason (edited 01-04-2000).]
  2. E

    Recordset Error?

    I'm developing a report and have this as a problem, can anyone help me??? I have 3 differant tables that I am using. One called test_def then sam_log and sam_res. I have a query called qryPC_IncompleteTest that has sam_res in it and primary key is sam_id. In another query2 called...
  3. E

    Find last months first and last date.

    I've developed a report for a company. In the header they want last months first and last date to print. When finished the report will generate itself on the 5th of each month for last month totals. How do I get last months first and last date to print automaticly in the header? What about...
  4. E

    Automaticly run report on 5th of month

    I have developed a report for a company. They would like to have it print out on the 5th of each month for the previous month. They do not want to even push a botton. How do I get the report to print and how dose it go from Jan. of one year to Dec. of the previous year?
  5. E

    Report Sums

    Try this. =Sum[Text Box Title] for each department in the footer and then at the end of the report do the same thing again, but refer to the Text Box Title in the footer. Hope this works. Eason
  6. E

    Combo Box Record Source

    Yes, it can have more than one table and/or query. But it all must be made into one query. In the query that is the source of info for your combo box you need to add in the table and/or query that has the additional info you need for your combo box. Then build your relationships and add in the...
  7. E

    Set Key command to copy text box.

    I have a form that is for data entry. The form is set on Continuous Form. Alot of the entry is redundent such as date and codes, but changes about every five to ten entries. When the info is entered it is about 100 entries at a time. I have a micro set up to copy the info in the provious text...
  8. E

    how to calculate percentage in repirt

    Try this, ([total hr]*100)/[Grand hr]-100
  9. E

    Autonumber on a report?

    I have a report that sorts stores by thier sales performance. Is report is ran daily and the rankings change from day to day. What I need to do is add in a textbox to the report that will autonumber the stores and they are sorted. The number of store will change monthly. Any ideas?
  10. E

    Auto number in a Report?

    How do I run an Auto Number on a Report? I need for the number to appear next to a name. This is for ranking purpose so I can tall how different items are rank when the report is ran.
  11. E

    Coping from one text box to another text box?

    In a continuous form, I'm tring to copy input form one text box to the same text box on the next line. What are my options?
Back
Top Bottom