Search results

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

Sorry you feel that way, But on the other hand it seems that you are so anti-religion that you're doing the same thing in the name of your beliefs. He started out with a good ministry, ended up flat in the mud. I'm in no way defending his later actions just saying he started out on the right path.

Just a quick update, I have a table built for each tier and now I'm trying to figure out how to quiery each of them. Thanks, Tim

I think you're getting what I'm saying. I'll try to elaborate tier one- Tier two- AB through SSgt (Ranks) TSgt though CMSgt and officers (Ranks) A set of specific tasks A different set of tasks So what I would like based upon the...

I think if it was one task then that would work, unfortunatly there are about six tasks associated with each tier. Thanks for the idea, tim

Good day all. A bit of back ground, I've built a data base (with much help from the folks here) to track the training of my people. Someone way higher then me has decided to completely revamp our field training. There are now two "tiers" based on rank and training level. My first thought is to...