Upgrade Access to run IF Statements, for Free?
Can I get a free upgrade for my Micrsoft Access to run IF statements? IF not for free, what should I use?
Ken Jones
Last Activity: Nov 28 '10, 06:54 AM
Joined: Sep 16 '10
Location:
-
How does the replace function work?
In addition to xxxxxx_po and xxx_fr I have other names in the list like xxxxxxxx without the extension. Would the replace function work better since what you sent me would remove the last 3 characters whether the extensions (ie)_po, _fr, existed or not. Of course I would not want to delete the last 3 characters unless the _xx actually existed.Leave a comment:
-
How do you strip off trailing characters using Microsoft Access
With 2 separate character strings of
100038_ko and 244p_po how do I strip off the _ko and _po from the respective strings? -
Understanding Microsoft Access String Queries
I really appreciate the help you guys have been giving me! What would be really helpful now is if you could recommend a really good Microsoft Access Query Reference Manual that would explain to me the string queries you guys have shared with me! I am really looking for the best reference manual out there. I noticed an Access Reference Manual that was actually published by Microsoft in 2003 that had a picture of a key on the front. Amazon had it on... -
Thanks guys, your are the greatest!!!!!!! !
You have solved all my problems for me! (At least my programming problems)Leave a comment:
-
Could you Give Me the Query with the delimiters?
Thanks for your prompt reply. I didn't phrase my question very well! I also have a term labeled AreaSupport that I did not include in my original problem that does not work with your response. If you could give me the query to delimit the value with the underscore preceding and the period following , I would really appreciate it!Leave a comment:
-
Ken Jones started a topic I need a substring query that will return certain values from a character stringin AccessI need a substring query that will return certain values from a character string
Table URL_3 consist of the following 2 columns of information being Record No and URL
I need a substring query that will return the values of Local and Area from column URL of Table URL_3 into an additional column of information.Code:No URL 1 http:/publishing/45/100006_f.SAL_Local.html 2 http:/publishing/45/100006_f.SAL_Area.html
I was looking for the solution, shown below, that... -
I wish it were as simple as using the crosstab wizard!
The crosstab wizard generates 4 columns of URL information, because each of the abbreviated 4 URL's are variables that has a common element being User1 or User2 buried within it. I was hoping to generate a column of URL information for User1 and a column of URL information for User2 which would be the specified column headings. The crossab wizard does not allow this.Leave a comment:
-
How do I convert column data into row data using microsoft access?
Can this conversion be done using Microsoft Access?
If so how? Could this be done using TRANSFORM and PIVOT SQL statements?
The Old Format columns are NO and URL
The New Format Columns are No, User1URL and User2URL
Old Format
NO URL
16 http:/16_User1.html
16 http:/16_User2.html...
No activity results to display
Leave a comment: