Search results

Works like a charm, folks. As always, y'all are the best. Thanks BeckieO

Morning! I have a column in a query set up as: DateFormula: Month([Test Date]) Table and Sort are left blank Criteria is Month(Date()) I was expecting to get records from the current month (Jan 2007). What I'm actually getting are records from ANY January (2004, or 2006 etc). Any idea...

You Got It!! Yup, Access just does what we tell it to. That's the thing that makes me the maddest about Access--every now and then it forces me to realize that logic is not my strongest suit. (hehehe) Thanks so much for getting back to me so quickly, BeckieO

I've found several threads on this subject, but I still can't get it to work, so please forgive me if I seem to be duplicating a question. I'm making a very simple db. It has only 2 tables: MATERIAL (one) TEST RESULTS (many) with left join. I need to report average test results (by...

Thanks, Ken! I actually looked at the relationships, and recognized the one-to-many, but lost that train of thought. Major senior moment, I guess. Thanks for turning me back around. Froggiebeckie

Hi all!! I've inherited a new db that was created by folks fresh out of school. I've been looking through it, checking to see how they built it, trying to scope out any neat and nifty new tricks they've used, before something goes wrong and I have to work on it. They have a table that displays...

Never Mind Sorry, turns out the SS no field in the subform had a calculated value, instead of a link. Not sure how that happened, but that was the problem. Thanks to all, anyway, BeckieO

Greetings, all. Run into a snag with a payroll db, appreciate any help you can give me. Main Form, with ordinary payroll/personnel info--clock no, first and last names, S.S.no., etc. Subform for entering regular hours worked, OT hours worked, etc per Period Ending, keyed to main form by SS no...

You hit the nail right on the head. Problem solved, again. As always, you folks are the best. Thanks BeckieO

Need a second opinion on this one, if someone has the time. The boss is asking me about this: Small db to track keys issued to individuals. 2 tables: #1. ID, (with auto numbering for ID,) and basic name, SS #, etc. #2. ID and Key number, Date Issued, etc, without auto numbering. 1 to many...

Bless Ya'll for the quick response--looks like I'm finally on the right track. Thanks again, BeckieO

Hi there! I'm struggling with a query problem. I have 2 tables, called PRODUCTION and ALLOCATION. I have a query based on Product Type, and date. The query works fine, as long as both tables have records for the Product Type within the date range. If only one table has a record, I get no...

Thanks for the quick response--I'll check out normalization.

I've run several searches and can't seem to find what I'm looking for, so here goes: Have a table with several (maybe as many as 30) dates related to each employee, such as: NAME-------CLASS 1-----CLASS 2----CLASS 3 J.Johnson.....10/16/05 ......12/17/05...12/25/05...

Sorry, forgot to say: If no activity, then there are no data records. Need to know how to create them, I guess.

Greetings: I'm trying to replace a huge, ugly,hard to manage Excel spreadsheet with a data base.--save a lot of sweat, tears and foul language and virtually eliminate errors caused by re-entering figures several times. Great Plan, right? Problem is, I'm stumped. So far, I've got: Make table...

Oh boy, sometimes I'm so dense. Changed the " to a ' and reordered it and it gives me the number of the week. WeekNO: Format([Date],'ww'). Thanks, now I can move forward and have it give the end of week date. Thanks again, Froggiebeckie

I must be missing something. WeekNo: Format("ww",[DATE]) That just returns "ww" in that field. FroggieBeckie

I've got a table with data from 3 machines. I've got queries with calculated fields that return the needed info, totaled by day or month or year. So far, so good. Now, the powers-that-be want a trend chart showing numbers by week, for the current year. To save myself, I can't figure out how...

Found It! Thanks for the suggestion, but I couldn't get the "Send Object" to send all 5 reports at once. My folks don't want to open 5 extra messages every day, so I was still stuck. Then, while talking it out with a friend (who knows even less than I do about Access) he asked "Could you have...