Search results

I get the error message "Too few parameters. Expected 1"

Here is my current Code. Is there no way to attach the query results to 'strtofield' Private Sub bemail_Click() On Error GoTo Err_bemail_click 'DoCmd.SendObject acSendNoObject, , , Me!txtemailaddress, , , , , True Dim strToField As String Dim strccField As String Dim strSubject As String Dim...

WebGirly, Did you find a way to email directly from the query results? I am trying to do the same thing. Thanks

I got it now...For some reason I didnt need the Nz function. Just the regular ol' Datediff. Thanks for your help SELECT tTimeCards.ValetID, tTimeCards.ValetFirstName, tTimeCards.ValetLastName, DateDiff("n",[timein],[timeout])/60 AS HoursWorked, [HoursWorked]*tValets!HourlyWage AS Expr1...

SELECT tTimeCards.ValetID, Sum(NZ(IIf([timein]<[timeout],DateDiff("n",[timein],[timeout]),1440-DateDiff("n",[timeout],[timein]))/60)) AS HoursWorked, [HoursWorked]*tValets!HourlyWage AS Expr1 FROM tTimeCards;

I get the error "You tried to execute a query that doesn't include blahblah as part of an aggregate function"

It is possible to carry over to the next day, but not more than 24 hours. The timein timeout fields include the date and time. If i just divide by 60 it gives me a decimal number but it's not correct as far as telling the number of hours. (it's a really small number)So far they all come out to...

I have a query that calculates elapsed time from TimeIn and TimeOut formatted to hours and minutes. I need be able to mulitply the elapsed time by the hourly wage in order to find the hourly pay. How do you format the time so that it is compatible to multiply with the wage? My SQL statement is...

VOCupsetlbhr: ([circulation rate (gal/min)]*60*8.34)*((Switch([Results]>5,[results]-5,[results]<5,0))/1000000) This is in the Expression Builder for this field in the query. Basically it looks for results >5, then subtracts 5 from the results and calculates the field based on whatever is left...

Switch Function For anyone intersted I figured out the solution to my problem. By using the "Switch" function.

Below are the SQL Statements for the two queries. Ultimately I need to seperate the 2nd query into Cat1Emissions and Cat2Emissions and sum the VOCperperiod for the year. Cat1Emissions are the sum of vocperperiod <=5 and Cat2Emissions are the sum of vocperperiod over 5ppm. Does this shed any...

My theory is this...in the emissionsperhour query create 2 more expressions which are Cat1lbperhour and Cat2lbperhour. Cat1lbperhour needs to calculate using a maximum of 5 <---5 years??. Cat2lbperhour needs to first look for any results >5, subtract 5, then calculate lbperhour based on the...

I currently have two queries. One calculates emissionsperhour based on a results field and the other calcualtes emissionsperperiod based on the emissionsperhour query and the inspection date. I need to go a little deeper and seperate the emissionsperperiod into two categories. Category 1 will...

Thanks Bob. That did it for me. I appreciate your help.

The button is on the subform. How do I set focus to a control on the main form?

Yep. I'm using the container name.

I have a main form with tabs. On the third tab I have two subforms which are invisible. There are two checkboxes on the mainform. Each checkbox makes one of the two forms visible. When a form becomes visible, data can be added to the form and is put into a table upon clicking the Save button. I...

I'd be interested in finding out how you set up your inspection history side of the database if you have time. Thanks

The problem with your solution is I don't have a field or a table. The textbox is unbound. The values calculated in the avghcppmw textbox don't actually exist anywhere.

Here's the situation. I have a calculated value in an unbound textbox (avghcppmw). I want to run a query (qinsphistory) in which one of the fields is the value of the textbox (avghcppmw). Is there any way to pull the value from the form and display it in the query. I'm assuming not. I also...