Search results

Hi, I have a record that has contact name, update combobox, date, and 2 number fields. What i am trying to achive is when I go to update a record instead of changing all the information I would like to select the record and create a new record with all the information except the date and update...

Gootz11, Thanks for the information, but How can I get the added totals. If I do a querie of let say 07/28/02, 07/29/02 and 07/30/02 I need to know the grand total for these three days. in other words How do I get it to add all three of them and give me one sum. Thank you in advance Al

Hi, I have a form that has two field that have sale amounts on them. My employee puts the sale amount in every day after the day is over. I would like to make a querie so that i can get the total sales amount from let say three days or even a week. I have tried everything but no luck. Thank you...

Miss Anna That did the trick. It works fine with that criteria. Thank you very much Al

I have a form that has a date field that has to dates (example: mm/dd/yyyy - mm/dd/yyyy) I made a report for this form using a query. Here is my problem I am trying to print the report but if there is 10 records 10 reports print out. I need to set a criteria in the query that when a person hits...

Hello, I have created a form with a subform where shift supervisors and employess enter information throughout the day. There is in the main form it has a date field and supervisor field. The subform has time field and data entry field. I created a query and made a report with that query. Here...

Aqif, I found the problem why it would not show any input in the query becuase I had both tables linked. Now my other question is how do I get the report to show just the shift supervisor once vice all the time next to the entry. Thanks in advance Al

Aqif, I tried making a query with the information but it comes up blank. any ideas Thanks Al

Hello, I am trying to create a report for a form. When I create a report I get blanks. I have two tables. Table 1 has the following field names: Date, Section supervisor, and section employess. Table 1 is used for the main form. Table 2 has the following field names: Time, data entry. Table 2 is...

Hello, I am trying to create a report for a form. When I create a report I get blanks. I have two tables. Table 1 has the following field names: Date, Section supervisor, and section employess. Table 1 is used for the main form. Table 2 has the following field names: Time, data entry. Table 2 is...

Pete, the line behind the command button reads: DoCmd.OpenReport stDocName, acNormal I changed it to DoCmd.PrintOut acSelection it will print out the form not the report. Thanks in advance Al

Hello All, I am trying to print a Report from Form where the Form was built by a Query. I set up the command button on the form and I get all the records on the form. I just want to print the opened form. Thanks in Advance Al

Hello. I have a print problem I made a query, then built a form with the information of the query and made a report for the query. Now this is where my problem starts I put a print commad button on the form so I can print the form but I end up with all the records printed in form view. How do I...