Recent content by chef_tim

Not sure if it was a fluke of perhaps a security setting, but when I got back to billiting the computer in my room opened them right up. Thanks for the help, Tim

I put my DB on a thumb drive to take on a deployment. It was working when I checked some data the other night but now I can only open one report out of apx 20 reports. It will not open in preview and I also can not create a new report. Any ideas?????? Thanks, Tim

I think I may have gone about this a bit back wards, but what I did was put [date trained dd-mmm-yy] in the "update to" box on my quiery. When I click on my run update quiery command button it prompts me for the date. I just wish that I could use an input mask on it to only accept dates in the...

Bump, still looking for help. Thanks, tim

Thanks Neil, but could you give me a few more details? I didn't understand a thing you wrote....LOL. I'm not the brightest star in the sky with this stuff:D . Thanks again, Tim

G'day, I'm trying to replace a date on a table using an update query. I have the criteria set to [enter date] but it won't put it in the update to block. I know this has to be one of those easy one but after a search and using help I can't nail it down. Much appriciated, Tim Guess I should add...

So really not that tough:rolleyes: , I think sometimes I think to much into these things. Thanks for teaching me that criteria, It seems to work like just like what I was looking for. Tim

I will give it a try and get back. Thanks, Tim

G'day. This is a tough one and I could use some help. I work for the military and day to day there are people on orders. My finance folks are providing me with an Excel spreadsheet with all the names and start/finish dates of people on orders and I import that into a table. What I need to do...

I used Riches and it worked, but I'm also going to experiment with the SUM/ABS solution just to get a feel for it. I certainly appriciate the education I'm getting here. Tim

Thanks for all the replies. Mark, I'm sorry I havn't a clue what you're talking about (just way to deep for me), and you're example was password protected. Rich, I used yours but now if you would fill me in on what the ,1,0 do/mean???? I get the rest. Thanks again, Tim

Good day, I've been through pages and pages of searchs on count, sum etc. All I want to do is count the number of "check marks" ie yes on a report. I've tried =count([10kforklift]) I've also been in the help file with no luck at all. Thanks for any help, Tim

I was thinking that I was working with two different types of data. It really isn't importaint to the overal data, I just need to remeber not to re-test them prior to 45 days of recieving a poor score. I took what you reworked and instead of having it in my report I put it into the queiry with...

It is amazing how funny a few spelling errors will make this thing act:eek: That was just what I needed, the dateadd works great. Just as a final note, poor is within 90 days but not before 45 days. Could I do that with >< type of expression??? Thanks very much, Tim

Good morning. I'm trying to build an expression that will give a date to retest on fitness using four criteria Excellent, Good, Marginal, and Poor. I've got a start but it is getting very deep for me. If I could just get a a little help I think I'm close. Here is what I have so far...