Search results

I inherited a database in my workplace a number of years ago. Initially the entire database consisted solely of a single table with all the associated data and a second table that was (and still is) as far as I can see essentially a copy of all the data in the first table. I still don't...

Okay, first let me describe what I'm trying to do, then how I'm going about it and where it's failing. I've got one form ("F_NewActivity") where I create an id for an activity record. When I save and close this form, I want to automatically open the "F_TimeLog" form, create a new TimeLog...

I feel like I've seen this addressed here before, but couldn't find it. I'm curious what the experts here think. (This may be a VBA question rather than a query question, but since it deals with queries I thought I'd put it here first.) Before I spend a lot of time designing a suboptimal...

Hi, I'm exporting some data from an Access Database into an Excel Spreadsheet to create a report in Excel, and I'm running into some problems with that. The idea is I have an Excel Template with a tab to take raw data from an Access Query, and then a couple tabs that manipulate that data and a...

I'm trying to select a range of relevant dates for an amortization calculation (see my earlier thread on this subject here), but I'm having a bit of trouble making the SQL work. I have a table called "t_AllMonths" that has only one field: MonthStartDate which contains the first day of the month...

Good afternoon, I'm working on a database where I enter a series of assets and their costs, and I'm trying to build a query that will generate an amortization schedule for each asset. I'm using an amort methodology that amortizes a certain amount each period based on a calculation. I've got a...

Good afternoon, I have an existing report with a number of fields arranged horizontally in a tabular fashion in the detail section. The first field is an identifying line of text and the remaining fields are numerical calculations. The report is basically a simple profitability estimate report...

I'm not sure I'm going about this the right way, but here's the gist of what I'm working on: I'm trying to track a certain activity (let's say number of calls made, although that's not the actual activity I'm tracking) and progress toward a goal related to that activity. Tracking the activity...

Hi, I got some great help here on a related issue that really dramatically improved the efficiency of some queries I was running. But now I'm running into a new problem on the same project. For background: what I'm trying to do is compare profitability on a given set of products between two...

Hi, I introduced myself on the Intro board, but I'd like to get to the meat of the problem I'm having. A little background on the problem. At the company where I work there is an old legacy app. It can generate a few canned reports, but it's a bit of a clumsy implementation, and lacks any...

Good afternoon, My name is Stephen Watkins, and obviously I'm here for Access help, but let me introduce myself first. I was first introduced to Access back in college a bit more than a decade ago. Learned the basics of Access as a business tool in one class and separately (not directly...