Search results

Yes, it runs.

I have tried putting the expression into the group by but I get an ODBC error. ODBC--call failed. Argument 1 of function SUBSTRING not valid. (#-171) Any suggestions?

I need to run the query below: ELECT WGMAHIST_TIMEDTY.TDYPT, MID(WGMAHIST_TIMEDTY.TDYTDT,1,4) AS Year, SUM(WGMAHIST_TIMEDTY.TDYFND) AS TotHrs FROM WGMAHIST_TIMEDTY Where WGMAHIST_TIMEDTY.TDYTDT Between 19981001 AND 20090930 Group By WGMAHIST_TIMEDTY.TDYPT, Year But I am having a problem with...

I have a SQL statement that I need to get working. I have a query within a query. How do I pass the ssn from one query to the other? Thanks. SELECT WGMAHIST_TIMEDTY.TDYSSN AS SSN, WGMAHIST_TIMEDTY.TDYLCL, WGMAPROD_EMPLOYM.EMP1ST, WGMAPROD_EMPLOYM.EMPMID, WGMAPROD_EMPLOYM.EMPLST...

I am using Access 2007. I have 2 queries, q1 and q2, that return similar data just different date ranges. I need to be able to get all of the records in q2 that are not in q1. I tried to use an outer join but that didn't work. How can I do this? I have tried Select q2.* From q2 Where q2.a...

That worked. Thanks.

Thanks for the help

I have a very simple form that has one button. All I want it to do is export some data. Here is the code that I have: Private Sub Command3_Click() DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "qyrEmployeeExport", "c:\EmployeeExport.xls" End Sub Private Sub Form_Load()...

The databases will not be on the same network.

I have 2 access databases that I need to share data between. In DB1 I need to export data. I have created a query that will get me the data that I need to export. Is there a way to do this automatically like in SQL Server's DTS packages or can I create a button that will fire off the export...

That worked. Thanks.

I should be able to do this but I my brain went home. I have a table that has the following columns: WorkerID JobCode WorkDate I need to get the number of workers for each job code within a given date range. I need the display format to look something like this: JobCode NumberOfWorkers...

I was given a module from a member of this forum. Now I need to know how to add that module to my project and how to use it. The module checks to see if the links to the BE are in tact. I was thinking that I should put it in a splash screen so that once the app starts the links will be checked...

That looks good. Now for the stupid question, I am not an Access developer so how do I use it?

That did it. Thanks.

I have two queries that return similar data except one of the queries returns data over an expanded date range. Q1 returns data from 2004 to 2007 Q2 returns data from 2004 to 2008 I need to be able to only return those records from Q2 that do not exist in Q1. How can I do that? Thanks.

I have a split db application that I need to deploy to multiple machines. The trick is that the BE is not going to be on a server. Each machhine will be a stand alone environment. How can I setup the links to the tables so that when I install on a machine I won't have to change the links? For...

Thanks, I will give it a try.

I am using Access 2007 to create an application. I have done the work and created an Accdb and installed it on a test computer. When I start the application nothing comes up. How can I set one of the forms so that when the application is started it will bring it up? Thanks.

I have created a db that I need to distribute. When I installed it on a user's pc there was no form to come up. How do I set the initial form? Thanks.