Search results for query: *

This is hopefully easy for someone else but I don't deal with it often. I have a pointer in a cell to a cell in another sheet in the same workbook: ='ANOTHERSHEET'!A1006 I need for the next cell down to point 9 rows down from the last one: ='ANOTHERSHEET'!A1015 ...and to continue until...

We're updating from VAMT 2 to VAMT 3 for KMS licensing of our Windows 7 installations. We have a new server configured with VAMT 3 and have changed the DNS entries to point KMS licensing to the new host. Do we need to manually activate machines in order to get the new KMS server running (you...

Hello, I have an Access database which I've been using successfully since Office 2003. It records dates and times. I created a query and then access that query from Excel, to print it out on specific templates. The only CUSTOM thing is that I have Excel configured to show the TIME in...

Hi, I have a report based on a query that has worked fine. I give it a date range and it will show one line per record that satisfies that range. The problem is that they now want the report to exactly match a paper version that is not computer-friendly. I was able to get the form to LOOK...

Hi, I have a table/query/form that lets me input data into a single table. I'm looking for a way to create a NEW record based on the LAST record, with the data from two fields switched. I created an Append Query that works fine in terms of the record information appended except that it adds...

I have a report that contains a sub-report displaying totals of numbers based on an underlying query. In each individual record of the query, there is a short decription. What I'm looking to do is to have all those descriptions put together as one text box on the same report. Here's an...

I have a report with two subreports (SUB1 and SUB2). Each subreport has it's own query to grab specific data from separate tables. SUB1 displays a listing of fields, based on a specific date. The last field in each record (TVMIL) is a number. The second subreport is supposed to take the SUM...

Hi, I'm trying to do something that should be fairly simple but seems to be eluding me. I have a table which I update with a simple form that merely chooses or allows me to dump in data and then save the record. It's a mileage form. With one exception, the mileage is always consistant...

Hi, This is hopefully a very silly question but I'm stuck right now. I have a table that lists individual numbers as such: DATE NUMBER 8/1 3.3 8/2 4.5 8/5 2.0 9/1 3.5 9/2 3.7 I made a query that asks me for a start and end date, so that I only see the records that correspond...