Search results for query: *

I am trying to set the default value of a combobox in a form to be the previous record's value. I used the following code under the Got Focus Event with numeric fields and it worked just fine. Me.numeric_field.DefaultValue = Me.numeric-field.Value But when I try to set the default value of...

really it's by week ending date. so my preference would be to group records in columns by week ending date. For example, if i had the last 3 days of june at the beginning of the week, the week ending date would actually be a july date. But I still need it grouped with the month of june...

I have a report where I want detail records to be grouped horizontally (in columns) by week ending date. For example, if an employee works hours at different jobs during a month, I want to have the employee name in the header, and then 4 columns of total hours representing each week of that...

I have a table where each record has a defining field WEEK_ENDING_DATE. Then I have a field for each day of the week in that same record (M, T, W and so on) Each day field is for entering the number of hours a person has worked that day in that week. Now I need to calculate the number of hours...

Thanks everybody. PHV's language worked!

I need to find the number of hours in a range of time. I then need to add the hours to get the total hours for each person. Right now I have [endtime] - [starttime] which gives me the range of hours in hours and minutes, like 4:30 for 4 hours and 30 minutes. My problem is that I can't add the...

That string is still just excluding the first record in the query...i'm stumped. But thanks!

Availability is my main report. The subreport that should show all employee id's (volno) not in the main report is based on the following SQL SELECT [volunteers].[volno] FROM volunteers WHERE ((Not ([volunteers].[volno])=[Reports]![availability]![volno])); If I put the subreport under detail...

I have a query that returns a set of employee records. I'm trying to create another query that returns all employees NOT in the previous query. My problem is that the second query excludes just the first employee in the previous and not the rest. Can anyone help?

I have a report that shows employee assignments by the hour. Each record under the hour header has a person's ID no., assignment, a start time and end time. Now, under the hour footer, I would like to show a subreport that lists all people from the employee table not listed under that hour. I...