|
|
Browse by Tags
- 2000
- 2003
- 2007
- access
- all
- append
- as400
- between
- box
- coldfusion
- column
- count
- criteria
- crosstab
- crystal
- data
- database
- date
- datetime
- db2
- delete
- display
- DISTINCT
- dynamic
- error
- excel
- execute
- field
- fields
- file
- find
- form
- from
- function
- get
- group
- how
- iif
- inner
- insert
- join
- last
- LDAP
- limit
- max
- maximum
- Microsoft
- month
- ms
- MS Access
- mssql
- multiple
- must
- mysql
- name
- number
- one
- oracle
- output
- parameter
- pass
- php
- postgresql
- procedure
- record
- records
- report
- reports
- result
- results
- rows
- run
- running
- sap
- script
- select
- server
- show
- slow
- sql
- string
- substring
- sum
- sybase
- syntax
- table
- tables
- text
- time
- top
- two
- union
- update
- use
- using
- value
- variable
- vba
- view
- web
-
How to use Filter out decimal using a query in access
I have a column in MS access that contains whole numbers and decimals. How do I filter out the rows that cotain decimals and just keep the entries with just whole numbers. RawData 1 2.5 5 6.5 1.3 7 I want the query output to show: 1 5 7 -
Sum a count a of multple columns
How do I sum the count of the following queries? Code Snippet: 1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: Select count(*) from Race_Results where `2` = "55 R" Select count(*) from Race_Results where `3` = "55 R" Select count(*) from Race_Results where `4` = "55 R"... -
Sub Query in Select Statement
In my illustration you'll see I have a table and the expect query results. In order to accomplish this in not one query, as opposed to writing two or three queries to get the expect result, I expect I probably need to utilize the MIN and MAX functions and write a sub query in the select statement... -
T-sql 2005 Procedure
How do i create a parameter in SQL that takes an unknown amount of values to use in a procedure. Then how would set up a loop thru go thru each value in the array?? ie.. A Procedure would have a parameter that would take a value like this one 543,345,345,6789, There are 4 values here but it could be... -
PHP MYSQL complicated query help
Hello Experts Sorry but I am rubbish at phrasing questions. I have two tables, deliveries and pre_delivery. The table deliveries already existed as part of a script that I never wrote and the pre_delivery table is new as part of an addon. pre_delivery.pd_status can hold 1 of 3 status's, Sent + date... -
Update query / general script problem
Hi, i have this script below, and it is very on and off. Sometimes it works but then i change a line of code and it stops. I can't for the life of me see whats going wrong, if anything? It redirects but doesn't redirect like it should and fails to perform the update query. Any help? Thanks Alex... -
Update query / general script problem
Hi, i have this script below, and it is very on and off. Sometimes it works but then i change a line of code and it stops. I can't for the life of me see whats going wrong, if anything? It redirects but doesn't redirect like it should and fails to perform the update query. Any help? Thanks Alex... -
Sort Query after SQL
Is it possible to sort a query after I have made an SQL query? If I submit this query: SELECT data FROM table And I have five items in the database: a,b,c,d,e and then I have list like this "e,c,b,d,a" and I want to sort the query according to the list without using SQL. So when I ouput the... -
LDAP Query - get OU names with ldap query
Hi experts!!! I'am building intranet app based on LDAP database. With exchange experts help I made page that query LDAP, so I have user names, mail, tel. no. . . . I need to query LDAP for OU names. Is it possible? here is the code posted by WMIF that I used for Intranet app. to get user names. strUser... -
LDAP Query - ignore disabled users?
How can I modify the following query to ignore disabled users in Active Directory? name="PhoneList" start="#Portal.LDAPOUStart#" attributes="cn,sn,givenname,department,telephoneNumber,mobile" sort="cn ASC" filter="(&(objectclass=user)(telephoneNumber=...