Search results for query: *

When I put in your code I get microsoft access can't represent the join expression a.site_number = b.site-number in design view. one or more fields may have been deleted or renamed the name of one or more fields or tables specified in the join expression may be misspelled the join may use and...

With that code I get Syntax error (missing operator) in query expression 'site_number='

SELECT tblSites.EmpId, tblSites.SiteNumber, tblSites.EmpName, tblSites.AddressId, tblSSS.sov_trips_percent, tblSSS.sov_miles_percent, tblSSS.site_program_year FROM tblSites INNER JOIN tblSSS ON tblSites.EmpId = tblSSS.emp_id WHERE...

PHV when I enter this code it asks for a parameter value for each field. I want it to find the highest program year # for each site.

site number and site program year are in tblsss and site number is in tblsites

I see what you are talking about now. I thought it would be much simpler than this sorry for my ignorance. I have two tables joined by site number and emp id, IN tblSites I have The fields I want to include in my query are EMpID tblSites Site_Number tblsss EmpName tblsites SiteName tblsites...

I am trying to run create a query that will pull the highest site program year for each site number. I have created a query with all the fields that I need and just need to build a expression to pull the highest site program year from each site number.

Using MaxYear: DMAX("site_program_year","tblsss","site_number=" & [Site_Program_Year]) I get an invalid . or! operator or invalid parentheses error

It is a query and site number is numeric.

I am trying to find the highest value I have a site_number and a site_program_year. I need to find the highest site program year for each site number. I was told to use this DMAX("site_program_year","tblsss","site_number=" & "****")but all this is doing is pulling up the highest site program...

I did this and it is giving me the max number for all my sites. I have another field site_number I want to pull the highest program year for each site. They are both in the same table. Is this possible??

I need to create an expression that will allow me to pull largest value from field in a table. Can someone help me The field name is site_program_year and the table is tblsss. Thanks!

Private Sub Combo16_AfterUpdate() If Me.Combo16 = "Completed" Then Me.Date_Closed = Date End If End Sub Dim rst As Recordset Set rst = Me.RecordsetClone rst.Delete Me.Requery This isn't working, did I do something wrong?

Hello, I have created a delete selection in my combo box on my form. When I choose delete from the dropdown from the combo box in the form the job from both the table and the form should be gone. Here is what I have thus far: Private Sub Combo16_CmdOk() If Me.Combo16 = "Delete" Then...

I have this as my code Private Sub Combo16_AfterUpdate() If Me.Combo16 = "Completed" Then Me.Date_Closed = Date End If End Sub I have a form set up so that when a user selects "Completed that job dissapears from the form but is still in the table. However I have jobs that are completed but will...

I made the box bound and added a corresponding field to the forms underlying query but now I am getting this error: "The OLE object is empty. you can't edit a bound object frame if the field in the underlying table doesn't contain an OLE object. Embed or link an OLE object into the bound object...

I can type into it in design view but I want the user to be able to type in a job for each record in the form view.

How do I make the bound box able to enter text.

So do I have to make it bound and link it to something?

All information I type in on my 1st Record in an Unbound text box is repeating on all of the other records in my form. I am trying to create a different job on each page and in the unbound text box I would like to enter a description of the job. So each record needs to stay empty until I write...