Search results

You tried to excute a query that does not include the specifed expression "date" as part of the aggerate function , this is the error message i get when i write an expression. SELECT Time.DATE, Time.[Task (SCC)], Time.[REG HRS], Time.[OVER TIME], Sum([reg hrs]+[overtime]) AS Expr1 FROM [Time]...

Sounds easy right... But i am writing a query that need to have either the sum of a day or the sum of a week. here is the problems sometimes a day might have more than one entry. DATE REG HRS OVER TIME Task (SCC) 3/1/2004 8 2.5 1 3/1/2004 8 3...

Even if I copy and paste that in there I get an error message. Contains invalid syntax.

I have several sums I need to add together to get a total sum of hours in a text box. Only thing is that some of the sums are null(0)and when that happens i only get a blank in total hours. =Sum([reg hrs])+Sum([ANN)])+Sum([SICK])+Sum([OTHER LEAVE])+Sum([OVER TIME] What do I need to do.. Thank...

I just a problem with that also, Thank you Also Joe

Sounds good but um what do i need to do? Thanks Joe Edit ... Could i do this use the run macro , macro and do a requery to my append query?

I feel like an idiot , but thank you for ya'lls help. Here is what the problem was, I had the form on a switch board in Add mode and it needed to be in edit mode. Cause I guess in Add mode it would not search the table for the info. Thank you Joe

It is saying No Match found now. So where do i go from here? Thank you, Joe

New error message now Compile error: Method or data member not found The first line is highlighted also, if that helps Private Sub Combo36_AfterUpdate() ' Find the record that matches the control. Dim rs As Recordset Set rs = Me.Recordset.Clone rs.FindFirst "[NSN] = '" &...

Here is the deal. I used to have this form and table as a separte database and I consolidated it into a another database. Now when I open up the form and us the combo box I get a run time error 3021 saying no current record found. Here is the script on the combo box. Private Sub...

Right now I have an append Query setup to add users , there hours and date into a table. I am curious is there a way to do this automated, like it adds it to the table every day with out having to run the query. Any info on how or where to look at would be great. Joe

Thanks for the help. Question for you, What does the nz stand for. Joe

Yes i tried it but it did not work. Here is what works. just incase someone has that problem. =sum([item1])+sum([item2])+([item3]) Joe

How would you do this with 3 things?? I need a total of hours. I have 3 items that need to be calculated. =sum([item 1]+[item 2]+[item 3]) Is that right?

is there a way to make it print with out having to put in the last name. A box jumps up and you have to type the name, would like it just to print that record when I am on it and hit print. Without having to type in last name. Thanks Joe

I have to make a report that will print for each user that i have in my database. It is there timesheets. I want to be able to hit a button and print the reports one user per sheet. How do I make it print one user and the info associated with that user per page? Joe

I have a field for the date, I just figured out the julian date and how it works now I want to update all colum for julian date against the column with the date in it. Do I need to make a query? Thank you, Joe

I have copy and pasted a excel sheet into a report and I want to be able to pull in dates and have them populate areas of the sheet. My question is there will be 14 dates with information in each date. What would be the easiest way to do this. Should I make a footer or something like that with...

Thank you,

I want to build a query that when I put in a date like today for example it will go back 2 weeks and list all the infom from a table. any ideas