Recent content by greenythebeast

  1. G

    SQL crosstab query with multiple grouping levels

    I'm trying to construct an SQL crosstab query that will output data like the picture I've attached in the .zip file. The four variables from the data table would be [Client Accounting].[Marketer] (the left vertical column), [Client Accounting].[Closing Date] (the higher level horizontal column...
  2. G

    Refreshing an Access form textbox if user deletes a record from table

    Yup, that's what I tried. Didn't work at all. Is it because the textbox displays the count using DefaultValue?
  3. G

    Refreshing an Access form textbox if user deletes a record from table

    As I said in my original post, I tried a Requery command but cannot get it to work. The textbox won't refresh while the user is in the form.
  4. G

    Refreshing an Access form textbox if user deletes a record from table

    It's a data entry form so only new records can be entered. Only I have access to the tables, but if I had to delete an invalid entry from the table it would be nice for the count of the user to be correct.
  5. G

    Refreshing an Access form textbox if user deletes a record from table

    I have a form with a Count textbox. It's control source is a field named "Audit Count" in the table "DB Audits". The idea of the textbox is to display a running count of how many audits a specific auditor has completed that day. To do this I have the textbox set up with a default value of...
See more
Back
Top Bottom