Search results

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...

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

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.

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.

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...