View Single Post
  #7 (permalink)  
Old December 20th, 2005, 08:49 AM
crmpicco crmpicco is offline
Friend of Wrox
Points: 8,019, Level: 38
Points: 8,019, Level: 38 Points: 8,019, Level: 38 Points: 8,019, Level: 38
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2005
Location: Mauchline, East Ayrshire, Scotland
Posts: 1,525
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to crmpicco Send a message via AIM to crmpicco Send a message via MSN to crmpicco Send a message via Yahoo to crmpicco
Default

thanks matt,

i have this loop below in my code:

Code:
For d = (tempCol - 64) To Last_Col

                                        If sPer <> "" Then
                                            sPer = sFarePeriod & "-" & Cells(tempRow, d).Text
                                            sPer = stripPeriods(sPer)
                                            sPer = convertPeriodDates3(sPer)
                                            gbFoundPeriod = True
                                            sFareSeason = "Season 1"
                                            Exit For
                                        End If

                                        '... if the cell has a date inside it then set that as the
                                        '... first part of the period date (01Jan05)
                                        If hasDate(Cells(tempRow, d).Text) Then
                                            sPer= Cells(tempRow, d).Text
                                        End If
                                    Next d
How do you mean using the 3 primary key fields?



www.crmpicco.co.uk
Reply With Quote