Search results for query: *

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?

I'm used to writing crystal reports where I can suppress data if certain criteria are met. This is easy in Crystal. Is there a way to do this in Access? I have a report where the group header has a project #, the detail has company, dept, account, and balance of account. The group footer has...

accidentally posted to this thread rather than the reports thread. Couldn't find anything that says how to delete it. Rather than putting &quot;time wasting multi post warning&quot; on both posts...why not put it on the more appropriate one which is this since my post belongs in the Reports...

I have a report that shows line item detail (Co, Dept, Account, Balance) in the detail section. This data is sorted by Project # (project header section). The Project Footer section displays the Total by Project based on the amounts in the detail section. I want to filter out projects that...

I have a report that shows line item detail (Co, Dept, Account, Balance) in the detail section. This data is sorted by Project # (project header section). The Project Footer section displays the Total by Project based on the amounts in the detail section. I want to filter out projects that...

Thanks for the SELECT statement. However this does not subtotal at each change in Project. Can Access do this or do I have to stick to Excel?