Search results

:eek:I have a query built off of a table and subtable. the report that is generated worked fine until I added another field from another subtable. The new field shows "visitors" there can be up to four visitors at a time recording info. Now, the query shows four identical entries for...

Hello GURU's, I have a report that displays information on visitors to a work site. The report sorts by the "visitor" field of a query. My boss now wants me to add 3 more visitor fields. How would I (in a query or report) allow the "visitor", "Visitor_1"... fields to work on my report...

I placed a button on my form to copy the previous record. It works but does not copy the subform info. Is there a way to copy the previous record plus subform at the same time with one click and place in a new form? Thanks in advance GURU's:eek:

ok, How do I do it? - Thanks

I would like to clear a check box on a form. i have a check box that is activated manually when I have an "action item" on my form. when an employee clears an "action item" a date is entered in the date cleared box. I would like the check box to automatically clear when a date is entered in...

Still does not work The second example you sent worked great. I just want to get rid of the training records that have been done. example, I have 115 teams that require training. I have 85 training modules. I know that our vision team has missed only 3 trainings, yet, I still have 85 records...

:cool::cool:I have a query that shows me my crewmembers training records. thanks to Tiro Cupidus and Khawmar for the help on that! This query displays the dates that the training was done and using an iif statement, shows me the trainings with no dates resulting in a "Not Performed" statement...

Thank you I have used your example to build a query that does what your example can do. Can the query (per your example) be set just to show what training was not done instead of all the training with not done highlighted? As of now my report is over 400 pages long!

the material is in different tables that are pulled together. Basically I am looking for a way to find something that is not there. For instance, if training records 1-10 should have been completed by this date I would like t make a query that shows me employee x did not do training 3. I have a...

I would like to query a database that we keep our training records in. the data kept in this DB is the name of department, the training and the date I would like to query on the department and training that was not performed for instance, our training records are 1-50. If someone did not do...

I need to graph a count of certian items in my database. I have built a query that shows all of the complaints that are sent to my department. there are 10 catagories. How do I create a graph on a report?

I have a database that has 8000 entries in it. I want to strip the material out of it at the end of the quarter and save it somewhere. I could basically make a copy of the whole database and strip the original down. What i would like to do is have some type of query where I basically hit a...

Hi, One of my reports has glitched. I have lost all of the lines (format) in it. All of the text is there but my lines have disappeared. none of my other reports have done this before. Any help would be appreciated - Andre'

did not work I did that and all it gives me is a bunch of 1's and 0's. i have attached a XL spread with what I have. I would like this to add up how many of each with the names of what its adding. the yellow column is what I need to add up and possibly report as a graph.....!

Ok, first off, I know I ask alot of questions, but you guys always help me out. This is my issue. I have a query that list items in a "concerns" block. when this query runs, it works fine. There are multiple returns, for example I have housekeeping return 7 times and I have safety return 4...

Thanks for the reply, but, I cannot post the DB as it is 10mb so far. I have a report that generates from a querie that looks at concerns that are found during an audit. The concerns are pulled from a preset list. the report generates the list of concerns as stated before. I used the chart...

I would like to create a report from one of my existing queries. I would like this report to have a pie chart on it showing results from a field called concerns in the querie. I would like the chart to break down the amount of each concern listed i.e. 4 of this 3 of that 5 of those etc. i use...

ok, one more time and I will quit bothering you! This is what you sent =IIf(DateAdd("d",30,[YourDateFieldHere])<Date(),"DRILL BEHIND","") The date of the report is placed in by hand, it is in a field called "mainDate" I want to compare the fire drill "last fire drill" field to the "mainDate"...

hi, I am comparing between two different date fiels, not todays date. One is the date of inspection and the other is the date of drills. I used the following =DateDiff("d",[Date],[Last Fire Drill]) This gives me a number as a negative. I would like the answer to be blank unless it is over 30...

Thanks Bob - One more if you do not mind! You are always a great help and I have learned much from you. One thing I have problems with and I have still not figured it out. I have a date box on a form. I would like to place an unbound box on a form with a formula to look at that date box and...