I have a text string field in MS access. I am having problems ordering the field because of the numbers inserted in the string.
Example strings:
NU-C1
NU-C2
NU-C3
...
NU-C21
NU-C22.1
...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22744575.html
I need to make a append query (Insert into) where the table that will hold the inserted records is found through a SELECT STATMENT (I have 5 potentiel table candidates for the records but I need on...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23061813.html
Hi,
Having trouble in sorting in MS Access.
I have a form with SQL query sorting on field A, B, C, then insert into a new table.
Upon opening the new table to check results, nothing was sort...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23125621.html
Zones:
MS AccessDate Answered: 01/31/2008 Grade: A Views: 0
Hello,
I am building a report of daily total quantities delivered to customers by week
I want to format the report such that it reads across the page rather than down
IE
Week Number
...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Reports/Q_23253246....
Hi All,
I am using Jet/Access as a backend and SQL for historical reasons. I am trying to write a query that list properties and their details together with a field that has the last date the p...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23392745.html
I have the following codes in VBA. Can anyone tell me where goes wrong? I guess it's probably in the Mid function in the SQL statement.
With CurrentDb.OpenRecordset("SELECT tbl_A.* FROM tbl_A IN...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23474476.html
Zones:
SQL SyntaxDate Answered: 06/10/2008 Grade: A Views: 26
Hi,
I encountered an error when trying to use a UPDATE statement with INNER JOIN.
First let me explain to you the task I have. I have two tables tbl_A and tbl_B like this:
...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_234...
Hi,
I want to update some fields of some records in a table. My difficulty is that I have all the values stored in one string for all the fields that I want to update. Like this:
allValues = ...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23475138.html
Hi, Guru!!!
Need your help
I have three tables, the primary key for all tables is WO
1st table is main table and holds *-------Export
2nd table deals with completed Work Orders-----Process
...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Reports/Q_23512446....
hi, gurus!!!
SELECT
WorkOrderNum,CompletedDate,"Operational" AS Category
FROM Process
WHERE (Operational)="No" or (Operational)="NA" and CompletedDate=#06/16/2008#
union all
SELECT
WorkOr...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23530802.html
