paul.hartland at fsmail.net
paul.hartland at fsmail.net
Thu Jun 24 02:17:53 CDT 2004
Of course......thank you Paul Hartland Message date : Jun 23 2004, 04:08 PM >From : "Hale, Jim" To : "'Access Developers discussion and problem solving'" Copy to : Subject : RE: [AccessD] Select All Records From A Table If Frame Value Equa ls 4 Like(*)? Jim Hale -----Original Message----- From: paul.hartland at fsmail.net [mailto:paul.hartland at fsmail.net] Sent: Wednesday, June 23, 2004 9:53 AM To: accessd Subject: [AccessD] Select All Records From A Table If Frame Value Equals 4 To all, Gone brain dead I'm sure this is a very simple one, basically I'm using a form which has a start date, end date and a frame with four possible options (Shift A, Shift B, Nights & All). If the user selects Shift A, Shift B or Nights then the query runs great, I just can't see how to return all the shifts between the dates if the user selects all...... I have the following code in the criteria: IIf([Forms]![frmDateSelection]![fraShiftSelect]=1,"A",IIf([Forms]![frmDateSe lection]![fraShiftSelect]=2,"B",IIf([Forms]![frmDateSelection]![fraShiftSele ct]=3,"Nights","A or B or Nights"))) What do I need to do to be able to return all records ? Paul Hartland -- Whatever you Wanadoo: http://www.wanadoo.co.uk/time/ This email has been checked for most known viruses - find out more at: http://www.wanadoo.co.uk/help/id/7098.htm -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- Whatever you Wanadoo: http://www.wanadoo.co.uk/time/ This email has been checked for most known viruses - find out more at: http://www.wanadoo.co.uk/help/id/7098.htm