Search results for query: *

Is there a way to filter columns in Pivot table and show up only certain results within each column using VBA? thanks, Dan.

Thanks it worked. One more question. Is there a way to get the first column position within pivot table? Thanks for your help.

Is there a PivotTable function or solution which returns starting location of each pivottable in the worksheet? Thanks, Dan.

Magical...working perfectly. Thanks.

PHV, Thanks for reference guide, but i am familiar with relational databases. my Query, but it doesnt work properly. SELECT Table1.Date, Table1.Cost, DSum("[Cost]","table1",[Date]<=#1/2/2009#) AS [Running Sum] FROM Table1;

Remou thanks for your help, but its to slow, since I have a lot of records. Do you have a VBA solution?

I would like data in Table1 to compile running sum into table2. Is there a running sum query in access? or it has to be done though VBA? Table1: with the following fields Key Commissions Sales Table2: Key RunningSumofCommissions RunningSumofSales Thanks in advance.

I am trying to create report that will show one field from the database. That field is a memo field and its very long, I would like to break it to the next line at specific places, but I can't break it at specific places because Access Reports doesnt understand \n. Here is a sample field from...

I have hundreds of lines, I have to skip them all the time its not just at the end of the file. is it possible to translate it into perl: Pick up the lines where String starts with M and its between Treaty string.

I need to pick up the company name from each line. I can't write a regex that will pick up the string "MUNICH AMERICAN (CNA)" or "MUNICH AMERICAN" from each line. Basically, it has to pick up a string from the beginning of the line to "Treaty" part and it should ignore Totals since it also has...

Is it possible to do through ADO I dont want to do it manually since i have to link several tables.

I dont want people to see where the data is coming from and sometimes i will need to send database to external clients the link wont work then.

SELECT REINSPM.* INTO TEST..." I dont know does it tell the destination of where the Table should be made? or there is a Different way I can refer to make in access?

I am trying to query information from the SQL server and when I am running Make Table Query and it creates it on SQL server instead of in Access. Dim myConnection As ADODB.Connection Set myConnection = New ADODB.Connection Dim rstSource As ADODB.Recordset Set rstSource = New...

I have Primary key which keeps them in order.

Well policy number don't repeat, thats what makes it a bit more complicated.

Can any please help with concatinating several message fields into the 1 row. from Table1 -> Table2 I have wrote the code but it doesnt work properly. Can you please check my logic or suggest your solution. Thank you. Table 1 Policy Message 01 msg1 msg2 msg3 02 msg1 03 msg1 msg2 Table2...

Thanks guys let me try it. I am rookie in perl.

I need to convert textfile to HTML. Example of textfile below: textfile.txt a. Line 1 b. Line 2 HTML Create HTML page with the Name of todays date. And inside color code the lines and remove a. and b. in front of them until EOF. if first char is a. then line should be red. if first char is...

Private Sub Add(x,y) z=x+y docmd.openreport Addition Report_Addition.labelName=z end sub it doesn't pass the variable to that report.