Search results

I think we'll be going towards Contact, Règlement, Détail in our modified database en français, i.e. simplifying almost as much as I did in my English example/translation above. Not sure though about MajusculesDeChameauOuDeDromadaire 🐫 🐪for a basic-level user who is accustomed to the capitals...

My list of things to do in reorganising this context now includes: attempt to introduce the concept and use of CROSSTAB in French with my friend modify table names and field names (database has been in for many years), shortening them and removing spaces eliminate use of Excel, except in urgent...

Thank you! @June7 @ebs17 @Pat Hartman @CJ_London @MsAccessNL We have learned a lot! We tried your suggestion(s) and it(they) worked ! after some struggles with square brackets*. This is the result per our database field-names, and also expressed with my 'simplified' field-names. I hope you now...

thank you all so much for your timely help :) we shall try both paths, -1-SQL query and -2- crosstab, and report back to you [NB. for various reasons -1-may well have to wait until Thursday -2- will be later: please be patient, I too will have to wait probably]

thank you CJ_London. - and my apologies if I'm not being clear enough, or using plain English instead of appropriate Access-speak: I am learning - Yes, they do have a relationship, which I called a link, (contact id) from contacts to payments, and (payment id) from payments to details. No...

Thank you ebs17 - so I think I now have : q4. Please confirm, SELECT [cname], Sum ( IIf ( Code LIKE "SUB*" , Detail.€ , Null ) ) AS subscriptions, Sum ( IIf ( Code LIKE "DON*" , Detail.€ , Null ) ) AS donations, Sum ( IIf ( Code NOT ( LIKE "SUB*" OR LIKE <>"DON*" ) , Detail.€ , Null ) )...

Thank you all very much AWF VIP , MsAccessNL, Pat Hartman, CJ_London, for your suggestions and reactions. These are my responses: Regarding the novelty of CROSSTAB, I feel that that in any situation "novelty" is relative to each player and their own knowledge experience and permeability to...

Thank you so far ... if possible, want to stay on familiar territory ie. query wizard, query design, or very simple SQL. I do not wish to introduce the person I am helpîng to new ideas, crosstab, etc. as this would introduce additional noise to the process: I have to do this in French, and I do...

I'm stuck! on a really basic problem, helping a friend in a small local club who uses French-language Access2007 to track contacts/members, payments, and payment-details (such as subscriptions, donations, sales of documents). Neither of us is really familiar with Access although my friend uses...

I am a retired Brit, living in France after working here for ~40years. My reason for joining : I have a few Access2007 questions, as I am trying to help a French-language Access2007 user, but this is 25+ years after some exposure to the US-English Access95(?) in a job where I never actually...