[AccessD] Fastest Way To Get Data Field From Recordset

But it presumably will not die if someone has (cough) used a space in the
name Charlotte?

Regards
Chris Foote - UK


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte
> Foust
> Sent: Wednesday, June 29, 2005 3:47 PM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] Fastest Way To Get Data Field From Recordset
> 
> 
> The first option  is the slowest way.
> 
> Charlotte Foust
> 
> 
> -----Original Message-----
> From: paul.hartland at fsmail.net [mailto:paul.hartland at fsmail.net] 
> Sent: Wednesday, June 29, 2005 7:37 AM
> To: accessd
> Subject: [AccessD] Fastest Way To Get Data Field From Recordset
> 
> 
> To all,
> 
> I have taken over a project and where I would normally use something
> like
> 
> strMinPayroll = rsMinPayroll.Fields("LowPayrollNo")
> 
> it is written as
> 
> strMinPayroll = rsMinPayroll!LowPayroll
> 
> Is there a difference in speed with these, i.e. is one more efficient
> than the other etc....
> 
> Thanks in advance for any help on this...
> 
> Paul Hartland