Search results

I'm having a problem in Access 2010 I never encountered in Access 03 or XP. I add a field which is a calculated field based upon three fields in the query; essentially, a distance formula using three dimensions. I add a field, "Distance: Sqr([x]^2+[y]^2+[z]^2)" This works fine. But, as soon...

I've been beating myself silly trying to figure this out on my own, but it's just not happening. I'm creating a database form that will store company address information. It has a combobox control whose list parameter is loaded by the contents of a query so that, if a company is selected that...

Question for anyone out there... I have a query that has been working like a champ for several months. But, suddenly last week, it stopped, giving me an Incorrect or Too Complex error (#3071). I've narrowed it down to one field that is causing the problem; a formula that takes a date, breaks...

Well, this is a weird one. I created a database for another group to track employee probation reports. Whenever an employee is promoted, they get a new probation in the new position and relevant data is tracked. If an existing employee's data changes, the clerk would just select filter by...

Another problem has thrust its ugly head into my personal universe. I have a report to make that is to show a break down of employees hired in each month since Oct. '05 and to show what percentage of the total for that month remain. I have created one query that grabs each of the relevant...

OK, this is a stumper. I'm trying to determine if an employee changed departments in 2007. We maintain a table that records every time an employee transfers, giving an effective date of the change. But, this table also records transferring to a different shift without a department change. So...

Hello, group! Does anyone have a painless way to do modulos in a query? Either in the Expression Builder or the criteria, either will work for me. Thanx!

If there is such an animal... My employer uses a third party employee tracking system and I do back end work to massage the raw data for ad hoc reports using tables created by this third party software. Is there a simple means to have a query compare Table A and Table B where Table A is a list...

Is it possible to have a query retrieve all information from one table, but only partial information from another? For example, suppose I have two tables, Jobs and Employees. The Jobs table is a list of all available jobs in the company; some filled, some not. Each job is assigned a Job Number...

Is there a way to label a parameter in a query? I need to enter a start date for a query - the parameter - and the end date is always six months later. Currently, I use; Between [Enter Start date:] And [Enter End date:], but this is not idiot-proofed. How can I make the second parameter be a...

So, I've gotten my query to Sum a field according to Group By criteria. Simple enough, now that I've seen how it's done. But, the summed data is not part of a table, it's a calculated value, like this; SELECT [Light Duty].ID, [Light Duty].lname, [Light Duty].fname, [Light Duty].empno, [Light...

Is it possible to use the result from a calculation in a query as data for a field in the table the query is based on? Basically, I have an event that has a start date and an end date. The table stores individual events and the query only shows those events that have a start date but nio end...

I know that it is bad form to store a calculated field in a table - normalization and all that - but I can see no other way around a need that I have. I'm trying to make a database to store injury time for employees. If an employee is injured, he can do light work for a certain amount of time...

I'm having a problem wrapping my noggin around a probably very simple problem. I have a form for entering data on performance reviews. But, I don't want a new record for every entry. So, I figure I would do a query on the Employee # that would; Populate common fields on the form - and...

I am befumped and befuddled. I have a table with bunches o' records of employee data. Employees move between various departments often and a tenure of how long they were in their latest department is needed. Unfortunately, every move and change in a department is kept in this table. For...

I was using Excel to maintain a db of PCs that my company had converted to VoIP. We have a multi-floored building where each floor is separated into separate areas. The report for that building was a worksheet that had a cell assigned to each area. To get the count for each area, I did a...