Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
batch updating
I have an endorsement type table linked to a master endorsement table with a foreign key endorsement table end_id end_information endorsement type end_type_id end_id end_type when users entered information to the form, the form was not properly linked and thus they did not see there were...- elfudge35
- Thread
- Replies: 6
- Forum: Microsoft: Access Queries and JET SQL
-
bound combo box filtering
I have a three table structure with this setup tblPolicy PolicyID Policy# tblEndorsement EndorsementID Endorsement# PolicyID tblTransaction TransactionID TransactionDetails EndorsementID PolicyID Some of the EndorsementIDs in tblTransaction refer to the first Endorsement# in their policy and...- elfudge35
- Thread
- Replies: 9
- Forum: Microsoft: Access Forms
-
balance and allocation formulas
I have a database that has the following components item number, beginning balance, proceeds (sale and additional), proceed allocation (between principal and outstanding charges), charges (interest and legal expenses), total outstanding charges, ending balance there are many items that refer...- elfudge35
- Thread
- Replies: 8
- Forum: Microsoft: Access Other topics
-
How do I use a query to add data not imported once I change data type
I am importing a ton of data from Excel into Access. It is working quite seamlessly, until I have encountered 9 digit and foreign postal codes. Then it wants to change the type to number instead of text and will only import the 5 digit codes. Is there a way to use a query to automatically update...- elfudge35
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
