Recent content by Chris SL

thanks a lot for your help, I am thinking to save datas in one same table. according with all answers, I understand that it will be the best way for me

thank you, seems that I need to do with one table

the point was that I didnt want to insert datas in 2 tables for new properties

on the first table I have more fields, all the informations about the property. in the second one only prices updates for the property

Q1 is SELECT TableNewPrice.adresse_new, Max(TableNewPrice.date_new) AS MaxOfdate_new FROM TableNewPrice GROUP BY TableNewPrice.adresse_new; and Q2 is SELECT Q1.adresse_new, TableNewPrice.date_new, TableNewPrice.price_new FROM Q1 INNER JOIN TableNewPrice ON (Q1.MaxOfdate_new =...

so maybe an union query could be the way ?

sure, but I want to manage it with 2 tables

thank you for your answer but microsoft detects non trustable macro in your DB. Can you explain there your way to solve my issue ?

Hello I have 2 tables TableStartPrice and TableNewPrice In each 3 same fields: Adress, Date, Price In TableStartPrice only one record per adress In TableNewPrice could be several records per adress With a query I want to know the last price (by date) for each adress coming from...

thank you for your answer

Thanks a lot for your answer. It looks like that dynaset inconsistent solves my problem. Anyway, I would like to take the opportunity to understand more. 1 table per form is the rule or use subforms. Ok, well noted. Same for query, 1 query for 1 form ? You said that my issue is an indicator...

Hello I created a data input form with 2 tables: "tableA" and "tableB" Both tables have different fields 1_a, 2_a, 3_a .... for tableA and 1_b, 2_b, 3_b .... for tableB Both tables are linked with field 1: 1_a are unique records, 1_b are multiples, both tables are linked with first link option...

it It works perfectly, thanks a lot. so I understand that it was necessary to add single quote on " & [Formulaires]![Ajout_Reevaluations]![liste_adresse] & " because it is short text field. but why [adresse_reeval] does't need ? it is also short text field

Hi Gasman, Thank you for your answer but it is close Chinese language for me, I am beginner and not fluent in English. Sorry. Can you please explain this: "Strings need to be surrounded by single quotes ' unless it contains a single quote, then triple double quotes works" ?

Hi theDBguy Thank for your answer but what do you means by "you'll need to use a delimiter in your criteria" ?