Search results

I don't understand... The tables you are talking about, are they the textfiles you talked about earlier or is this another question? If this a split database with front end and back end, why isn't the back end located on the server? Else, why did you split the database if it is all installed on...

Ok! Let's cut all this to pieces... A customer has an order which might have many product on it. So, you got your one-to-many relation there. (That's fine!) Each OrderDetails correspond to one product. So, you need a one-to-one relation for that product to get any info about it. (I Think that...

By using a loop len() times. With 5 characters, it won't be much different, but that would if you had hundreds of them.

Something like that perhaps... CurrentProject.path & "\textfile.txt"

The link does not work.

I think that it is too cruel. Planting Fritillaria imperialis around would be a much better choice.

These should do the job... SELECT Sum([number1]+[number2]) AS total FROM stock; or SELECT Sum([number1])+ Sum([number2]) AS total FROM stock; Edit: Maybe someone could tell which one would be faster. I would go with the first one since it has only one function called, but I haven't tested it.

Can you post your whole SQL string, exactly as you wrote it in your database, so that we can take a look at it?

It is important that you do not create a calculated field in your table. If you can get a data using others, then that data should not be stored. The use of a query will get you the data needed.

Not sure if it was cranberry wine, but she sure took too much of it. :D

It’s not always raisins and cranberries It’s thread like this that moves us along

You can add a table twice or more in a query. The new table created will be called the same name adding a number at it's end. When refering to the departure, you'll say something like that: "tblRegion!strRegion" and when refering to the destination, you'll say something like that...

It means that the cars facing you see a red light. Therefore, you can make a left turn without problems.

Technicaly, I am. But, in my heart, I am Québecois.

So, thanks to the extremists for creating jobs. :D

As I said earlier, I don't have Access with me, if no one else answers today, I'll take a look at it tomorrow. Good luck! Edit: You would have to do a refresh of the subform after the change has been made in the date field.

But I think that you understand why we don't want English-only signs in a place where 85% of the population is French. And as Fifty2one said, we are not against biligual signs, but against English-only signs. The "50% of the size" is not a major problem here, as most of the population would...

If it was only for the word Shoes (In french, it is "souliers" pronounced [Su-lee-ay]), that would be no problem, but let say that the sign says: "Grande vente de fermeture!!! Souliers à partir de 20$, en simili-cuir avec quelques défauts de fabrication. 25% de rabais sur la deuxième paires à...

I was wondering what it would be like if I open a store in Toronto, Calgary or Vancouver(Or why not New-York, London, Tokyo, Berlin, etc) and had all my signs only in french... I'd like to have comments from all around the world for this.

:mad: STATSMAN!!! hihihi:D