Search results

  1. J

    Give the highest number in a field of a table

    Hi, I am writing SQL for a query in which I find the highest number in an autonumber. That in itself is very easy, however the users often create new records by mistake without filling them in. This is a problem because the autonumber is referenced in another query which returns the rest of the...
  2. J

    Export as PDF with specified name and current date

    Hi, I have a macro to export the report I created as a PDF, and it works perfectly fine. However, I would like to take away the 1 last option for user error and have it automatically name it "Weekly Report" and the current date. I have tried the following in the 'Output File' section of the...
  3. J

    Can I use a form to change a part of a calculated field in a table?

    In my tables I have some calculated fields which look like [WeeklySales]/60000 where [WeeklySales] is input via form. This calculated form returns a percentage. There are also a couple of other areas which use this number, such as a query and a report, but 1 step at a time. The point is, these...
  4. J

    Writing an expression which Sums textboxes containing running totals

    Hi, I have created a report which uses references from several queries, taking only a specific record depending on which Week number they type in. In one of these queries is a running total using the code: RunTot8: DSum("[Rotorua_TotalSales]","[AllData]","[Week Number] <=" & [Week Number]) Where...
Top Bottom