Skip to content

Query: Qry Get BEE and Tax Clearance Alerts

Type: Select
Has Parameters: Yes
Has Joins: No
Has Subquery: No

Tables Referenced

  • vwPurpleGetBEEAndTaxClearanceAlerts

Columns Selected

  • vwPurpleGetBEEAndTaxClearanceAlerts.[Entrepreneur ID]
  • vwPurpleGetBEEAndTaxClearanceAlerts.[Process Status ID]
  • vwPurpleGetBEEAndTaxClearanceAlerts.[Company Status ID]
  • vwPurpleGetBEEAndTaxClearanceAlerts.[Date Record Created]
  • vwPurpleGetBEEAndTaxClearanceAlerts.[Delivery Location ID]
  • vwPurpleGetBEEAndTaxClearanceAlerts.[Delivery Location]
  • [First Name] & \
  • vwPurpleGetBEEAndTaxClearanceAlerts.[Company Name]
  • vwPurpleGetBEEAndTaxClearanceAlerts.[BEE Certificate Expire Date]
  • vwPurpleGetBEEAndTaxClearanceAlerts.[Tax Clearance Expire Date]
  • OwnedBy
  • IIf(DateDiff(\
  • IIf(IsNull([Company Status]),[Process Status],[Company Status])
  • DateDiff(\
  • DateDiff(\

Where Clause

(((DateDiff(\"d\",Date(),[BEE Certificate Expire Date]))<=30)) OR (((DateDiff(\"

SQL

SELECT vwPurpleGetBEEAndTaxClearanceAlerts.[Entrepreneur ID], vwPurpleGetBEEAndTaxClearanceAlerts.[Process Status ID], vwPurpleGetBEEAndTaxClearanceAlerts.[Company Status ID], vwPurpleGetBEEAndTaxClearanceAlerts.[Date Record Created], vwPurpleGetBEEAndTaxClearanceAlerts.[Delivery Location ID], vwPurpleGetBEEAndTaxClearanceAlerts.[Delivery Location], [First Name] & \, vwPurpleGetBEEAndTaxClearanceAlerts.[Company Name], vwPurpleGetBEEAndTaxClearanceAlerts.[BEE Certificate Expire Date], vwPurpleGetBEEAndTaxClearanceAlerts.[Tax Clearance Expire Date], vwPurpleGetBEEAndTaxClearanceAlerts.OwnedBy, IIf(DateDiff(\, IIf(IsNull([Company Status]),[Process Status],[Company Status]), DateDiff(\, DateDiff(\ FROM [vwPurpleGetBEEAndTaxClearanceAlerts] WHERE (((DateDiff(\"d\",Date(),[BEE Certificate Expire Date]))<=30)) OR (((DateDiff(\"