Search results

RV and Jon K, Thank you for taking your time to help me out. About the tables structure. The reason I am using both tables, is because the number is jobs that mails on multiple days is few in relationship to the total number of jobs. Of the 1,000 jobs a year, maybe 40 are multiple day jobs...

Thank you for the information, but that was not exactly what I was looking for. I will see if I can explain it better. I need to make a report that shows mailing information for each day. And I have two tables with mailing information. And since some jobs don't mail all in one day, I have...

I am having a problem printing out a report. I need to show the quantity and other information for jobs seperated by day. The only thing is, I have to take the quantity off of two seperate tables. Table 1 - some jobs take more than one day, so it contains the spread of quantity for a job...

I am having a problem printing out a report. I need to show the quantity and other information for jobs seperated by day. The only thing is, I have to take the quantity off of two seperate tables. Table 1 - some jobs take more than one day, so it contains the spread of quantity for a job...

I am having a problem printing out a report. I need to show the quantity and other information for jobs seperated by day. The only thing is, I have to take the quantity off of two seperate tables. Table 1 - some jobs take more than one day, so it contains the spread of quantity for a job...

OK, I am trying to do something really simply. Open a table called "DropByDay", check to see if there are any records that have the same [PacketDetailID] that is on the form. If any records have the same ID, then delete them. Then Append on a few records with the [PacketDetailID], [Amount]...

Thank you. that was it! I could not figure it out for the life of me. THANKS!!! Brian

My problem: I needed to write a macro to check to see if all the required fields are filled in. It gives user friendly errors, not like setting the required property on a table. I set this macro to run "on exit." It is working well for that purpose. The problem I am having, is that if I...

I am working on a project. As an analogy, the data being stored is a book, along with information about each page. The information about each page is the same, but some times not every page is going to exist (weird book huh) The report brings up the book, and has a sub report to repeat that...

I just started working on a complicated database that was handed to me after a few people have worked on it. I need to be able to edit a "Work Order" form. The database allows for it to be created, but not edited. It's created after filling out required information in a "add packets" form...

I just started working on a complicated database that was handed to me after a few people have worked on it. I need to be able to edit a "Work Order" form. The database allows for it to be created, but not edited. It's created after filling out required information in a "add packets" form...