Search results

  1. C

    Show week beginning on a report

    You are a genius. That code works an absolute treat. Thank you ever so much for all your help. Anthony
  2. C

    Show week beginning on a report

    That's what I've had to resort to, but I'd really like it if it would display 4/3/2002 as that is the Monday of that week. Perhaps I should modify the question to: How can I display the date of the Monday on my report when it is grouped into weeks? Or how can I convert =Format([date],"ww")...
  3. C

    Report footer at bottom of page

    I am in no way fluent with access, but I have had a similar problem and got around it by doing the following. Right-click the Report Header and Force New Page - After Section then Right-click the next footer just above the report footer (StaffName footer in my case) and Force New Page - After...
  4. C

    Show week beginning on a report

    Hi I am creating a monthly report of product outputs grouped by members of staff but with a week by week breakdown. My problem is that if a member of staff doesn't have any outputs on Monday, then the date on the report is set to the first instance (whenever in that week he does have some...
  5. C

    Self populating a table from another table with a form

    Hi Doug, Thanks for that tip, it put me on the right track. In all the times I was checking the help files, not one of them suggested a combo box. Now it seems really obvious. Anyway, many thanks again Anthony
  6. C

    Self populating a table from another table with a form

    I have 2 unlinked tables and a form. The first table contains basic information (unique number, part # & Qty), this table is updated daily from another database (not compatible, and off limits to me). The second table contains details of details related to the unique number, part # & Qty. The...
  7. C

    Selecting last months data

    In the end I plumped for Harry's solution which works a treat. So thanks again for your help. Anthony
  8. C

    Selecting last months data

    Excellent. Cheers for both those pointers, I'll try them out as soon as I can (Unfortunantely I can only devote an hour or so a day to Access). Again, thanks for all your help. Anthony
  9. C

    Selecting last months data

    I am trying to create a report totalling up data for 'last month's' data input. I would like to be able to run this report at any time in the month without affecting the data collected (initially I tried using DataAdd, but found that it only collected data a month prior to the current date). I...
Back
Top Bottom