User Profile

artemetis · Jul 17 '14, 01:09 PM

Thank you!
I've added this to access query; first it kicks back Enter Parameter Value "LenFN" box. I leave it blank and it displays uid and pFirstName. pLastName and pCoded display #Error using this code

Code:

SELECT qM.[UID], Left([Person_Info],[Space1]-1) AS pFirstName, Mid([Person_Info],[Space1]+1,IIf([Space2]=0,Len([Person_Info]),[Space2]-1)-[Space1]) AS pLastName, IIf([Space2]=0,Null,Replace(Mid([Person_Info],[Space2]+2,99),')',''))

...

artemetis · Jul 16 '14, 11:03 PM

Thanks for the reply. I'm not using an asterisk in the field name; that was just for show that additional information for this field. like "See below"

Neo is right with split function, I am just not so sure on how to use this.

There is a first space from left, after first name. There is last name after this, then space before parentheses on some records.

artemetis · Jul 16 '14, 01:43 AM

Thanks, NeoPa.

I'm looking to get the following. Ihope this next information helps.

Easiest is to just display the following in a query.

Each record looks like this from tblMaster: uid, person_info (uid not shown in results)

arthur smith (18_7)
josephy and (87_3)
patrick murphy (8_e3/2)
ed sully
mark vignion
mark jalus (7_3_0)

I would like that data from...

artemetis · Jul 14 '14, 11:06 PM

Thanks for the reply, folks. Exactly, Neo...perfect illustration. I'm just a dabbler and don't get to use these programmings function as often as I would like, but I am sorry for not being more clear.

the original table has the fields:
uid, person_info

uid is autonumber and person_info is "firstname lastname (misc)", a horrible piece of data.

I would like to run a make table query to dump these...

artemetis · Jul 25 '12, 02:12 PM

Thanks, Twinnyfo!
That did it!!!

artemetis · Jul 23 '12, 01:10 PM

My main report is bound to tblMain.
This tbl has empFirstName, empLastName, empGender

I have two text boxes in the header:
txtMaleCount and txtFemaleCount

I've tried several ways to get the counts into each text box, with no success. Zmbd's last respone^^^, second paragraph, is what I'm trying to do.

Thanks, in advance.

artemetis · Jul 19 '12, 01:03 PM

Thanks folks.

ZMBD - I'm adding this to an existin report, which contains sub-reports.

Funny thing, when creating a "New Report" when using the SQL as a datasource, I'm able to get a report showing
F - 32
M - 40

As soon as I add a subform, the subform gets displayed twice with a genderCount as a header.

(feel free to split this thread as necessary)

artemetis · Jul 18 '12, 12:41 PM

I have tried the aggregate query.

This query gives me the correct counts, but not sure how to call the count number in the report field:

Code:

SELECT tblMain.Gender, Count(tblMain.Gender) AS CountOfGender
FROM tblMain
GROUP BY tblMain.Gender;

The report has a txtMale & txtFemale box.

Thanks!

artemetis · Nov 1 '11, 09:43 PM

Looks like it will work, but getting a continual yes/no button at line

Code:

DoCmd.RunSQL "INSERT INTO tblIPAddresses(fldIPAddress) VALUES ('" & arr(iCount) & "');"

artemetis · Oct 12 '11, 04:14 PM

AWESOME!

Worked like a charm!!
Thanks, Rabbit!~

artemetis · Apr 6 '11, 02:58 PM

Thank you Mariostg!
Is there a way to use this in my qry or must I use a form?

Thank youa again

artemetis · Apr 6 '11, 02:38 PM

firstName: jack
lastName: jones / group1
username: jjones /

desired username: jjones

I'm trying to have my qry return "jjones".
In the instance where the lastName is less than eight characters, it is including the first blank space and the backslash.

artemetis · Mar 20 '11, 11:02 AM

Yes, please. I do need help with this. Thank you jhardman.

artemetis · Feb 21 '11, 04:11 PM

Thanks for the reply Jared.

I think that the first code is what I am looking to do, but it doesn't seem to be working.

When I run that code from a hyperlink on my page, it returns a blank page with the following url:

Code:

http://www.natetesting.com/Nate_Lookup_Results.asp?NATEID=7584962

Am I missing something?

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Data Breakout in Access SQL

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Getting total counts of types in column, for example gender

Leave a comment:

Extract string into column data

Leave a comment:

How do I Find Count of Matching Items

Leave a comment:

Leave a comment:

Creating a username field

Leave a comment:

Leave a comment:

Passing value from external site to ASP form?