Search results

Would the setup change once I have created the fields using Y/N? The 0 would become N or do I keep it as is with the 0

Still receiving the #error my field name where Void, NC, and Scrap are located is called SorNC so my sum formula would be =sum(sorNC([Void],0)) right?

I am requesting some help. I have a database that is going to be linked to excel however, I cannot seem to figure out how to calculate one column total. Example I have one column with Void, NC, Scrap and need a total of each of these to go into the footer. I have followed several examples but...

I have one quick question my subreport is duplicating on the second page of my report. Is there a way to have it only show up once besides creating a separate report?

Ok I wil give it a try otherwise I am going to leave it. It all works now I just need to watch my typing

You were correct I did have a misspelled word in the table. However, I have noticed that if I have a crossed trained employee when I print it it only prints the first record how would I manipulate the report so that the second job title with descriptions will also print under his name. I was...

What does this mean I have made some modifications to a report and now I get this before I am able to view the report Enter in Parameter value tblEmpJobQual.EmpJobQualID it is like a form with the entry box with command options OK and cancel. I am able to get my data in the report but I...

I was on the right track last night. There is light at the end of the tunnel yeah. Thank you so much for all your help.

I was able to figure out what I was doing wrong. I had the query working properly but it wasn't reading the records because there were no records to update. Thanks for your help though.

This above worked with me manually entering in the data into the tblEmpJobs. Since I know that this works this wayI should then create either a new form or button to use it this way. I have created a new form simlilar to the tbleEmpJobs I would create the new button to have it append the qry...

I have been working at this all day I have this database in several areas so that I don't mess up and lose it.

That is how I have it setup. Should there be a new form for the appending query I would say no. I have seen the query that has 2 fields with no blank fields for entry. It only has the headers but yet I copy and pasted everything that was given in a previous message. This is the only part that is...

I would be using the tblJobQual and tblEmpJobs when creating this query. Where is this being appended to? Is it to the tblJobQuals?

I have a form that uses a query to pull data into separate fields for job titles and department. I have created an append query and when I run it it returns with zero records. This append is for those who have more than one job title. Should I create a new form and somehow attach this query...

I still cannot get that query to run. I have tried to create a simple form and have it linked to it but it doesn't work. Any other suggestions?

ok thank you you both have answered my questions

Ok thank you.

If I am not mistaken MS Office 2007 is not compatible with MS 2000 and mixing the two could cause issues in the newer version of 2007

I think that I am going to try my suggestion and see if I cannot get the query to run how it should.

Would it be wise to create another form to go with the append query similar to what you did for the new employees? Reason why I am mentioning this is because eveyrthing is setup and since I need a place to add the data I figured a form would be the most likely way to go.