Recent content by crystalfun

We have a Team room with a few hundred documents. Is there a way for me to download all files in all documents or do I need to go into each document to extract the file? If so can someone explain?

I am testing a data conversion using reports from legacy and the new system. I want to see if the fields imported properly. Field 1 is a text field and looks like: 12345-123 Field 2 is a text field and looks like: 12345-123 I want to compare Field 1 to Field 2 to look for a difference. How...

This should be an easy one. I have a query with a text field called "Comp" and a second text field called "Dept". I want to combine these two fields in a query so that I get the results of "Comp Dept". How do I do this to see the results in my query. Thanks.

I would like add # of months to a date then see a new date as the result Eg Date = 2/1/2002 months = 36 Desired result = 2/1/2005 What formula can I use to get the desired result?

Please let me know where my mistake is - Thanks SELECT [Fixed Assets After Exchange Calc].[Asset ID], [Fixed Assets After Exchange Calc].[Acq Date], [Fixed Assets After Exchange Calc].[Dep Start Date], Month([Fixed Assets After Exchange Calc]![Acq Date]) AS AcqDate, Month([Fixed Assets After...

I have a field called "Acq Date" and a second field called "Depr Start date." The Depr start date should be the first day of the first month after Acq Date. I would like to write a query that shows me all items where the month of Depr Start Date does not equal one month after acq date...

I have a table where 5 companies have costs in USD and one company has a cost in Canadian dollars. Company 1-5 = USD Company 6 = CAD I want to write a query where the person running it can enter a conversion rate that can convert the CAD into USD thereby showing costs of all records (Co's...

I have a field called "Acq Date" and a second field called "Depr Start date." The Depr start date should be the first day of the first month after Acq Date. I would like to write a query that shows me all items where the month of Depr Start Date does not equal one month after acq date...

I have a field called Asset ID which is made up of a 7 character ID such as "0123456" There seems to be a blank space before the beginning of each number. How can I remove the blank space from the front of the record? In Excel I can use Edit,replace but that doesn't seem to work here.

I have a report that shows total cost per group only if the total is > than $100K. If the total is less than $100K than all the groups costs are hidden The Grand Total in the Report Footer section shows the total of all visible and hidden amounts. Is there a way to calculate the grand total...

Figured it out. Thanks.

I want to hide line item data in the Detail section if the balance of a line = 0. The balance of line items that are <> 0 I want to show. How do I do this?

It works. Thanks. Interesting to note that when the data is Analyzed with Excel the totals are now hard coded rather than summed in a formula. Must have something to do with suppressing the data rather than excluding it.

I have been able to Suppress the detail section of my Access Report with the following code: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.SUM < 100000 Then Reports!Copy.Section(acDetail).Visible = False Else Reports!Copy.Section(acDetail).Visible = True End If End...

Do you mean the Event Section for OnFormat? This requests an even procedure. Where would I place the condition of suppress (or sections visible False) if sum < 100,000?