Search results

using SELECT SplitReturn(patientname, " ", 0) As [Last Name], SplitReturn(patientname, " ", 1) As [First Name] FROM Table1 works Great.. even tried it with a person with 5 names1:):):):):):)

tried the Public Function SplitReturn(ByVal str As String, _ ByVal delimiter As String, _ ByVal index As Integer) As String SplitReturn = Split(str, delimiter)(index) End...

one time deal

shorted word length return 2

error in the code 'undefined function Shortestword length in express. Just need the query to ignore anything in the third, fourth, etc in the field, this will be the case 90% of the time. So all middle names, Jr, etc. would be returned,,

This will be used in a query. Understood this will not work in all cases, ie. some people have 5 or 6 names, but should work 90%+ of the time. Some examples are Flintstone Fred M. Flintstone Wilma Marie Flintstone Babmab Jr Flintstone Fred Barney Jr

I'm rusty and could use help, I have table where First Name, Last Name and Initial are all in one field. What is the syntax to remove initial? Been playing with Right and Len with no success, I'm sure this has been done before.

Thanks, I tried this to and couldn't get the Q to show, seems like the "\ has something to do with it?

Need to automate the process of pulling data from a db, but unsure of how to proceed, instead of the typical enter a date or enter a date range, i need to enter up to 7 dates to exclude from a data pull. I understand how to do it in a paramter query, how would this been done on a form? Most...

I'm stuck, i have a rather long iff statement and i can get part of it to work with only two conditions: I understand the logic of it iif(test,True,False) what i need is the iff statement to check a [statefield] for 10 possible matching states, ie. WhatToDo: IIf([statefield]="AL" Or...

Also tried SELECT tbltypesCardio.idcardiotype, tbltypesCardio.cardiotype, tbltypesCardio.idcardiotype FROM tbltypesCardio GROUP BY tbltypesCardio.cardiotype, tbltypesCardio.idcardiotype, tbltypesCardio.idcardiotype;

TRANSFORM Count(Nz([idcardiotype],0)) AS Expr1 SELECT Query1.idcardiotype FROM Query1 GROUP BY Query1.idcardiotype, [idcardiotype]+Nz([idcardiotype]) PIVOT Query1.cardiotype;

no there is no select query, just a crosstab, so there's: Row Heading a Column Heading and the expression which is count, which works fine on the idcardiotype but i can't seem to use the nz command correctly. Are you saying it doesnt work in crosstabs?

[idcardiotype]+Nz([idcardiotype]) and Expr1: Count(Nz([idcardiotype],0))

I thought I've done this before, searched Nz w/no luck, any who, i have a cross tab query which works correctly, but I want it to return 0 instead of blanks, this is my syntax in a query: expr1: idcardiotype count value

I have member data in table a from two months ago and member data in another table from one month ago. I need to compare the two so i know whom the new ones are, what is the best approach? there are other things i have to constrain on, but that isn't the issue

its unbound, why would that make a difference

I have a combobox on a form that looks up info, which works fine, but if the user hits tab, instead of going to the next field the information disappears from the combobox...thinking if i put some code in OnLostFocus and move it to the next field that would fix my problem,....does this sound...

I have BOUND 5 combobox that does a lookup and it works great (it pulls up customer address), problem i just discovered that if the user need to update an address (typo), this can't be done. This makes sense since it's bound. Anyone have any ideas as to a work around? would greatly appreciate it

I've always place a small rectangle box over the arrow part and made it Transparent