Search results

How would I find if 2 dates fall between 2 other dates? For example: This would evaluate to True StartDate 02/08/2007 EndDate 02/11/2007 StartTestDate 02/09/2007 EndTestDate 02/10/2007 This would also evaluate to true StartDate 02/08/2007 EndDate 02/11/2007 StartTestDate 02/07/2007...

How would I insert a variable into this string? Me.ph_cat & phCatNum.Text = Test Thanks

I have 2 tables tblMasterUsers and tblMasterSoftware the tables are joined, one 2 many on the mac field tblMasterUsers pcname user OS (Operating System) mac (MAC Address) tblMasterSoftware mac (MAC Address) installed (Software installed on each PC) I have a one query from tblMasterSoftware...

I have 2 tables with a total of 80 records. Table one has a one-2-many relationship with table two based on the social security number tblOne - Name, Address, Phone, and Social Security Number. tblTwo - Social Security Number, Account Name How do I get a list of all the name, address, phone...

Help! I am trying to create a search form that queries a table with many fields and reproduces the results in a popup box where the user can select one of the records and that record will be displayed. The search form has one textbox control for input, how can I query all the fields in a table...

Hi All, I can't figure this one out. On my form I have a drop down box containing values for example value1, value2, and value3. I have three textbox controls (textbox1, textbox2, textbox3) that I want to contain formulas based on the value selected in the drop down box. What I was trying to...