• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 242
  • Last Modified:

Updating Record Count to Another Table plus add text

Access 2003

INSERT INTO RecordCount_Before ( TableNamesCount )
SELECT Count(tblXrefInfo.Item) AS CountOfItem
FROM tblXrefInfo;
In the field "TableNamesCount"   I need the "Table Name"  from the other table added to the update.

So the updated field would be :
tblXrefInfo.Item count is 660234

instead of just 660234

Thanks
fordraiders
0
Fordraiders
Asked:
Fordraiders
1 Solution
 
Rey Obrero (Capricorn1)Commented:
try


INSERT INTO RecordCount_Before ( TableNamesCount )
SELECT "tblXrefInfo.Item count is " & Count(tblXrefInfo.Item) AS CountOfItem
FROM tblXrefInfo;
0
 
FordraidersAuthor Commented:
tHANKS !
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now