Andy Lacey
andy at minstersystems.co.uk
Mon Feb 10 14:54:00 CST 2003
Sounds like a trial and error job with your references. :-( Andy Lacey http://www.minstersystems.co.uk > -----Original Message----- > From: accessd-admin at databaseadvisors.com > [mailto:accessd-admin at databaseadvisors.com] On Behalf Of Jim DeMarco > Sent: 10 February 2003 20:46 > To: accessd at databaseadvisors.com > Subject: RE: [AccessD] Partition Function A97 > > > I tried removing both AS statements and still no luck. > Really weird thing is the code below won't work in the new > mdb either. My library db where it works has a lot of > references so I don't know which if any might be necessary. > > Thanks, > > Jim DeMarco > > > -----Original Message----- > From: Andy Lacey [mailto:andy at minstersystems.co.uk] > Sent: Monday, February 10, 2003 3:38 PM > To: accessd at databaseadvisors.com > Subject: RE: [AccessD] Partition Function A97 > > > Can you say 'As Count'? Isn't Count a reserved word? > > Andy Lacey > http://www.minstersystems.co.uk > > > > > -----Original Message----- > > From: accessd-admin at databaseadvisors.com > > [mailto:accessd-admin at databaseadvisors.com] On Behalf Of Jim DeMarco > > Sent: 10 February 2003 20:30 > > To: accessd at databaseadvisors.com > > Subject: RE: [AccessD] Partition Function A97 > > > > > > I'm not so sure about that Charlotte. I can use Partition in > > A97 as follows: > > > > Sub DoPartition() > > 'testing Partition function > > Dim ans As Variant > > Dim i As Integer > > > > For i = 11 To 110 Step 13 > > ans = Partition(i, 1, 100, 10) > > Debug.Print "Value " & i & " falls in range: " & ans > > Next i > > End Sub > > > > Which returns: > > Value 11 falls in range: 11: 20 > > Value 24 falls in range: 21: 30 > > Value 37 falls in range: 31: 40 > > Value 50 falls in range: 41: 50 > > Value 63 falls in range: 61: 70 > > Value 76 falls in range: 71: 80 > > Value 89 falls in range: 81: 90 > > Value 102 falls in range: 101: > > > > Is there a reference I need to add maybe? The code above > > runs in my code library mdb (A97) but not a new one I'm > > putting together for a demo (also A97). > > > > Thanks, > > > > Jim DeMarco > > > > > > > > -----Original Message----- > > From: Charlotte Foust [mailto:cfoust at infostatsystems.com] > > Sent: Monday, February 10, 2003 3:07 PM > > To: accessd at databaseadvisors.com > > Subject: RE: [AccessD] Partition Function A97 > > > > > > Sorry, but Partition came in with A2k. You can't use it in > > 97, along with Replace(), Split(), Join(), etc. > > > > Charlotte Foust > > > > -----Original Message----- > > From: Jim DeMarco [mailto:Jdemarco at hshhp.org] > > Sent: Monday, February 10, 2003 11:40 AM > > To: AccessD (E-mail) > > Subject: [AccessD] Partition Function A97 > > > > > > Shouldn't the following SQL work in A97? I can get the > > Partition function working in a loop in a test module but not > > when I try to run it against a table. I'm running this > > against the Northwind Orders table to test and get "This > > expression is typed incorrectly or is too complex..." error > > anytime I try to use Partition in a query. Works fine in > A2K though. > > > > <sql> > > SELECT DISTINCTROW Partition([Freight],0,1000,50) AS Range, > > Count(Orders.Freight) AS Count FROM Orders GROUP BY > > Partition([Freight],0,1000,50); </sql> > > > > > > TIA, > > > > Jim DeMarco > > Director of Product Development > > HealthSource/Hudson Health Plan > > > > > > > > ************************************************************** > > ********** > > *********** > > "This electronic message is intended to be for the use only > > of the named recipient, and may contain information from > > HealthSource/Hudson Health Plan (HS/HHP) that is confidential > > or privileged. If you are not the intended recipient, you > > are hereby notified that any disclosure, copying, > > distribution or use of the contents of this message is > > strictly prohibited. If you have received this message in > > error or are not the named recipient, please notify us > > immediately, either by contacting the sender at the > > electronic mail address noted above or calling HS/HHP at > > (914) 631-1611. If you are not the intended recipient, please > > do not forward this email to anyone, and delete and destroy > > all copies of this message. Thank You". > > ************************************************************** > > ********** > > *********** > > > > _______________________________________________ > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/a> ccessd > > Website: > > http://www.databaseadvisors.com > > _______________________________________________ > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/a> ccessd > > Website: > > http://www.databaseadvisors.com > > > > > > > > ************************************************************** > > ********************* > > "This electronic message is intended to be for the use only > > of the named recipient, and may contain information from > > HealthSource/Hudson Health Plan (HS/HHP) that is confidential > > or privileged. If you are not the intended recipient, you > > are hereby notified that any disclosure, copying, > > distribution or use of the contents of this message is > > strictly prohibited. If you have received this message in > > error or are not the named recipient, please notify us > > immediately, either by contacting the sender at the > > electronic mail address noted above or calling HS/HHP at > > (914) 631-1611. If you are not the intended recipient, please > > do not forward this email to anyone, and delete and destroy > > all copies of this message. Thank You". > > ************************************************************** > > ********************* > > > > _______________________________________________ > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/a> ccessd > > Website: > > http://www.databaseadvisors.com > > > > > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/a> ccessd > Website: > http://www.databaseadvisors.com > > > > ************************************************************** > ********************* > "This electronic message is intended to be for the use only > of the named recipient, and may contain information from > HealthSource/Hudson Health Plan (HS/HHP) that is confidential > or privileged. If you are not the intended recipient, you > are hereby notified that any disclosure, copying, > distribution or use of the contents of this message is > strictly prohibited. If you have received this message in > error or are not the named recipient, please notify us > immediately, either by contacting the sender at the > electronic mail address noted above or calling HS/HHP at > (914) 631-1611. If you are not the intended recipient, please > do not forward this email to anyone, and delete and destroy > all copies of this message. Thank You". > ************************************************************** > ********************* > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/a> ccessd > Website: > http://www.databaseadvisors.com > >