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?

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...

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?

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...

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...

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...

Table Name: tbl project Field Names: Co Dept Acct Project Balance This table is sorted ascending by Project #. I want to create a query showing Co, Dept, Acct, Project, & Balance. Then at each change in PROJECT I want to subtotal the amount of BALANCE so that I see the individual amounts and...

I've been out of programming and back into accounting for over a year so I forget everything. Please help. I have an Access database with 2 tables. I want to return a value from Table 2. I forget how to write the formula. If Field 1 and Field 2 from Table 1 = Field 1 and Field 2 from...

After subtotalling a spreadsheet in Excel I want to delete all of the detail and leave the total only. What VB code can I use to loop through the rows and delete every row except the one reading &quot;Total.&quot;

I have a table with 190K rows that shows all invoices paid in 2001. Each row contains a vendor number, invoice number, etc. I want to create subtotals at each change in vendor number to determine the total number of invoices sent by each vendor. I can do this easily in Excel using the...

I have an AP table showing all entries in database. If an invoice was charged to 10 different companies I see the invoice number 10 times with 10 different $$ amounts. What's the command to add up the dollar amounts so that I see one invoice number and one total dollar amount?

I have a text string of 8 numbers that I bring into Excel but I want them to come over as true numbers to then run other command from. Whats the sql command to convert text numbers to real numbers.