Search results

Thanks I will give both a try. I appreciate the help from both of you

Does anyone have any ideas??? I can't figure it out at all. brandon

just create a query, I would probably add a field to your table whether it be a dateprint field or a checkbox or something like that. Then on your form on the click event where you print your label update the date print field of your table ie dateprint = date(which returns todays date). Of...

Thanks for taking time to help me. My problem is not getting the so to filter because i do have a filterring section for my page. The form i have is a data entry form where they can enter a so number and company name and then tab to the subform which is linked to the so number entered...

I am still having problems could anyone help, please

First I think you only need one subform to do what you are asking. The reason you get the errormsgs is because you are trying to open 3 subforms based on the same query. make your main form have the primary key on it and the subform have the rest of the data you require and make the form a...

Thanks for the reply, but I already get it to show everything to do with that so number, by just having the childlink and parent link to the so number of each table. That in turn filters to each item under that so. So i dont know how filtering would help. I will try that though, and again thanks...

I have two tables one that has an so number and company name in it with the so being primary. I also have a table that stores everything that goes with that so number and all the information that goes with it. Ie: piece, datescheduled, size(l x w), and dateshipped. I have a form in which the...

I have a query that figures a weeks worth of hours by days, and then I add those together to get my total for the week. So if i worked 8 hours a day for 5 days, my query will put my hours under the correct day as long as it is within my 7 day parameter of the weekending date. Now I need to...

First I am trying to get a report to print production and non production hours for a month. I have my query giving me the right total as far as that goes, but the way I did it was to have a sum for a week with weekending date. It totals the hours for that week and I did that four times, but I...

I have a lot of trial queries on here so it may be a little jumbled The needing new idea queries are the ones in which I am working with at this moment brandon

Yes i can get totals, but the way i need it formatted is a daily hours under the correct date and then the total for that week. ie: clock 3/1/09 3/2/09 3/3/09 3/4/09 3/5/09 3/6/09 3/7/09 weektot **1111** 8**** 8**** 8**** 8**** 8**** 0*****0**** 40 **1112** 8**** 0**** 8**** 8**** 8****...

You would have to have a variant. The date() returns todays date only. try this: SELECT IOData.CardNo, IOData.IODate, IOData.IOTime, IOData.IOStatus, date1 as variant FROM IOData WHERE date1=iodate brandon

I have two tables: employee and timecard. employee clock(basically employee number we call it clock number) name deptno deptname time card clock based on employee clockin clockout I then have a query(needing new idea) in which i get the total hours worked by the employee. I need to be able...

I have thought about doing this with a loop or even by grouping, but I just cant seem to get the format right. I would apprecaite any suggestions that would be applicable. I have a table that clocks in and out an employee. I then query to figure the total for that day. I want to be able to...

weekly employee hours report by days please help!!!!!!!!!!! First I have not programmed in access for a long time, so please forgive me for my rather simple problem. I have to give my boss a daily hours report for the week. Ie: Employee name dept mon tues wed thurs fri sat sun total john doe...