Search results for query: *

I found the issue in access I had a query with two tables that were not joined. Is there way to fix that. The two tables don't have any columns that I can join

...with this SELECT Projection.[Day], SUM(datediff('n', Sched.Start, Sched.[End]) / 60) AS Hours, AVG(SalaryRate.Expr3) + SUM(Staff.Rate1 * (datediff('n', Sched.Start, Sched.[End]) / 60)) AS Wage, wage / AVG(Projection.AvgOfPm) * 100 AS Expr1...

nope still not working. im using query builder. i don't know if that matters?

i just tried the code in query builder and the do results show but it still says error in list function arguments: 'LIKE' not recognized. Unable to parse query text

not sure what you mean?

SELECT DISTINCT Staff.Employee, Staff.Rate1, Staff.Rate2, Sched.Type,iif([sched].[type] like 'P', staff.rate2, iif([sched].[type] not like 'P', staff.rate1)) as exp2 FROM (Sched RIGHT OUTER JOIN Staff ON Sched.Employee = Staff.Employee) GROUP BY...

No still get the same error

Oh...Ok sorry the table is called sched not schedule I missed typed it in my post.

That's all I have it's new table adapter I created with two tables from access one table is called sched which has a column named Type the other is called staff which has a column called rate1 and rate2 the table is joined by employee column.

I have an access database back end and I'm trying to use this iif statement iif(schedule.type like '%p%', staff.rate1, staff.rate2). But I keep getting the error that the like statement is not recognized.

jebenson the buttons are added at design time

i tried your code now i get an error Object reference not set to an instance of an object

The error stops at Main.Controls("Button" & T).Text = Me.textbox1.Text

I tried to declare T as Integer then a string but still received the same error. the form name is Main.vb RecordID is a textbox on my Main form Depending on the recordid i would like to go to the corresponding button() and change the text of the Button control. I was able to do this in...

I have multiple buttons( button1, button2, etc and instead of typing repeated code i just want the button to refer to the recordid and then based on that update the text value of the button T=Form.RecordID.Text Main.Controls("Button" & T).Text = Me.textbox1.Text any help would be great...

...to convert code from access to Visual studio dataset query but its not recognizing my LIKE statement SELECT Staff.Deactivate, Staff.Employee, IIf([Position] Like "*O*","Opener") AS [Open], Staff.Rate1, Staff.Rate2, Staff.Salary, Staff.Availability FROM Staff WHERE (((Staff.Deactivate)=False));

...to convert code from access to Visual studio dataset query but its not recognizing my LIKE statement SELECT Staff.Deactivate, Staff.Employee, IIf([Position] Like "*O*","Opener") AS [Open], Staff.Rate1, Staff.Rate2, Staff.Salary, Staff.Availability FROM Staff WHERE (((Staff.Deactivate)=False));

MajP your code works great. Thanks!

the current date. each selection runs a report for that shift

i want to check the weekday and off of that auto select an item in my combobox. Basically if its Wednesday and before 6:30pm then select Wed AM. In my combo list i have: wed am wed pm Thu am Thu pm Fri am Fri pm Sat am Sat pm Sun am Sun pm Mon am Mon pm Tue am Tue pm