Summary: Hello, I have two tables, one with only phone numbers and the 2nd has Names, Addresses, and Phone Numbers. I need to run a query to see if any of th...
Summary: I have a simple php form and mysql connection setup. The form collects data inserted by a user. I need to know when someone posts data and what that d...
Summary: i have a datatime field which has both date and time value now i want to get the records on the basis of date only... i have tried query "select dd,aa...
Summary: I am trying to setup a query that prompts the user with a dialog box that will accept text for the search, and then return all entries that contain an...
Summary: I'm an Access novice. How do I put conditional logic into a query? I want to match one field of a record to user input in dialog 1, then in dialog 2 ...
Summary: This code has been used to encrypt and decrypt query string .No matter what the lenght of the url is ,this code will encrypt the key and the value the...
Summary: I just made a db proj in vb6 using ms access.. i just made an append query and a parameterized query for my reports.. yet a have a lot of trouble... t...
Summary: Dear All, I currently have a data structure that has been taken from a database with the relevant bits looking like this: Survey 1..* SurveyEvent 1..*...
Summary: I am trying to feed a report from a query which brings up a count if interviewed people but an #Error thing appear instead of a count. My query is cal...
Summary: Hi, I'm somewhat new to PHP and MySQL and i'm trying to run the following simple PHP/MySQL code snippet: <?php $host = "localhost"; // MySQL serve...
Summary: I am trying to pull together a Parameter Query using the below stated: Between [Start Date:] and [End Date:] however I would like to enter the date ...
Summary: Passing query parameters from a form I have a query that ask for a parameter. (WHERE [table].[field] = [Id]) I want the query to get the parameter fro...
Summary: I have a field CovType with combo boxes PO1, PO2…P14. I like to design a report to indicate the total number of PO1, PO2, PO3….for each month (Jan. F...
Summary: I have a question about a MySQL query. I want to grab 10 rows at one time. I know about setting up a nested for loop and doing multiple queries and st...
Summary: I'm using sql server.... Thanks for responding. I have tried that query, but I think it may require a query a bit more complex one.. I want a distinc...
Summary: 1- In Oracle i want to see the max sal of an employee along with his name.I use the following query only for max salary select max(sal) from emp; bu...
Summary: Hi, I'm pretty new to ms access. I made an access database with 2 tables in it. the primary key of the first is linked with a field of the second tabl...
Summary: Hi I need to define this query: I have 2 unbounded fields : ShowMonth and ShowYear (Each field represent the month and the year of Date field) And Use...
Summary: in my table i have two fields named l_series and h_series text. now i got a value of say some thing like st101 which should be b/w l_series and h_seri...
Summary: Hi, I was wondering if anyone could help me out with this one. I have created a simple query that has to search a variety of checkboxes. For example...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
