Charlotte Foust
cfoust at infostatsystems.com
Wed Jun 29 09:46:47 CDT 2005
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 -- Whatever you Wanadoo: http://www.wanadoo.co.uk/time/ This email has been checked for most known viruses - find out more at: http://www.wanadoo.co.uk/help/id/7098.htm -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com