Recent content by TSO456

The hide duplicates worked ok, however, when the report has more than two pages of output the duplicates are showing up again.

Hello, I have an Access report like this: Date amount 10/11/2004 $200.00 9/27/2004 $100.00 9/27/2004 $100.00 How can I supress the Date and amount that show up more than once. Thank you Jill

Hello, I am trying to import this number -1,855,151.82 from a .txt file into an access table/column. But for some reason the number can not be displayed correctly. all I can see is 855,151.82, any recomendation on what I need to do to import this number to show correctly Thank you Jill

Yes, I can change the table to look like the above. After I make that change what is the SQL that I need to use to achieve my results? Thanks Jill

The table looks like this: Users ID Jan 04 Feb 04 March 04 April 04 etc.. A022212 20 10 0 25 A322222 10 15 10 50 A000012 3 1 5 6 etc.. Thanks Jill

Hello, I have an access table that shows the users and the number of times they have visited my site by month. So picture a grid where all users are on the left and the months on the top and the number of hits/visits to my site in the middle. I would like to create a query that shows me the...

I use the code below to send emails from excel. I am trying to enter code on the LastRow line so excel will go to the last cell in the sheet instead of me having to specify the lastrow in the spread sheet that contains data. Thank you Jill Set Sht = Worksheets("TEST") FirstRow = 2 LastRow...

Hi, I have two columns in a Access table: Amount1 Amount2 100 200 300 400 500 I would like to divide amount1 (100) by amount2(200), (300), (400) etc. How can I do that? simply, I would like to divide values in amount1 by every value in amount2 Thank you Jill

Hi Dbomrrsm Yes, I want the value in Col1 i.e. 1 to be compared with every value in col2 i.e. 2 and 4. Then after this comparison is done I want the next value in Col1 i.e. 3 to compare with col2 i.e. 2 and 4 Thank you Jill

Does this compare each and every row in column 1 to all the rows of column 2 ?

Hello, I have a table in SQL server that has two columns with different dollar values. I would like to create a query that looks at each value in column 1 and compares that value to each value in column two. I would like to extract the values in column 1 that are less than 5% the values in...

Hi PH I need a VBA code that does that. A SQL query will not work. Thank you Jill

Hi I have an access table with 2 columns. I would like to compare each record in column one to all the records in column two. If any record in column one is less than column two then produce a report with the records that meet the criteria. Thank you Jill

How can I do it in a query? How can a query compare each value to multiple values? thanks Jill

Hello, I have an Access Table: Values (1) Values (2) $200 $200 $250 $250 $300 $300 I need to write VBA code that checks if EVERY amount in the values(1) column is less or equal to the amounts in the values (2) by 5%. Each amount in Values (1) need to be checked against...