Processing Functions in a Table

T

tonyrusin

Hi,

I'm running Access 2003. I have a table that contains the following
information:

Item Count
--- ---
Postings =DCount("*","tblDocBoat","[ToPost]=True")
Floating Copies =DCount("*","tblFloatingCopy","[Approved] = False")
Releases =DCount("*","tblReleaseReq","[Processed] =
False")

Is there a way when I can get the functions to process, rather than
showing the code, when viewing the table through a form or simply
viewing the table? i.e:

Item Count
--- ---
Postings 23
Floating Copies 11
Releases 18

Thanks in advance for any help.

- Tony
 
J

Jeff Boyce

Check out the Eval() function, using something like:

Me!txtYourPostingsTextControl = Eval(>>a reference to the 'value' in
that column<<)

You might need to create a recordset and refer to the field.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
J

John W. Vinson

Hi,

I'm running Access 2003. I have a table that contains the following
information:

Item Count
--- ---
Postings =DCount("*","tblDocBoat","[ToPost]=True")
Floating Copies =DCount("*","tblFloatingCopy","[Approved] = False")
Releases =DCount("*","tblReleaseReq","[Processed] =
False")

Is there a way when I can get the functions to process, rather than
showing the code, when viewing the table through a form or simply
viewing the table? i.e:

Item Count
--- ---
Postings 23
Floating Copies 11
Releases 18

Thanks in advance for any help.

- Tony
Click to expand...

Stop.

Tables ARE NOT SPREADSHEETS. They are repositories for data (not for
expressions), and should be used *as* repositories for data - not for viewing
or for calculating.

Create a Form with three textboxes; it can be based on the table, with the
textboxes independent of the. But... do you really want the total count of
records in these three tables, without reference to any other field (such as
some field in the form on which you're displaying this)?

John W. Vinson [MVP]
 
Top