Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Showing data on switchboard

Author  Topic 

mase2hot
Starting Member

36 Posts

Posted - 2010-04-25 : 06:37:48
Hi,

on my switchboard I have an option for a form that shows which clients I need to chase for details. Next to this button I want to indicate how many clients need to be chased, So I know if I need to even look at the form.

I made a box with the info below. dbo_Chase_Clients is a View which shows in access as a table I presume this is how views come accross.
When I view the switchboard with this code it returns error. If I click the button that goes to the form with this there is information there. So there must be somthing wrong with the below?

=Count([dbo_Chase_Clients]![ID])
   

- Advertisement -