I need to run the same query every day in a job where the date criteria is what ever that days date is but the time format remains the same. If I run it today the date variable would be August...
I have the following query which outputs a person's name, the itemsid owned by that person, and the total savings on that particular item. I want to be able to modify this query so that if th...
Looking at the code posted below, I would like to combine columms where the user2ent are the same with the exception of the last digit.
Example:
bsatterfield and bsatterfield1 I would li...
Hi,
iv table which have a date column, in addition to a set of other columns, all what i need a simple select query to get * from myTable where dateColumn value between (Start value) and (En...
Here's my SQL statement:
SELECT *
FROM reportRec
WHERE ID LIKE'(SELECT reportNum FROM reportMPE WHERE MPEName IN ("A-10 UPC v1.1"))%';
I do not get any syntax errors when executing it...
The query below adds up how may policies have been submitted per business origin. e.g. Referral, Repeat Customer, Advert.
I would like to include all Policy Origins even if the result is Z...
I need to concatenate the data from a category field in tblcategory that has a foreign key to the companyid field in tblcompany. Companies may have from 1 to 20 different categories. I nee...
My understanding of subqueries is that I can only match on one field from my main query. For the project I have now, I want to group one way so that I get the earliest timestamp for a particu...
I am looking for a script that I can use to determine the size of data in a particular column. For example, say that I have a table that has an ID and MyName Column:
CREATE TABLE MyTable (M...
I am needing to havea sql trigger that would occur when date1 in file1 is updated -
Upon that event I want file 2 to have the date from file one put into date2 and date3 -
both files resi...
I need to implement a rudimentary change tracking scheme for three tables in a database that is backed up daily. Normally, I would track changes via a data entry form, but in this database so...
An example of the date brough through into the table text field is 20080605
I need to change it to 05/06/2008
In a QueryI have tried all the following:
Cvdate
CDate
Dateserial(year(...
Hi,
My first post so apologies for length. I have recently been thrown in the deep end with an Access database and I'm having a problem with a query. I have one table that records results for...
Hi all,
I have a series of alphanumeric values:
15T Handling Cleat
Cleat 10T Handling
Handling Cleat 5
I would like to extract only the number from the above, so I would see
15
...
Hello all,
I have this SQL query which returns duplicate records but only displays a single record for each duplicate. I need a query that displays all records considered to be duplicates....
Hi Experts,
Need some help with SQL and possible Excel and/or a VB script.
I have a query that returns data with the following structure, where the first row icontains my column headers:...
I've used an SQL query in some VBA code I've written. I don't know much about SQL so I kinda pieced it together with help from the Internet. Now, when the query is run I get the error messag...
Hello,
I need to do a MSSQL query via ColdFusion(irrelevant) and get the results to come back in random order each time. I do not wish to limit them to 5,10,15 or whatever. I will restrict...
Is there a way to put a connection string at the top of your sql ad hoc query?
My first query returns a SSN and a name to a drop down list box such as.
888997788--Malarkey John Lee
My next query needs to just take the SSN portion of this and query the database to find ...
Ok I have a sql statement that returns 3 columns:
Salesperson, Customer they met with, number of times they have met with that customer
select owneridname, regardingobjectidname, count(*...
I have two tables:
stock_company - which stores an id, name, and symbol of a company - a
stock_history - which stores a company id, date, and value of a stock at that given time - b
I wou...
I am trying to pull all records with these parameters:
a). All records where ConnSizeID is less than 2 including Is Null values AND
b). All records where SSizeID is less than 2 or equal to 2...
What would be the SQL code to delete the record in a table containing a specific ID 1 and ID 2 dual primary key in MS Access 2003?
I am trying to delete a leading space in some of my SQL fields. ANd then I want to delete information after the city word in a column. Here is what infor looks like. Some have a leading spa...
