Solved

Add strings to Each record in Access

Posted on 2011-09-18
6
324 Views
Last Modified: 2012-05-12
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
Comment
Question by:Rayne
  • 3
  • 2
6 Comments
 

Author Comment

by:Rayne
ID: 36555668
I am attaching the sample access
Test.accdb
0
 
LVL 77

Accepted Solution

by:
peter57r earned 400 total points
ID: 36555712
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
 
LVL 30

Assisted Solution

by:hnasr
hnasr earned 100 total points
ID: 36556662
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
Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

 

Author Comment

by:Rayne
ID: 36556863
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
 

Author Closing Comment

by:Rayne
ID: 36556869
Awesome help always
0
 
LVL 30

Expert Comment

by:hnasr
ID: 36557209
Welcome!
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question