If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
count #error
I'm SO new in Access that saying I'm a beginner is excruciatingly charitable
-- I have a report built from a Query where I've selected just customers for one employee (i.e., Adams) -- I want a total of how many entries (customers) are on this report. I've tried "=count([FieldNameofEmployee])" and all kinds of crazy alternates that I saw as suggestionns from other people posting similar problems -- but nothing -- regardless what I put, I relentlessly get "#error" --- this is going to drive me to drink............ |
#2
|
|||
|
|||
count #error
Where is this text box?
In report design view, make sure the text box is in the Report Footer or a group footer, not in the Page Footer section. For the Control Source, try: =Count("*") Make sure the name of this text box is not the same as any of the fields in the report. (The Name is on the Other tab of the Properties box.) -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Dominique" wrote in message ... I'm SO new in Access that saying I'm a beginner is excruciatingly charitable -- I have a report built from a Query where I've selected just customers for one employee (i.e., Adams) -- I want a total of how many entries (customers) are on this report. I've tried "=count([FieldNameofEmployee])" and all kinds of crazy alternates that I saw as suggestionns from other people posting similar problems -- but nothing -- regardless what I put, I relentlessly get "#error" --- this is going to drive me to drink............ |
Thread Tools | |
Display Modes | |
|
|