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...
I have a todate and fromdate entered on a web page which i am passing to a sql query to search for records between certain dates.
When i complete the query i get the error: error converting d...
I am looking to average a set of quantities in a given month. I want the results to show me avg qty sold by month over a specific time range.
Here is my psuedo SQL statement:
select qua...
I have a subform that has a query which uses a "direct path" to a control on the parent form:
([forms]![frmEditPartitions]![txtHiddenModuleKey] in the cirteria)
Now I want to be able to re...
Hi,
I have a table TEST with some columns
ID BOX MESSAGE
1 20 ABC
2 20 ABC
3 20 ABC
4 21 ABC
The ID is an identity but is not known by the applicatio...
Hi Experts,
I would like to select all records base on yesterday's date. But I only want yesterday's records.
select * from table
where timevalue = getdate()-1
getdate() might not ...
Hello,
I've a Stored Procedure see below. But when I add a nieuw record with a empty textbox by Address I received a value Null in the table, but I want to have a empty/blank field.
How ...
I have a query that produces simple counts based on conditions; now I need to add a column showing the percentage of (totfree&reduced divided by totactive). Have had no success. Thank you for...
Hello,
I am still very new to Access so this question may be simple. I have a very basic query to select the top 5 records from a table - select top 5 drops from tbl_drops; This works great...
THis code works fine but I found a snauf later in the program when people are assinged at later date if they change any information in this query it looses those personnel assigned. So i need...
I have created a SSRS Report which takes the following parameters:
RepID, NotNetworkEligibleDate, ProductType, ProductSponsor.
What I need is a stored procedure where the RepId will take in ...
We have an invoice table (SOP10100). Every weekday I'm running an update statement to modify the DOCDATE and INVODATE fields to a previous date (If Monday, I make it Friday's date, otherwise ...
I have a column BillingName in the table C02.Customer. I need the name split into the fields LastName and FirstName. The data isn't consistent however. What would be the best way?
Data:
...
I am attempting to fix some corruption in a database whereby a column in the ASSET table has not been set correctly but the required value is in another table.
I have created the following ...
I am developing an Access application using Access as the front end and SQL Server as the back end database.
I have 1 table named tblA with the following fields and values:
fundType r...
I have 2 tables, Members and AwardsMember in a Coldfusion 8 project.
AwardsMember
-----------------------------
MemberNumber(blank),
AwardID(data - int),
JBFaward(data - nvarchar)
...
SQL syntax on variable date, I believe to be incorrect in "Where" statement. The following is the code:
Dim txtNewHireFromDate As String
txtNewHireFromDate = InputBox("Enter New Hire Fr...
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...
Sharepoint fiile, Keep getting this error whern runnig , sp_attach_single_file_db, to attach this file'
EXEC sp_attach_single_file_db @dbname = STS_MPNEXCHANGE_1
@physname =c...
I have a field named: AOSfiledat
this field is a varchar (3). Most fields have integer numbers(1,2,4 etc), but some have letters.
I need to delete everything that is NOT a number.
Somet...
Greetings Experts,
I need some help with a query I am writing. I am trying to calculate an average on two fields but show the results by a group, not each record. Here is an example
Ta...
Hi,
I have two tables. One with a list of document ID's (tbl_documents), and another with a large selecton of records (tbl_records) that are linked by document ID's. In this large table I wil...
Hello,
I have a table in sql server database contains varchar field, in this field records there is some records contains valid date values and some records contains characters "not date valu...
My query used to use case statement but the datafields changed. (I included sample of old CASE)
I now need to use terr_id field - which returns data such as 1-1-1-4-1-1-29, 1-1-3-17-1-4-24
A...
Hi Experts,
I have a table of rated videos submitted by users e.g.
VIDEO_ID USER_ID VIDEO_RATING
1 1 3
2 1 2
3 ...
