Search results

Ok. I have just downloaded the alst version you sent, and the matter remains!

Yes, I did exactly what you told me, and the result is different:

Hello @arnelgp, Many thanks for your help, however Val2 is rounded to the unit: "6" should be "6.6", "1" should be "1.18" etc.. I tried adding Format(...;"0.00"), but it doens't work.

Exactly

Sorry to bother you @arnelgp , I am having trouble rounding the figures: it should be 6.6*400 = 2640, however it does 400*6 = 2400. I have tried Format, val(format(value,"0.00")) but wihout any success so far. Could you help please? Thanks in advance!

Fine work, I never used the form's recordset, I keep the method, many thanks!

Hello, In one sub-form, I want to sum-up all the values of a particular calculated field ("PrixTot"). Therefore I have created a text box, put it in the foot part of the sub-form, and populated it with the Sum function: =Sum[(PrixTot]). But it gives me an error value "#Error" I cant populate it...

We manage to deal with these files: we upload them into a MySql in a remote server, then we used pass-through queries from an Access, the queries are then used by Excel through Powerquery. Thanks for your help you all.

Hi Doc, I will try to figure this out, many thanks

The data also come as CSV. We will try to import into a MySql, I keep you updated

Whereas I said it quit, I managed to connect actually. It is when I try to sum up values that it chokes

Here is the link to the table: https://www.insee.fr/fr/statistiques/fichier/5395740/RP2018_indreg_dbf.zip I create a linked table, and then when I try the query below: SELECT FD_INDREG_2018.DEPT, Sum(FD_INDREG_2018.IPONDI) AS SommeDeIPONDI FROM FD_INDREG_2018 GROUP BY FD_INDREG_2018.DEPT...

Access quits actually

Sorry for the word operate: I meant, just using the data from that DBase with Access or Powerpivot. Many thanks.

Exactly

Hello all, One client asks me if we could help them operate some Firebase databases: they are huge: I have tried tiding them up to Access or Powerpivot, but it chokes before ending. I guess the queries would be very slow, or even wouldn't ever return results. Some of you people have some...

Hello, Thanks a lot, Could you give us some details please?

I keep you updated about the answer!

It looks promising: as I don't have access to the server for a couple of weeks, I 'd like to run a few trials in my local computer. How should I adapt the following code please? Many thanks! openfiles /Query /s Server /fo csv pause

Thanks, I think this is for Excel files only, isn't it?