Objective: Use a query to figure a total claim overlimit amount.
I have four tables as follows (using pertinent fields only):
CLAIMTABLE
claimnumber
overlimittotal
LINEITEMS
claimno
m...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20003637.html
Zones:
MS AccessDate Answered: 09/25/2001 Grade: A Views: 0
Hi:
I have a table that has two main fields: Date and Amount. Some of the dates do not have any amounts. I would like to write an update query that would update any records where the amount fi...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20590046.html
Zones:
DatabasesDate Answered: 04/21/2003 Grade: B Views: 0
I would like to create a query based on CFLOOP. I need to update a undetermined number of numerically-named fields. After the loop is processed, I am looking for the following example to be what ...
http://www.experts-exchange.com/Software/Server_Software/Web_Servers/ColdFusion/Q_20801647...
I have the following form that populate a 3 cell wide table of pictures. Currently it also displays the descriptioin(caption) underneathe. I would like this to be editable and then the use can cl...
http://www.experts-exchange.com/Software/Server_Software/Web_Servers/ColdFusion/Q_21402120...
If you wanted to set the value of one field in your database to the same as another field could you do the following?
Do While NOT objRec.EOF
objRec("fldReqTurn") = objRec("fldAppTurn")
ob...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_21650208.htm...
Zones:
ASPDate Answered: 12/03/2005 Grade: B Views: 0
I have a query in which I wish to execute. I have the following code but I cannot run it. I keep getting the error;
"Wrong number of arguments or invalid property assignment" I get this on my e...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_21679367.html
Zones:
Visual BasicDate Answered: 12/30/2005 Grade: A Views: 0
Hi,
I am new to all this.
Trying to update an Access DB using Oledbconnection.
Getting a syntax error (missing operator) in the SQL statement below, cannot see what it is can anyone help?
...
http://www.experts-exchange.com/Programming/Languages/Q_21708130.html
Zones:
LanguagesDate Answered: 01/25/2006 Grade: A Views: 46
I have done inserts many a time with ASP.NEt and VB.Net but now i have to do a update query and before i used to use dreamweaver to do this for me... I'm hand coding it now and need some guidance.....
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_21710170.htm...
My 2 tables:
1) NAME_ID - FIELDS = NAME(TEXT), OFFICER(TEXT)
2) FOUR_MONTHS - FIELDS = OFFICER_NAME(TEXT), OFFICER_NUMBER(TEXT)
I need a query that will add a field to Table 2 named XXX ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21759837.html
Zones:
MS AccessDate Answered: 03/03/2006 Grade: A Views: 0
Mt table UNMATCHED has the following fields (Branch is unpopulated - needs updated):
employee_names (text)
officer_codes (text)
My table off_name_branch has:
officer (same as officer_code...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21762592.html
Zones:
MS AccessDate Answered: 03/08/2006 Grade: A Views: 0
