Recent content by wgma

  1. W

    Group By problem

    Yes, it runs.
  2. W

    Group By problem

    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?
  3. W

    Group By problem

    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...
  4. W

    Passing parameter from main query to nested query

    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...
  5. W

    Using outer join

    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...
  6. W

    Import and export data

    That worked. Thanks.
  7. W

    code in form is not running

    Thanks for the help
  8. W

    code in form is not running

    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()...
    • wgma
    • Thread
    • Replies: 2
    • Forum: Forms
  9. W

    Import and export data

    The databases will not be on the same network.
  10. W

    Import and export data

    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...
  11. W

    Count of distinct

    That worked. Thanks.
  12. W

    Count of distinct

    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...
  13. W

    HOw to add a module to code

    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...
  14. W

    How to set up a split db for deployment

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

    I need an outer join

    That did it. Thanks.
See more
Top Bottom