Search results

IIF statement with Dates functions [Solved] My goal is if the current date = 1st - 4th of the month to return the failure_date if it is >= 1st of the prior month and <= 4th of the current month (ie, 01/01/14 - 02/04/14) this works: >=DateSerial(Year(Date()),Month(Date())-1,1) And...

Table: DailyExport Field: FailureGrouping (actually is offices) I want to export all the fields from DailyExport each of our 9 offices to Excel, whetjer or not they have date in the DailyExport table. So if not, the exported workbook would only have columns headings. I need help to loop...

Query is based on 1 table" tblTimeCnv_AgeGroups Fields: AgeGroup Time Ranking 30-& under 11.22 1 30-& under 10.41 2 30-& under 9.22 3 30-39 11.32 1 30-39 9.53 2 30-39 9.34 3 30-39...

We are wanting to have our entry form open; click a button that scans a document; to a pdf file; then attaches a hyperlink to that pdf to that record. If that record was ever retrieved; we could simply double-click the hyperlink to access the pdf file. Is this possible? Could you give us some...