From: Afrosheen via AccessMonster.com on 12 Feb 2010 20:02 [Forms]![frmGender]![List5] is a list box from the frmGender form When I run the query from design mode a dialog box will pop up asking me what I want in the List5 field. That would either be female or male. I wish there was a way of pulling up the questions I've asked. I could get the original question that brought about the query and the way it was written. KARL DEWEY wrote: >Try adding this in design view to see what is being fed to your query -- > Just_Checking: [Forms]![frmGender]![List5] > >Run query for females and again for males. > >> Thanks for getting back to me Karl. >> I don't remember where I got the WHERE 1=1. The list 5 is a list box with >[quoted text clipped - 35 lines] >> >> >> >> Thanks in advance for your help. I hope I've explained it correctly. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201002/1
|
Pages: 1 Prev: Display multiple pivot charts in several pages Next: even and odd numbers |