String Too Long in Query

I have a complicated calculated field in a query, and the builder keeps 
truncating my expression. Is there any way around this limitation?  If 
necessary, I can post the calculation - but the basics are a switch by the 
value of class, then a switch by value of position to get the correct payout 
for a car race. (so each class has the switch for position)

Any help would be GREATLY appreciated!

Meg
0
Utf
2/11/2008 1:17:00 PM
access.queries 6343 articles. 1 followers. Follow

6 Replies
1391 Views

Similar Articles

[PageSpeed] 3

On Mon, 11 Feb 2008 05:17:00 -0800, Meg
<Meg@discussions.microsoft.com> wrote:

>I have a complicated calculated field in a query, and the builder keeps 
>truncating my expression. Is there any way around this limitation?  If 
>necessary, I can post the calculation - but the basics are a switch by the 
>value of class, then a switch by value of position to get the correct payout 
>for a car race. (so each class has the switch for position)
>
>Any help would be GREATLY appreciated!
>
>Meg

When a calculation is too complex, either for Access or my brain, it
is helpful to put it into a VBA function in a module instead.  This
way, you can structure the code (with indentation, intermediate
variables, etc.)

Then call the function from your query with the appropriate fields as
parameters.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 
0
Armen
2/11/2008 3:20:57 PM
post the SQL

-Dorian

"Meg" wrote:

> I have a complicated calculated field in a query, and the builder keeps 
> truncating my expression. Is there any way around this limitation?  If 
> necessary, I can post the calculation - but the basics are a switch by the 
> value of class, then a switch by value of position to get the correct payout 
> for a car race. (so each class has the switch for position)
> 
> Any help would be GREATLY appreciated!
> 
> Meg
0
Utf
2/11/2008 3:21:03 PM

"Armen Stein" wrote:

> On Mon, 11 Feb 2008 05:17:00 -0800, Meg
> <Meg@discussions.microsoft.com> wrote:
> 
> >I have a complicated calculated field in a query, and the builder keeps 
> >truncating my expression. Is there any way around this limitation?  If 
> >necessary, I can post the calculation - but the basics are a switch by the 
> >value of class, then a switch by value of position to get the correct payout 
> >for a car race. (so each class has the switch for position)
> >
> >Any help would be GREATLY appreciated!
> >
> >Meg
> 
> When a calculation is too complex, either for Access or my brain, it
> is helpful to put it into a VBA function in a module instead.  This
> way, you can structure the code (with indentation, intermediate
> variables, etc.)
> 
> Then call the function from your query with the appropriate fields as
> parameters.
> 
> Armen Stein
> Microsoft Access MVP
> www.JStreetTech.com
>  
> 

