Search results

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

Thanx, KeithG! That fit the bill perfectly. I've been dumping both tables into Excel and massaging the data with VLOOKUP to get the final output and decided that if Excel could do it, then Access could; I just had to find the way. This was the way. And, I didn't need Yellowbook.com...

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

Query by form. I should have thought of that. Heck, the dialog that comes up by a parameter query is just a kind of form, only automated by Access... Danke!

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

Many thanx, Goh! I'll give that a try...

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

Thanx, doc man. I figured a search would have been good, but I didn't have a clue on what terms to use. I'm pretty much self-taught Access and don't have the jargon down properly. Now, I have the jargon and I can refine my searches a lot better. I thought of using the queries and recalculating...

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

Actually, no. The injury itself is not important, only that one was injured. I have added a field, an ID number assigned to a record when the very first light work assignment is made, but nothing else. I had thought of some sort of complex query search tying together the ID, date of injury and...

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 thought of that, and might have to go that route, but I was hoping for something like using the OnChange Event of the text box where the Emp No. is entered. I was thinking of something along the lines of a dynamic search that would populate the fields as soon as the Emp No. was entered or...

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

Thanx for the response, moniker, but that's not quite it. Your initial table is a good representation of the data, but what I have to determine is what Bob's tenure is in his most recent department, regardless of shift, but not total tenure; only that since he was last assigned to it. I didn't...

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

Many thanx, guys! The DCount did it. Ah gots mah report! 'Course, it doesn't look quite as good as the Excel one (smaller selection of line styles), but the data is where it should be and displaying the right amounts. Now, my boss will have to put away his guillotine for another time...

Len - Going by what you posted, my table is normalized. The main table is actually a query that pulls together data from a number of sub-tables that contain data that was originally all part of the same Excel sheet. So, the location data is consistent. I think I already have a count query that...

Pat - Normalized? Hmm, when I imported the spreadsheet, it did ask me if I wanted the baseline table broken up into a number of smaller tables to minimize errors for fields that have similar values. Is that what you mean? The end result of those smaller tables being grouped together is that it...

Len - I have one table that is, essentially, an inventory list of those PCs converted to VoIP. My employer has about 200 locations city-wide, with 108 of those within one, multi-storied building; 9 floors with each floor divided into 12 areas. My Excel sheet handled it admirably by using the...

Thanx, Len. I thought of that, but it wouldn't look as nice as my Excel page. I've got 108 different areas to account for and that would be 108 sub-reports. I don't know if Access would belch or not with 108 different sub-reports, but I guess I can try it later on and find out. If there were a...