Search results

Hello, How can i create an report joint three table together the three table are according to the image the two table (Research & Estebak) contain many records for the main table "Attack", I prefer if i can get the main table in the report and the two table in a data grid for each table. each...

Found that is the answer rstInsert(RTrim(rst![Attacking])) = "<img src=" & Chr(34) & "Attacking.png" & Chr(34) & " > "

Hello, I have in a form this code but i need to add image path for HTML to export the FinalTable to Web "HTML" format specially my point in rstInsert(RTrim(rst![Attacking])) = "<img src=Attack.png>" The full code is :- Option Compare Database Private Sub CreateCrosstab_Click() Dim...

Hi again when I run the "CreateCrossTable" it works but receive an error, i try to follow up but i do not know what could it be.

Exactly that is what i am looking for.... Many thanx for this, but when open the form and click i got the following image where i am the only one who open the file.

ok i got only a snap from the data which i mean, acording to my last post That is an real example from what i want which i have made it manual on excel, Tab1 is as following Tab2: hope that will help

Hello, i was asking for crosstab please have a look for my example http://speedy.sh/fCkWk/Example.xlsx two tabs, Tab: MainQuery: Explain the main query which have been done to get this table. Tab2, Crosstab: is an example of what i want, please go to row 30 under unite "Osorio" so you can see...

Hello, i was asking for crosstab please have a look for my example http://speedy.sh/927A7/Example.xlsx two tabs, Tab: MainQuery: Explain the main query which have been done to get this table. Tab2, Crosstab: is an example of what i want, please go to row 30 under unite "Osorio" so you can see...

Sorry i have misunderstand What i am looking to have a table as it is in this image and while we imagen we have all our data in this image for example all the columns of attacking , defenseing and nothing are filled how can i do an table using SQL to get all this informations as this...

You are right, the image is just an example on Excel and i want to get the same resualt as it is in the image.

that is what i want exactly to get the result the value or text from the three columns (Attacking, Defenseing and Nothing) to get it into the cross table, and to have the column and row names as "unite_name". is that possible.

exactly all 10 records or it depns on i want to inseart the ten or more or less into record 23 as also 10 record. so that mean if i want to insert the blue marked records that mean the 10 records to rwo 23 then row 24 will moved down + 10 records. so row 24 will be record 34. in other ways the...

Hello again, Sorry for many question today but i have an small project working on to get ideas but i face some problems, I have add my two tables Main table calls Attack Sub table calls Research the main table attack is linked with sub table Research by Attack.ID and Research.attack_id from...

My main Query which i will the crosstab take is: The result which will be on the crosstab is as following: That is what i am looking for as an example Note: i have remove the link because i can't attached any kind of link or image because i only one post. Hope can be help in that

I want to do an report from different tables .... but as well i want to add some data to be added on each item alone adding with this data dinamic info for example sale : sold, in store if it is sold to be to invisible in store, if it is in store invisible in sold?

Could an crosstab query to be added in reports? and how please?

as well i want to know could we add an crosstab query to the reports? and how could that be done?

Great idea on the button and chose from proparities - even onclick and write the need code

Many thanks

Hello, How can I update (some columns) in a table from the same table based on a Criteria column in the same table.