Not a bad idea, but I have no clue how to call a vba function for each row 
for one variable (that doesn't exist in the database). Since it is a 
calculation, I didn't want to have to store it. But figured I could just 
calculate it in the query at run-time. 

Is there somewhere you can point me to to learn how to do that 
programmatically with VBA?

It would also be much appreciated.

Meg
0
Utf
2/11/2008 7:38:05 PM
I am not sure it is SQL, but here is what is in the column in the query:

payout:Val(Switch([class]="ITR",IIf(([position]=[qryracesummary]![itrcount]),0,Switch([position]=1,(.22*[qryracesummary]![itrpurse]),[position]=2,(.16*[qryracesummary]![itrpurse]),[position]=3,(.13*[qryracesummary]![itrpurse]),[position]=4,(.10*[qryracesummary]![itrpurse]),[position]=5,(.09*[qryracesummary]![itrpurse]),[position]=6,(.08*[qryracesummary]![itrpurse]),[position]=7,(.07*[qryracesummary]![itrpurse]),[position]=8,(.06*[qryracesummary]![itrpurse]),[position]=9,(.05*[qryracesummary]![itrpurse]),[position]=10,(.04*[qryracesummary]![itrpurse])),[class]="ITS",IIf(([position]=[qryracesummary]![itscount]),0,Switch([position]=1,(.22*[qryracesummary]![itspurse]),[position]=2,(.16*[qryracesummary]![itspurse]),[position]=3,(.13*[qryracesummary]![itspurse]),[position]=4,(.10*[qryracesummary]![itspurse]),[position]=5,(.09*[qryracesummary]![itspurse]),[position]=6,(.08*[qryracesummary]![itspurse]),[position]=7,(.07*[qryracesummary]![itspurse]),[position]=8,(.06*[qryracesummary]![itspurse]),[position]=9,(.05*[qryracesummary]![itspurse]),[position]=10,(.04*[qryracesummary]![itspurse])),[class]="ITA",IIf(([position]=[qryracesummary]![itacount]),0,Switch([position]=1,(.22*[qryracesummary]![itapurse]),[position]=2,(.16*[qryracesummary]![itapurse]),[position]=3,(.13*[qryracesummary]![itapurse]),[position]=4,(.10*[qryracesummary]![itapurse]),[position]=5,(.09*[qryracesummary]![itapurse]),[position]=6,(.08*[qryracesummary]![itapurse]),[position]=7,(.07*[qryracesummary]![itapurse]),[position]=8,(.06*[qryracesummary]![itapurse]),[position]=9,(.05*[qryracesummary]![itapurse]),[position]=10,(.04*[qryracesummary]![itapurse])),[class]="ITB",IIf(([position]=[qryracesummary]![itbcount]),0,Switch([position]=1,(.22*[qryracesummary]![itbpurse]),[position]=2,(.16*[qryracesummary]![itbpurse]),[position]=3,(.13*[qryracesummary]![itbpurse]),[position]=4,(.10*[qryracesummary]![itbpurse]),[position]=5,(.09*[qryracesummary]![itbpurse]),[position]=6,(.08*[qryracesummary]![itbpurse]),[position]=7,(.07*[qryracesummary]![itbpurse]),[position]=8,(.06*[qryracesummary]![itbpurse]),[position]=9,(.05*[qryracesummary]![itbpurse]),[position]=10,(.04*[qryracesummary]![itbpurse])),[class]="ITC",IIf(([position]=[qryracesummary]![itccount]),0,Switch([position]=1,(.22*[qryracesummary]![itcpurse]),[position]=2,(.16*[qryracesummary]![itcpurse]),[position]=3,(.13*[qryracesummary]![itcpurse]),[position]=4,(.10*[qryracesummary]![itcpurse]),[position]=5,(.09*[qryracesummary]![itcpurse]),[position]=6,(.08*[qryracesummary]![itcpurse]),[position]=7,(.07*[qryracesummary]![itcpurse]),[position]=8,(.06*[qryracesummary]![itcpurse]),[position]=9,(.05*[qryracesummary]![itcpurse]),[position]=10,(.04*[qryracesummary]![itcpurse])),[class]="SM",IIf(([position]=[qryracesummary]![smcount]),0,Switch([position]=1,(.22*[qryracesummary]![smpurse]),[position]=2,(.16*[qryracesummary]![smpurse]),[position]=3,(.13*[qryracesummary]![smpurse]),[position]=4,(.10*[qryracesummary]![smpurse]),[position]=5,(.09*[qryracesummary]![smpurse]),[position]=6,(.08*[qryracesummary]![smpurse]),[position]=7,(.07*[qryracesummary]![smpurse]),[position]=8,(.06*[qryracesummary]![smpurse]),[position]=9,(.05*[qryracesummary]![smpurse]),[position]=10,(.04*[qryracesummary]![smpurse]))))

I definitely had it htmlkit, with returns and indenting to figure it out, 
but bunched all back together thinking maybe the returns caused the error.

Meg

"mscertified" wrote:

> post the SQL
> 
> -Dorian
> 
> "Meg" wrote:
> 
> > I have a complicated calculated field in a query, and the builder keeps 
> > truncating my expression. Is there any way around this limitation?  If 
> > necessary, I can post the calculation - but the basics are a switch by the 
> > value of class, then a switch by value of position to get the correct payout 
> > for a car race. (so each class has the switch for position)
> > 
> > Any help would be GREATLY appreciated!
> > 
> > Meg
0
Utf
2/11/2008 7:41:01 PM

"Meg" wrote:

> 
> 
> "Armen Stein" wrote:
> 
> > On Mon, 11 Feb 2008 05:17:00 -0800, Meg
> > <Meg@discussions.microsoft.com> wrote:
> > 
> > >I have a complicated calculated field in a query, and the builder keeps 
> > >truncating my expression. Is there any way around this limitation?  If 
> > >necessary, I can post the calculation - but the basics are a switch by the 
> > >value of class, then a switch by value of position to get the correct payout 
> > >for a car race. (so each class has the switch for position)
> > >
> > >Any help would be GREATLY appreciated!
> > >
> > >Meg
> > 
> > When a calculation is too complex, either for Access or my brain, it
> > is helpful to put it into a VBA function in a module instead.  This
> > way, you can structure the code (with indentation, intermediate
> > variables, etc.)
> > 
> > Then call the function from your query with the appropriate fields as
> > parameters.
> > 
> > Armen Stein
> > Microsoft Access MVP
> > www.JStreetTech.com
> >  
> > 
> 
> Not a bad idea, but I have no clue how to call a vba function for each row 
> for one variable (that doesn't exist in the database). Since it is a 
> calculation, I didn't want to have to store it. But figured I could just 
> calculate it in the query at run-time. 
> 
> Is there somewhere you can point me to to learn how to do that 
> programmatically with VBA?
> 
> It would also be much appreciated.
> 
> Meg

I did not see any way to edit, so another part of the question would be will 
it have access to the fields that are available to the query? Is the naming 
the same? (for example races!itrpurse  or results!position?

Thanks for all the help!
0
Utf
2/11/2008 8:09:01 PM
Well that is just about impossible to follow.  If you were going to put it 
into a function you could use something like the following
UNTESTED function.  If this is written correctly you should be able to make 
modifications as needed fairly easily.  AND if you needed to perform the 
calculation for more than one place you wouldn't have to worry about 
modifying it everywhere you were using it.

Public Function FGetValue (sClass, iPosition, _
          itrCount, itrPurse, _
          itsCount, itsPurse, _
          itaCount, itaPurse, _
          itbCount, itbPurse, _
          itcCount, itcPurse, _
          smCount, smPurse)

Dim LCount as Long
Dim dPurse as Double

Select Case sClass
   Case "ITR"
      Lcount = ItrCount
      dPurse = ltrPurse
   Case "ITS"
      LCount = itsCount
      dPurse = itsPurse
   Case "ITA"
     Lcount = itaCount
     DPurse = itaPurs
  ...
End Select

IF lPosition = LCount then
   fGetValue = 0
Else
  Select Case LPosition
     Case 1
         fGetValue = .22 * DPurse
     Case 2
         fGetValue = .16* DPurse
      Case 3
     ...
   End Select
End IF

End Function

In the query you could call that with

 FGetValue([Class],[Position],[itrCount],[itrPurse], itsCount, itsPurse, 
itaCount, itaPurse, itbCount, itbPurse, itcCount,itcPurse, smCount, smPurse)
-- 
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"Meg" <Meg@discussions.microsoft.com> wrote in message 
news:4F7DC42C-8F97-48E0-BE7C-1C15DFBE8437@microsoft.com...
>I am not sure it is SQL, but here is what is in the column in the query:
>
> payout:Val(Switch([class]="ITR",IIf(([position]=[qryracesummary]![itrcount]),0,Switch([position]=1,(.22*[qryracesummary]![itrpurse]),[position]=2,(.16*[qryracesummary]![itrpurse]),[position]=3,(.13*[qryracesummary]![itrpurse]),[position]=4,(.10*[qryracesummary]![itrpurse]),[position]=5,(.09*[qryracesummary]![itrpurse]),[position]=6,(.08*[qryracesummary]![itrpurse]),[position]=7,(.07*[qryracesummary]![itrpurse]),[position]=8,(.06*[qryracesummary]![itrpurse]),[position]=9,(.05*[qryracesummary]![itrpurse]),[position]=10,(.04*[qryracesummary]![itrpurse])),[class]="ITS",IIf(([position]=[qryracesummary]![itscount]),0,Switch([position]=1,(.22*[qryracesummary]![itspurse]),[position]=2,(.16*[qryracesummary]![itspurse]),[position]=3,(.13*[qryracesummary]![itspurse]),[position]=4,(.10*[qryracesummary]![itspurse]),[position]=5,(.09*[qryracesummary]![itspurse]),[position]=6,(.08*[qryracesummary]![itspurse]),[position]=7,(.07*[qryracesummary]![itspurse]),[position]=8,(.06*[qryracesummary]![itspurse]),[position]=9,(.05*[qryracesummary]![itspurse]),[position]=10,(.04*[qryracesummary]![itspurse])),[class]="ITA",IIf(([position]=[qryracesummary]![itacount]),0,Switch([position]=1,(.22*[qryracesummary]![itapurse]),[position]=2,(.16*[qryracesummary]![itapurse]),[position]=3,(.13*[qryracesummary]![itapurse]),[position]=4,(.10*[qryracesummary]![itapurse]),[position]=5,(.09*[qryracesummary]![itapurse]),[position]=6,(.08*[qryracesummary]![itapurse]),[position]=7,(.07*[qryracesummary]![itapurse]),[position]=8,(.06*[qryracesummary]![itapurse]),[position]=9,(.05*[qryracesummary]![itapurse]),[position]=10,(.04*[qryracesummary]![itapurse])),[class]="ITB",IIf(([position]=[qryracesummary]![itbcount]),0,Switch([position]=1,(.22*[qryracesummary]![itbpurse]),[position]=2,(.16*[qryracesummary]![itbpurse]),[position]=3,(.13*[qryracesummary]![itbpurse]),[position]=4,(.10*[qryracesummary]![itbpurse]),[position]=5,(.09*[qryracesummary]![itbpurse]),[position]=6,(.08*[qryracesummary]![itbpurse]),[position]=7,(.07*[qryracesummary]![itbpurse]),[position]=8,(.06*[qryracesummary]![itbpurse]),[position]=9,(.05*[qryracesummary]![itbpurse]),[position]=10,(.04*[qryracesummary]![itbpurse])),[class]="ITC",IIf(([position]=[qryracesummary]![itccount]),0,Switch([position]=1,(.22*[qryracesummary]![itcpurse]),[position]=2,(.16*[qryracesummary]![itcpurse]),[position]=3,(.13*[qryracesummary]![itcpurse]),[position]=4,(.10*[qryracesummary]![itcpurse]),[position]=5,(.09*[qryracesummary]![itcpurse]),[position]=6,(.08*[qryracesummary]![itcpurse]),[position]=7,(.07*[qryracesummary]![itcpurse]),[position]=8,(.06*[qryracesummary]![itcpurse]),[position]=9,(.05*[qryracesummary]![itcpurse]),[position]=10,(.04*[qryracesummary]![itcpurse])),[class]="SM",IIf(([position]=[qryracesummary]![smcount]),0,Switch([position]=1,(.22*[qryracesummary]![smpurse]),[position]=2,(.16*[qryracesummary]![smpurse]),[position]=3,(.13*[qryracesummary]![smpurse]),[position]=4,(.10*[qryracesummary]![smpurse]),[position]=5,(.09*[qryracesummary]![smpurse]),[position]=6,(.08*[qryracesummary]![smpurse]),[position]=7,(.07*[qryracesummary]![smpurse]),[position]=8,(.06*[qryracesummary]![smpurse]),[position]=9,(.05*[qryracesummary]![smpurse]),[position]=10,(.04*[qryracesummary]![smpurse]))))
>
> I definitely had it htmlkit, with returns and indenting to figure it out,
> but bunched all back together thinking maybe the returns caused the error.
>
> Meg
>
> "mscertified" wrote:
>
>> post the SQL
>>
>> -Dorian
>>
>> "Meg" wrote:
>>
>> > I have a complicated calculated field in a query, and the builder keeps
>> > truncating my expression. Is there any way around this limitation?  If
>> > necessary, I can post the calculation - but the basics are a switch by 
>> > the
>> > value of class, then a switch by value of position to get the correct 
>> > payout
>> > for a car race. (so each class has the switch for position)
>> >
>> > Any help would be GREATLY appreciated!
>> >
>> > Meg 


0
John
2/11/2008 8:32:58 PM
Reply:

Similar Artilces:

Search a string in all worksheets ?
I am searching for a string say ABC in all worksheets in Excel 97. However, it seems that it only allows me to search it in the current worksheet. Is there any suggestion ? Hi Peter............ In XL2k, I just highlighted all three sheets using Right-click on one tab and choosing Select all sheets..........then did Edit > Find > and typed my search string in the window and hit "Find next" repeatedly and it cycled through all three sheets finding the string...........is that what you're wanting to do? Vaya con Dios, Chuck, CABGx3 "Peter" <anonymous@di...

Multiple word search Parameter Query
Hello. I am having trouble creating a parameter query that will allow me to search a field for mulitple words. I have a field called "Desciption" and I would like to type Password Reset in the parameter pop-up and have it pull up all records that have "Password Reset" somewhere in the Description field. Currently I have: =[Enter Task Keyword] & [Enter Task Keyword] How should I re-write this query? Your help is greatly appreciated. Iram/mcp Hi, Try something in the query like: Alike "%" & [Enter Task Keyword] &"%" "Iram...

XmlTextReader to a xml string
I want to use FOR XML in my query so I'm going to use the ExecuteXmlReader method? The trouble I'm having now is streaming the results to a string for output as an XML document. Also, since the XML that comes from teh query is not a complete document it's a fragment without a root element. So, any ideas about how to get his into a string? --Buddy Buddy Ackerman wrote: > I want to use FOR XML in my query so I'm going to use the ExecuteXmlReader > method? The trouble I'm having now is streaming the results to a string for > output as an XML document. Also, ...

Any alternative to Microsoft Query?
I am trying to access an Oracle database through Excel. However, Microsoft Query (which Excel uses) crashes before I can do anything (Error:"String data, right truncated"). Creating a connection through MS Access works completly fine. Creating a connection (i.e. no query, just connection) in Excel works fine as well but is useless as I cannot perform any SQL queries on the database. All in all, everything except Microsoft Query manages to access the database. The question is then: are there any other ways (i.e. not through Microsoft Query) of running SQL queries on the database? ...

How can you copy selected cells when one cell contains a specified string?
Hi! I need to paste selected cells into different worksheets. The cells contain information like: date, amount, category eg: 24/08/04, 590, eggs 25/08/04, 430, cheese what I wanna do is copy date and amounts to eggs worksheet or cheese worksheet, depending on whether category is eggs or cheese. Is there a way to combine the IF function with a paste link, or something like that? Thanks a bundle in advance! Jon. Formulas return a value to the cells in which they reside. They cannot perform actions, such as copy,paste ect. what you want is possible but you didn't not provide enou...

Querying data tables
I routinely query data from another application into Excel. Is there any way to pass parameters into the query from the excel worksheet? That is, I want to put a start date and end date in the excel worksheet and then query for records dated within that range. I can edit the query easily enough, but I want to turn this over to users who would not understand how to use query and I don't want to spend a lot of time teaching repeatedly and mopping up their messes. ...

How do I write a string in the destination element depending on what the string is in the source, using XSLT/XPath? (Like a switch statement.)
Is there something like a switch statement in XPath? What I want to do is this: In the source there is an element called "member" with either the value "0" or "1". In the destination element (also called "member") the value should be "No" or "Yes" (Where "0" corresponds to "No" and "1" to "Yes"). How do I do this? Joakim Olesen wrote: > Is there something like a switch statement in XPath? What I want to do is > this: > > In the source there is an element called "member&quo...

How to find a text in a string without giving the position of the
My requirement are I want to find a particular text in a string with out giving the position of the text . I believe that if we use find and search we have to give the text position for the particular text. Can anyone guide me what should be the function used for getting this. Post example(s) -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett@gmail.com "Sreekanth" <Sreekanth@discussions.microsoft.com> wrote in message news:B2ABF7FC-5745-4863-AA05-4EC1D61C825E@microsoft.com... > My requirement are > I want to find a particular text in...

Operation must use an Updatable Query
I have read the posts regarding trying to do an update linking to Excel files and how it is now illegal. Fine. I am not touching Excel in anyway. I am linking via OBDC to a file I create in our AS-400. I read and do some counting and summing matching to a local collectionstbl and local Staff table. Then pass the results to another query to do an update to a reporting table that is local. I still get the above error when I try to run the 2nd update query to a local table. Ideas are welcome! Here is the code for the 1st query reading the AS-400 file. PARAMETERS [Begin Date:...

charts with data from more than one query
Is it possible to create a chart from data from more than one query or table? I have figures for 3 years (in 3 seperate queries) and want to produce a chart that displays averages for each month across all 3 years- e.g average for jan, 2005, 2006 and 2007, feb 2005,2006 and 2007 etc. I've tried by producing a new query to join the average columns for all 3 tables togeather, however am unable to do this as when i try to add a date column, Access automatically formats the date to 2007 and so the query does not display the averages for 2005 or 2006. Anyone know how I can get round thi...

Force a Query to Insert "Placeholders" (?)
Access 2002 tbl_Main Contains a date field. There are 100s of records in this table tbl_Sub contains a one-to-many link field for tbl_Main, and a field for colors. There are 3 records in this table. I wish to build a query that will show a row for each tbl_Main record, and also a row for each of the colors that are not linked to that record, showing the nulls, and puting the colors in a certain sort order, whether a tbl_Main record has a related record in tbl_Sub or not. Sort of a place-holding record-set. Like this: tbl_MainId.cDate tbl_Sub.Color 1/1/2001 Blue red (not really ther...

Outlook 2002 takes so long to open
Outlook takes too long to open. I am using OfficeXP Standard.Any suggestions? Try disabling the integration with Instant Messenger in Tools | Options | Other and see if that speeds things up. -- Jocelyn Fiorello MVP - Outlook *** Messages sent to my e-mail address will NOT be answered -- please reply only to the newsgroup to preserve the message thread. *** In news:0c2501c3b9f5$3e55ead0$a001280a@phx.gbl, Delsa wrote: > Outlook takes too long to open. I am using OfficeXP > Standard.Any suggestions? ...

Stringing formulas again
Hey there Roger, once again this formula thing is driving me crazy...I can visualize what I want to do but can't work out the formula...This is how I see it in my mind =IF(AI13,AW13,BI13,BW13,CJ13="N","",IF(AI13,AW13,BI13,BW13,CJ13="R","",SUM(AI13+AW13+BI13+BW13+CJ13/100)))) What do you think? Cheers David Perhaps this will help........... =IF(OR(AI13="N",AW13="N",BI13="N",BW13="N",CJ13="N",AI13="R",AW13="R",BI13="R",BW13="R",CJ13="R"),""...

Copy form and queries
I have two mdb's open and I am trying to click and drag (copy) some forms and queries to another mdb. I get the message "The database has been placed in a state by user 'Admin" on machine 'XXXX' that prevents it from being opened or locked. How do I get around this? Thanks -- Shell Shell - You can import the forms and queries into the second database, under the 'Get external data' items. -- Daryl S "Shell" wrote: > I have two mdb's open and I am trying to click and drag (copy) some forms and > queries...

a tricky selection query
I need to select the latest of several duplicate entries. An output from an education database has left me with a table of grades for different subjects, entered at different times. Simplifying it a bit the table would look like this. STUDENT_NAME, SUBJECT, DATE_OF_GRADE, GRADE jim maths 1st Jan 2007 B sally English 6 feb 2007 C jim maths 10 March 2007 A jenny French 5th July 2007 D sally English 3rd July 2007 E jim maths 5th feb 2007 F I just want the latest grade for each student and...

Query by Form Problem 06-19-07
I'm using QBF with about six different combo boxes using: [forms]! [formmain]! [combo1] or [forms]![formmain1]![combo1] -like in a VBA book. This is so users can select criteria on a form with the combo boxes, and when they are done, they hit the search button, and it opens up another form based on the query just performed by the combo selection. This worked for about three combo boxes, but when I added another one, it freezes up and opens up a blank page. It's supposed to open the new form based on the query. Is there a better way to do this? I've looked exhaustive...

Linking Question (long, sorry!)
Hello. I am a teacher hoping to use an Excel spreadsheet to convert between my pen & paper gradebook and our temperamental computerized gradekeeper. The problem is in the order of the student's names. In my regular (paper) gradebook, students are listed in numbered rows, so as I get a new student, I have to add his/her name to the bottom of the list, no matter what letter the name starts with. The electronic gradebook, however, is strictly alphabetical. So as I continue to add students, my gradebook will look like (1. Adams 2. Davis 3. Smith 4. Moore (added later) 5. Franklin (a...

Script for Query-Based DL's
Pardon me if posted in the wrong place. We are scripting a large amount of OU structures and administration groups with delegation through dsacls. This is something that is repeated many times. One item that is asked to create is a query-based DL. Since it would need to be ran so many times and for consistency I am trying to find if we can have the script create the Q-B DL's. I have found scripts for dsacls and the Q-B DL's but I'm having a hard time finding how to script the creation of the DL's. Does anyone know how this would be done? Thank you, Michael ...

String of strings
Is there a standard way of handling a double null terminated string with embedded null terminated strings. I've looked but can't find any examples. TIA, Gerry Murphy You have to manully put them in string, I believe you are looking for MutliSz reg string or string for shFileOperation if i am not wrong. -- With Regards Alok Gupta Visit me at http://alok.bizhat.com "I Believe this will Help" "Gerry Murphy" <gerrymurphy@rcn.com> wrote in message news:YNydnaPkJaUXCc7fRVn-uQ@rcn.net... > Is there a standard way of handling a...

Count occurance of a string across numerous worksheets
Hi all, Have a "Control Page" and numerous other sheets. I've now listed all workseets on the "Control Page" eg: .. A B 10 Feb04-Mar04 11 Jan04-Feb04 12 Dec03-Jan04 13 Nov03-Dec03 14 Oct03-Nov03 15 Sep03-Oct03 16 Aug03-Sep03 17 Jul03-Aug03 18 Jun03-Jul03 19 May03-Jun03 20 Apr03-May03 21 Mar03-Apr03 22 Feb03-Mar03 23 Jan03-Feb03 24 Dec02-Jan03 25 Nov02-Dec02 Im trying to count the number of times a specific string "Internet Usage - Prepaid IP Hours &q...

Searching for Substrings Within Strings
I would like to be able to search and flag a list of string data based on another list of substring data. If I have a list of strings in Column A and input the list of substrings in Column C, I would like an "X" to appear in Column B every time that a substring mentioned in Column C is included in any of the strings indicated in Column A. (There cannot be multiple instances of the same substring, or a combination of different substrings, in each string of data in Column A.) For instance, given the following information indicated in Columns A and C, the "X" should appear a...

update query
How can i build a query where all the rows having -. for example -1, or -2 etc, to be set to o ? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200802/1 On Fri, 29 Feb 2008 06:43:35 GMT, "peljo via AccessMonster.com" <u19312@uwe> wrote: >How can i build a query where all the rows having -. for example -1, or -2 >etc, to be set to o ? Create a Query based on your table. On the Criteria line under the relevant field, put your criterion - for instance just -1 or IN (-1, -2) if you want all records with either of ...

Cheque printout to a file with date & amount converted to text/string
Print cheque output a text file, and this text file will be sent to bank for further processing. There are some fields are hardcoded and some are from GP fields, including date and amount. We modify the Report Writer for the Cheque printing, the added a few of calculated fields. Some calculated fields will contain text with hardcoded data (may contain special characters, like comma and /) Some calculated fields will hold data from the field found in GP and if it is date format, it will be using RW_DateToString() to convert it to string text and this calculated can be showing in...

Error on page when querying using advance find
Hi, WHen i performing search using advance find, there is error Line 385 Char 1 Error Unspecified error Code 0 URL: http://servername/org/AdvanceFind/AdvFind.aspx?Entitycode= XXX &queryid={XXX}&View type = XXX Any hints on how to debug this? In addition another weird thing that i notice, the pop up if blank.aspx page. But i did not update any of my windows. This is happened on client laptop. When i go to production server directly, did not encounter this problem. Could someone help me? Thx Carrie Hi Carrie, Which version of Internet Explorer are you using? Niths "Car...

Query Based Distribution Lists (URGENT)
Hi I've started experimenting with creating the above group types and I want to create a group using a filter that searches for members in a certain security group. My exchange and active directory environment is up to standard and working well.. The steps I follow for this are: 1. Customise Filter 2. Select only "Users with Exchange mailbox" 3. Type in the relevant exchange server under storage 4. On the field button, select User, Member of and under condition I select "Starts with" and then I type the group name or the first couple of distinguishing letters forming ...