Re: CF array help

2006-11-17 Thread Adrian
Not sure if I've read your question right, but heres a tip: The group attribute can often be used to avoid the need for arrays. Try this: #PRJ_PointID#, #PRJ_MainID#, ,#fund_name# The output is not exactly the same as your desired output, but Im hoping thats be

Re: CF array help

2006-11-16 Thread J Robinson
I should have explained where I am at. I have run the qury to get the data and then created and populated the 2darray in a loop. Code shown below. SELECT PRJ_PointID, PRJ_MainID, Fund_Name FROM PRJ_FundAmount GROUP BY PRJ_PointID, PRJ_MainID, Fund_Name N

RE: CF array help

2006-11-15 Thread Robert Harrison
Oh yeah, and that's a query and output, not an array. But that's looks like what you are asking for. Robert -Original Message- From: Robert Harrison [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 15, 2006 7:17 PM To: CF-Talk Subject: RE: CF array help Do:

RE: CF array help

2006-11-15 Thread Robert Harrison
:[EMAIL PROTECTED] Sent: Wednesday, November 15, 2006 7:10 PM To: CF-Talk Subject: Re: CF array help http://tutorial150.easycfm.com/ On 11/15/06, J Robinson <[EMAIL PROTECTED]> wrote: > We are using cf with access as a database for an application here at work. I've only been using cf for

Re: CF array help

2006-11-15 Thread Charlie Griefer
http://tutorial150.easycfm.com/ On 11/15/06, J Robinson <[EMAIL PROTECTED]> wrote: > We are using cf with access as a database for an application here at work. > I've only been using cf for about 2 weeks now so I'm a little green. I have > an access table that stores project funding information

CF array help

2006-11-15 Thread J Robinson
We are using cf with access as a database for an application here at work. I've only been using cf for about 2 weeks now so I'm a little green. I have an access table that stores project funding information in it that I need to manipulate. here is a snippet from the table: PRJ_PointID PRJ_