Search results

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

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()...

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

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

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

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.

I have two queries. One returns a list of numbers and I would like the other one to use that list in the where statement. Here is the query SELECT WGMAHIST_TIMEDTY.TDYSSN, WGMAHIST_TIMEDTY.TDYLCL, WGMAPROD_EMPLOYM.EMP1ST, WGMAPROD_EMPLOYM.EMPMID, WGMAPROD_EMPLOYM.EMPLST...

I have created a report that has a header (based on qryHeader) and a subreport (based on qryDetail). I think that my problem is that the two queries are not related because the subreport is not showing up so I assume that it is not being initialized. I need to create a master/detail report...

I am creating a report that gets some of its data from a form. One of the items that I need from the form is the text contained in a combo box. All I need is the text that is displayed in the combo box. I have tried some different things but just get errors. I have searched this forum but have...

I have a form that is used for data entry.Once the data has been entered the user can click a button at the bottom of the screen that will print reports. One of the reports is based on a query that takes 2 parameters. When I run the report I get an error saying "You can't reference a property of...

I have a query that I need to group by the year of a date that is stored as a string , i.e. 20080630. SELECT WGMAHIST_TIMEDTY.TDYLCL, WGMAHIST_TIMEDTY.TDYTDT, sum(WGMAHIST_TIMEDTY.TDYFND) AS Hrs FROM WGMAHIST_TIMEDTY WHERE WGMAHIST_TIMEDTY.TDYSSN=123456789 group by WGMAHIST_TIMEDTY.TDYTDT...

I have 3 forms that I use in my Access 2007 database. the first form is for data entry, the second form is an invoice which allows edits, and the third form displays the charges and only has one column and may have multiple records. The third form is a sub form and is used on both of the first...

I have an unbound textbox and a subform on a form. The subform is attached to a table that contains a field that holds charge amounts. When the main form is displayed the subform will display all charges that are associated with the main record. Below the subform I have a "Total" in a textbox...

I have a form that has a combo box called Shipper. There are 3 columns in the combo box, ShipperID, ShipperName, ShipperAddress. When a user selects an item in the dropdown then there is a textbox below that gets the address filled in from on the combo box. I have created a report based on...

I have been given the task of creating an application that will print invoices for a client. They want to be able to enter in the info, save it, and then print just that invoice. I have created the input screen and the invoice report. However, when I try to print the report I get a printout...