Search results

Field Name The name of the field is "Last Fire Drill". I did change it in the example and it still does not work. - Thanks in advance. PS It is little stuff like this that drives me batty!:eek:

nope I see what you are trying to do and it makes sense. I am still getting a #Name? error. :)

Still not working Sorry, but I do not follow. I am comparing a field named "fire drill" to the "date" field. If the "fire drill" field is more than 31 days old, I want a response of Drill required to pop up. If it is in the 31 day window from the "Fire drill" date, I want the response to stay...

I am trying to write a formula to stick in a form that gives the result of a date. Basically what I would like to do is use a statement (IF?) to figure out if a date is over 31 days old. As an example please follow below. fire drill 01/01/07 DRILL PAST fire drill 10/01/07 DRILL IN RANGE I am...

I have a report that takes data from a query. It sorts by person and looks at the training by number. How do I create a report to look like an excel spread based on person and then the data points in the spreadsheet?

Here Is The Sql SELECT jsamain.ID, jsamain.company, jsamain.vesselname, jsamain.workactivity, jsamain.worklocation, jsamain.datetime, jsamain.comments, [main body].[Identify Work Activities], [main body].[Identify Potential Hazards], [main body].[Precautions to Reduce Hazards]...

I have made a database and have made a query that takes the info from the tables and creates a report. I have a subtable in the form and have added another sub table. When I try to add the new subtable info into the query for the report, I get "ambigous outer joins"??? What the heck is that?????

Hi, I built a database that my report runs from a query. I added 9 lines to my table, added them to my query but they do not show up in my field list of my report. How do I get them to show up in my field list???????

I would like to build a query and ask it to choose a boat name out of a list of pre set names. When the pop up box appears to type the name, i would like it to be a combo box where the name can be pulled from the list. can this be done? thanks in advance. - Andre'

GOT IT ! Thanks for all the help ! Andre'

hmmmm.... I think I see what you mean. My course dates are per years. So, I would substitute the "ww" with "yyyy". And where would I put the text "out of Compliace" in the formula. Sorry if I sound stupid, I'm sort of a beginner. Thanks for everything Andre'

Thanks Wayne, Thanks, Still having no luck. I'll try the new one. Andre'

So you are saying That I would have to add another item to my training table for "cert info". Such as PSST training is good for 3 years. after that you would need to take it again. Now, I use a query to generate the report showing the type of training, persons name and date of training. I...

Trying to figure this one out!!!!! I have a pull down menu on a form that runs a querie to choose a type of training and prints a report sorted by training showing employees and the date they took the training. On the report, I want to add a text box that shows if the selected training is...

Question #1 I have a database that tracks training of contract employees. The way we enter the information as of now is to pull up a record on an individual employee and add the type of training into his subform. This updates his record. With over 100 employees, this coulbe be a very long...

Hi, I have a form with five choices that are yes/no check boxes. These pertain to classes that an employee has taken. When I check a box, I would like a field to open where I can enter a date that the class was taken. Can this be done?? thanks in advance, Andre'

Ok, I have a form that has a date, a memo box to put daily notes and a subform that contains a list of employees. using a query, I pick a certian employees name and any note that is linked to the chosen employee is placed on a report. I thought this is what the boss wanted, but, as usual...

Thanks Rich You are always giving helpful answers you are the GURU of Access !

To me it sounds like Either, The actual computer is causing the problems, or, the version of the file you are using on that computer is not the same as on the others. If it happens periodically, it sounds like maybe a memory problem. Try it without anything else open. Sorry i can't help...

hi, Can you set up a field on a report to automatically enlarge with the amount of information from a form? I have a memo field on a form to keep track of daily duties. some days may have more information than others. When I print my report, the short days show up with all the information...