Search results

Hi Steve I will be out of the country from later on today till Monday. If you dont hear from me till then, please understand. Rob:)

Got it...Thanks Steve :)

"I don't want to think about this right now. I'm getting a headache. Maybe I'll think about it tomorrow." LOL..Yes I agree...It is a hell of a lot to take in...And I thank you again

"I don't know what you mean. What's the status of the form you displayed the image of?" What I mean is that, in my live database, all these functions that you have created will need to be implemented on fields that are derived from tables. The data created needs to be stored in tables for each...

"We can modify the function so that it extracts whatever comes before a hyphen or space. If you can give me the rules I'll give you a function but if the data doesn't conform to any rules and it just chaotic then I'm not sure what can be done unless you are willing to accept best guess on this...

Hi Steve "Unless the other companies have this pricing structure this seems to violate the rule that all transport companies will use the same groups. How do you see this fitting into this this design? Is this one of the exceptions that needs to be dealt with? I suggest we look at these...

If then conundrum Coming back to this. I just thought of a way to circumvent the conflict you mentioned. Take the example below: Prefixes AB1 to AB12 £60 Prefixes AB13 to AB23 £70 Prefixes AB24 to AB35 £50 We can do the following: 1 Group AB4 to AB12 and give it a name 'Fred' 2 Group AB13...

So now we have the basic gist of it working...How do I make the frmDelivery fields bound and functional? :)

qryEstimatedCost: This query is in the event procedure for the get quote button on frmDelivery. Excellent

"SELECT Customers.ID, PostalGroups.Group FROM Customers INNER JOIN PostalGroups ON GetPrefix(Customers.PostalCode) = PostalGroups.Prefix;" So, it looks at the Customer table, find the post code prefix and then picks the postal group from the postal group table. Then assigns the Customer ID the...

"I created this function based on the examples you gave in your first post. Based on that, this function defines the prefix as the part of the postal code that comes before the dash if there is one or the entire postal code if there is no dash. It's important that this be correct. Is it?"...

"Now please look at the relationship. Note that the Group is the parent table of the PostalGroups and the DeliveryCharge tables. You might think there should be a relationship between the Postal Code in the Customer table and the Prefix in the PostalGroups but that relationship can only be...

Hi Steve...What you have created in such a short space of time has left me amazed. It is astonishing. It works even though the fields are unbound on the frmDelivery. The data. Am I correct in saying that on a practical level, I have to do the following 1 Create transport companies (on a Form...

Ah...Yes..I see the logic...I am going to study the version that you sent Steve...:)

Hi again Steve I couldnt see the new version of the demo DB attached. Could you please send it again? Thanks...Rob :)

"The DeliveryCompany refers to the company providing the pallet distribution service. The Group refers to the group of postal code prefixes. It was my understanding from post #7 that these four field are required to determine the cost. Is this correct?" Hi Steve...This is correct. The prefix...

Hi Steve...I tried to google GetGroup but with no success..I am not 100% sure what it does in practical terms but I will wait till when you are ready to explain. Another point is this. This database I am working on is a database that has been running for 5 years and so, its populated with...

Hi Steve...In your query, can you explain the following below? I can understand the rest: ((DeliveryCharge.Group)=GetGroup([Forms]![frmDelivery]![CompanyName])) AND (Where ‘Group’ in the table Delivery charge = ? I don’t understand the GetGroup syntax. Can you pls explain?) Thanks...Rob

Hi again Steve...Could it be that relationships are not needed for this? All the best Rob :)

Hi Steve...This looks very promising!!. Thank you. I cant see the relationships on the tables for some reason....Something I need to do for viewing it? Best wishes...Rob :)