Search results for query: *

Thanks LesPaul for the document. It actually helped quite a bit. I just needed to step back and approach the design a bit differently. I have been so wrapped up in constructing the tables properly and focusing on the end result that I got tunnel vision and couldn't see how to do it. Thanks...

My field names are actually similar to the ones I listed, but not exactly the same for simplicity purposes. Field names are not my problem; constructing proper relations and number of tables are the problems that I am having. The date and time must be stored differently; they are unrelated to...

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

Remou: Sorry I didn't let you know sooner the result of your suggestion. It worked brilliantly! Cheers for everyone's help! Rgds, Kmkland

ID Date1Stat Date2Stat Date3Stat Date4Stat 1 Bad Good 2 Decent Not Good Bad Rgds, Kmkland

I need ALL of the fields that do not contain "OK". Rgds, Kmkland

Then, it will produce no results. Rgds, Kmkland

Leslie, I had forgotten to remove the combined fields.... Now, I feel quite silly. :) Unfortunately, I'm still getting the same results. Rgds, Kmkland

...[tbl7-10Procedure].Date3Status, [tbl7-10Procedure].Date4Status FROM [tbl7-10Procedure] WHERE ((([Date1] & ' ' & [Date1Status]) Not Like "OK*")) OR ((([Date2] & ' ' & [Date2Status]) Not Like "OK*")) OR ((([Date3] & ' ' & [Date3Status]) Not Like "OK*")) OR ((([Date4] & ' ' & [Date4Status]) Not...

Remou: I am having network issues and printer settings. I will try your suggestion with sending the reports directly to the printer, instead of displaying a preview. I am sure that it will work. I will let you know how things go. Thanks for everyone's help. Rgds, Kmkland

Here is the code: Private Sub btnGenRpt_Click() Do Until Me.txtCopies = 0 DoCmd.OpenReport "rptNonconfFrt", acViewPreview, , , acWindowNormal Me.txtCount = Me.txtCount + 1 Me.txtCopies = Me.txtCopies - 1 Loop End Sub I have the report in Print Preview to review it before I print...

So, do I continue to use the codes at all? The original idea that you had posted? Rgds, Kmkland

Remou: I am confused. Do I still use the codes you posted earlier? Is the second text box on my report visible? I made the query the control source for my template. I am guessing that I do not need the codes now (?). Please, advise what I need to do concerning this. It is now generating...

I don't know. It is only printing 1 copy of the ending number that comes after the last sequential number I want to print. If anyone has any suggestions, I would greatly appreciate it!! Thanks for any and all help on this matter!! Rgds, Kim. Rgds, Kmkland

Hi Remou, Thanks for your response. I tried your suggestion. I will enter "501" for the number and "3" for the copies and only 1 copy will print with "504" printed on the report....instead of 3 sequential copies from 501-503. Rgds, Kim. Rgds, Kmkland

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

...Count(qryCountAbsJoin.EmpFileNo) AS CountOfEmpFileNo, qryCountAbsJoin.Date_of_Absence, Year(NZ(qryCountAbsJoin.Date_of_Absence,#1/1/1900#))*100+Month(NZ(qryCountAbsJoin.Date_of_Absence,#1/1/1900#)) AS YrMth FROM tblReasonsForAbsences LEFT JOIN qryCountAbsJoin ON tblReasonsForAbsences.Code =...

Just thought that I would include this bit of information: I have a similar crosstab query where I was able to accomplish what I needed - displaying & grouping the month/year as row headings on my report. Base query: SELECT tblEmpInfo.EmpFileNo...

DHOOKOM, I have a main table with employee information and EmpFileNo as the primary key. This is linked to another table which details the employees' absences. There is only an entry under Date_of_Absence if the employee has been absent. The relationship is 1 (Main) to Many (Absences). I need...

I solved the problem with the error message stating that the expression is too complex; I removed the following date format from the query upon which my crosstab query was based: CDate(Format([qryCountAbsJoin].[Date_of_Absence],"mm/\1/yyyy")) AS Date_of_Absence Unfortunately, I need this format...