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

Add strings to Each record in Access

As you can see that “Filter” query counts the repetition of each string.
What I want to do is to create another table with this query and do some access vba that changes the string in each record of the newly created table like this:

Filter
name      count
a                2
bb                2
ccc                 4
d                3

Now...........

A
bb
ccc

Becomes….

http://A.apsx
http://bb.apsx
http://ccc.apsx


So in essence, I am actually appending [http://] in the beginning and [.aspx] at the end of each record in a newly created table, along with the count column.
How that can be done in access vba? Please assist.

thank you
Rayne
0
Rayne
Asked:
Rayne
  • 3
  • 2
2 Solutions
 
RayneAuthor Commented:
I am attaching the sample access
Test.accdb
0
 
peter57rCommented:
You just use a make table query..

SELECT [Name], "http://" & [Name] & ".apsx" INTO Newtable  FROM filter;


are you sure it's apsx and not aspx
0
 
hnasrCommented:
Make table query!
check attached database query1.
Design modified!

SELECT qlFilter.aname, "http://" & [aname] & ".apsx" AS lnk INTO Table2
FROM qlFilter;

Test-2.accdb
0
Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

 
RayneAuthor Commented:
Hello peter57r,

I remember you helped me a year ago in EE !! I rocked that summer internship because of EE and superfast experts like you :)
hehehe, yes thats aspx and not the other version that i mentioned  :]

hnasr, thanks for helping here too


Rayne
0
 
RayneAuthor Commented:
Awesome help always
0
 
hnasrCommented:
Welcome!
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

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