Search results

Hello, I have a problem with my access base and i would like your advice. I have two tables in my base, in the first “Data” I have a field which name “Mtt”. I would like to transform the field name “Mtt” by the name of month preceding (if i‘am in August, I would like July like in the base...

Hello, I would like to ask you a question about the report. I have a query with 9 fields but sometimes i have 6 fields and sometimes i have the full fields, so 9. Is it possible to do a report with 9 fields but if i have 6 fields, i would this report with 6 fields and i don't want to redo the...

Hello NamLiam, Perhaps i 'am dumb, but could you look my form in my base because it doesn't run. Probably it's my base or me :rolleyes: Thanks Keawee

Thank you namliam for you answer but this solution doesn't run. I f i do this, the focus move on the top of my form but only the focus. I want to move on the top on my form and see the top on my form. Thanks you for your help, Nilses

Hello, In the bottom of my form, i would like to insert a button to climb back at the top of my form. Is it possible to do this ?. Thanks you for your answer Nilses

Hello, I have a problem with a recordset. I have a form with a lot of fields. I can find the first item and i can find the next one. My problem is the next one. 1/ I find the first serial number like 0. I'am looking for the first item in my table with the serial number like 0 with the RI...

Oups, thanks you for your help, Nilses

Hello, I have a problem with my code to export ma query from Access to Excel. I have a cross table with 2 fields and 2 records. In my recordset, would like to keep my second field but in ica't do it. My table is like this: field 1....field 2 Type | 1 --------------- D | 2618 DT | 207...

Thanks you for your help Jon K, it's perfect. Nilses

Hello, I would like your help about a query. In attached file, i have a table which name "Table_Hot_Line". I have three fields and i would like to reverse the table. I would like in head of column, the field "Date' and in the head of row, the field "D" and "DT" but i don't know how can i do...

Hello, I would need your assistance on the references. I partly found the answer to my question about this forum thanks to the post of Wayne Ryan. I 'm not sure if it's the best way to resolve my solution but it's problaly one solution? I will place my file access in a folder on a server. I...

Hello, Thank you Nouba for your assistance. You are right, it is well my outer join which poses problem. I used the technique with your NZ. It there not of solution to my problem to remove this column. It is a pity which there is not a word in SQL for saying for example SELECT * FROM...

Hello, I have a problem with a cross query. I use two table. My first table is built dynamically since a form. My second table is a table which gathers all the cases that I can find in one of my fields of the table. "Tbl: DataBase Générale" - This table is my table built since a form. In this...

Hello, I 've a question with cross query. When I launch my cross query, it created me a new column with that of the zero. If I launch my query, I should have a column Module, a column total of the columns out between module and total, I have a column which names others. Well on I say other...

Thanks EMP, It's run perfectly. The date format is always the problem for us, i'm stupid Thanks for your help ;-) Have a nice day or evening at your home. Nilses

Hello EMP, Your attached database works on my system, but i 've a question. Sometimes, the num is correct and he's respect the order chonologic like this and sometimes no, why?. Type...Series...Interv...End_Date......Num...For Me 124....14013...680.......09/02/2003...3........It's the oldest...

Hello EMP, Thanks for your help, when I launch your code, I 've an error. The data type is incompatibility in the expression of criteria. The result is this. Type........Serie.....Intervening.....End_Date.........Num 124.........13745....684.................09/09/2003......#Error...

Hello, I have a problem in my query and I do not see how me to leave there. I have a query with these fields, Type, Series, Intervening and End. I can have several times the same Type with the same Series, the same Intervening and different End_Dates. If I have two dates, I can reach the first...

Hello, I have a problem concerning one of my functions and I think that you could help me. I was helped on this site by TimK and Harry of the site access-programmers to carry out the beginning then I progress on my function by myself. This function makes the difference between two dates by...

Hello, I have a problem concerning the queries. I would like to post Zero when my query is empty. I have make this query but in the field of my query, I do not have data. How then I to make. SELECT Sum([REPORTING: Hors Délais > 6H00 NB (Nombre)(base)].Nombre) AS Nombre FROM [REPORTING: Hors...