Recent content by ckirmser

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

Hmm. Well, what I'm doing is just slapping together a little contact log from which I can pull up contacts made during certain periods for a report. A report that I haven't tackled, yet. What I've got is a single table that has a record for each contact and its details and I may make more than...

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

Thanx! Maybe it was just some fluke of CDate. Maybe the current dataset had just the right combination of values, number of records, whatever else, to cause it to flop in that instance.

Well, the DateAdd works wonderfully. Of course, I knew about it all along - yeah, that's th' ticket... I thought it might be the data, so I ran the query using a dataset that worked previously. It still failed. But, I figure, if it's bad data, it'd fail the DateAdd function, too, and it didn't...

Danke, boblarson and wazz. That'll make my query less complex, but it wasn't too complex for the system until last Tuesday. D'ya have any ideas on why it suddenly stopped working?

Well, sure, fine, be that way... Never thought of that, so I'll try it. But, the problem I'm having might be indicative of something more fundamental going wrong. I shouldn't be getting that error, yet I am. It makes me wonder, what other functions might go south...

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

Nope. I tried that, too. I tried to input a duplicate Emp # record and it bounced it since it duplicated an existing one. So far, the table only has 813 records, so it's not very big. Even if I enter a totally fictional employee, the data is accepted and appears as it should on the table, but...

Yup. Mainly because there are no required fields. It's a very simple little database. A whole one table and just a few forms for adding/editing records and report preferences.

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

This problem has raised its ugly head again, so I'm a-giving this a bump... Any help out there?

Xnaht, namliam! I'll give that a try and see how it works...

So, is there no way to perform a calculation using data from two different records in a query?

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