Search results for query: *

I am at a loss on how to develop tables pertaining to a procedure. In my table (we'll call it tblProcedure), I have a Date field, which is never duplicated so it is the primary key. Other fields include: Time, Shift, Auditor. On a particular date, I could have a non-compliance on a Form...

I have created a statement using Not Like, but I am not getting the results that I need. Here's the code: SELECT [tbl7-10Procedure].Date1Status, [tbl7-10Procedure].Date2Status, [tbl7-10Procedure].Date3Status, [tbl7-10Procedure].Date4Status FROM [tbl7-10Procedure] WHERE ((([Date1] & ' ' &...

I am trying to generate numbers on a report for which the user will enter the parameters (i.e. Number: 550 for the first report.....Number: 600 for the last report -->thus printing 50 copies of my report, each with a different sequential number). My report is basically a template. I print the...

I get this message...: This expression is typed incorrectly, or it is too complex to be evaluated...Try simplifying the expression by assigning parts of the expression to variables. ...whenever I run my crosstab query: PARAMETERS [Forms]![frmParameters]![StartDate] DateTime...

The following is my statement: SELECT E.[EmpFile#], E!FName & ' ' & E!MName & ' ' & E!LName AS [Employee Name], E.DeptCode, E.Supervisor, Count(*) AS CountOf21_22_23 FROM tblEmpInfo AS E INNER JOIN tblAbsences AS A ON E.[EmpFile#] = A.[EmpFile#] WHERE (((A.Date_of_Absence)>=Date()-365) AND...

I created a query to list each code and the count of each code between certain date parameters. I created this query using all the fields that I need from 3 different tables: SELECT tblEmpInfo.[EmpFile#], tblAbsences.Code, tblAbsences.Date_of_Absence FROM (tblEmpInfo INNER JOIN tblHireDates ON...

PLEASE...any help will be appreciated on this matter!!!! This is a repost. I have a complicated problem... I am trying to write an SQL statement, but I do not know how to establish the criteria for my statement... Here is the basic information to start with: SELECT tblEmpInfo.[EmpFile#]...

I am trying to group in a report based on date in "mmmm yyyy" format. The original date format is "mm/dd/yyyy". I created a crosstab query to show many times each code occurred during each month (dates are determined by parameters, so the codes are the column headings and the dates are the row...

This was originally posted in the wrong forum..... I need to produce rptOccurCode from frmParameters having combo box cboAbsenceCode. The user selects a code from the combo box and produces the report. This works fine, however, if there are no results to show, I would like a MsgBox to display...

I need to produce rptOccurCode from frmParameters having combo box cboAbsenceCode. The user selects a code from the combo box and produces the report. This works fine, however, if there are no results to show, I would like a MsgBox to display to notify the user that no results were found, and...

I have a complicated problem... I am trying to write an SQL statement, but I do not know how to establish the criteria for my statement... Here is the basic information to start with: SELECT tblEmpInfo.[EmpFile#], tblEmpInfo.LName, tblAbsences.Date_of_Absence, tblAbsences.Code FROM tblEmpInfo...

I have the following query: SELECT tblEmpInfo.[EmpFile#], [tblEmpInfo]![FName] & ' ' & [tblEmpInfo]![MName] & ' ' & [tblEmpInfo]![LName] AS EmpName, tblAbsences.Date_of_Absence, tblAbsences.Code, tblReasonsForAbsences.Reasons_for_Absences, tblAbsences.Action_Taken, tblAbsences.Date_of_Action...

I have created a security form (frmSecurity) which is based on tblSecurity. (tblSecurity lists 3 different passwords.) In frmSecurity, I have an unbound text field (txtPWordInput) with the Input Mask set to Password and nothing in the Control Source. I have another unbound text field...

I have created a security form (frmSecurity) which is based on tblSecurity. (tblSecurity lists 3 different passwords.) In frmSecurity, I have an unbound text field (txtPWordInput) with the Input Mask set to Password and nothing in the Control Source. I have another unbound text field...

I have created a form which is bound to my main table. The primary key is Procedure. The field General is related to the primary key, giving a description of Procedure. In the future, updates will need to be made to the General description of Procedure. However, when these updates are made, a...

What I am trying to accomplish: I need to produce a report which shows the number of incidents which occurred within 2-hour blocks during a 24-hour period. So, just to have a visual... 2-Hour Blocks Procedure # 0000 0200 0400 0600 etc….. 4.1 2 4 6.3 1 5 8.4...

When I run my report (which contains 2 subreports - the main report is just a shell holding the 2 subreports), I am prompted for my parameters. BUT when I print the report, I am prompted again! Is there any way that I can alter my report, queries or parameters to stop this from happening...

I am attempting to add a column using the SUM formula, but Excel gives a total of 0 because I have blank cells in the column. How do I add a column ignoring the blank cells so I can get an accurate total?? Regards, Kim

I have formatted my table to include all 9-digits of a social security #, however, the beginning zeros for some social security #s are not included. How do I format my table to show these hidden zeros?? Regards, Kim

I created a date parameter to basically search for all dates within a certain month. However, the results include dates from the same month but different years (i.e., I need all of Jan 05 dates but not 2004 etc...), which is not what I need. Here is my SQL statements: SELECT [90 Day Review...