Recent content by snoopy92211

Thanks for the tip. Can you please give some instruction on how I would create the query? An example would help greatly. much appreciated! snoopy92211

I have a table, Loans. Fields: ID (key) Loan Number Principal Balance. I have another table, Transaction, that's based off the Loan Number field on the loans table. Fields: LoanNumber Payment Type (2 choices, payment and advance) Amount I have a user form where users can specify the...

Thanks for all of the tips! :)

oops! lol. I meant to say this. SELECT DISTINCTROW Investments.Borrower, Bankdata.BankID, Bankdata.Name FROM Investments INNER JOIN Bankdata ON Investment.borrower = Bankdata.id; (borrower is bankID)

Thanks Lynchg! Now, how do I do that? I tried to do a query using a join join on BankID, but that didn't work. Here's my query, which doesn't work at all. lol SELECT DISTINCTROW ICLoans.LENDER, BusinessUnit.BusinessUnitID, BusinessUnit.Name FROM ICLoans INNER JOIN BusinessUnit ON...

Ok. This is driving me insane! I have a table, BankData, that lists bank information. It's a pretty simple table, just a primary key, and a bank name. I have several tables that use this bank name as a field. For example, I have an Investments table that uses a bank name field(field name...

I've tried both of these options as well,and the module just errs out. For the second option, this section '*' is commented out.

Thanks! one more question. This is really simple,but for the life of me, i can't figure it out. I want to create a query that says like = *. This is what i have in my sql. and it errs out everytime!! dim fn as string If Forms!obligationselector.Check157 = -1 Then fn = "Like...

Jadams0173, thanks! I forgot to mention that I've tried the 'Format' function, and for the 2/6/06 date, the obligations that were marked inactive were the following dates: 10/6/06 - 1/6/07. So this function didn't seem to work...am i missing something that should go within the format...

Hi. I have some code that I'm using to update a table in a recordset. I have this date function. For j = 1 To 12 Set rst = DB.openrecordset("obligations", dbOpenTable, dbAppendOnly) rst.AddNew If j > 1 Then rst.Fields("DueDate") = CVDate(Str(j) & "/" &...

PLEASE HELP! :(

Ok. I have a doozy of an issue. I have a table, tblobligation. I want my users to be able to make changes to this table (using a form to query the info they need), but before the changes are made, i want the changed information to be added to a stage table. that way,the approver can review the...

But.... I changed that part of the query, and the report still isn't appearing. The combobox, Itemtype has this are the RowSource: SELECT IRSItemType.ItemTypeID, IRSItemType.ItemType FROM IRSItemType UNION SELECT "*", "<All>" FROM irsitemtype order by irsitemtype.itemtype; When I changed...

ahh... The report's underlying data source is a query. Here's a sample of the code: SELECT IRSItem.ItemType, IRSItem.ItemTypeII, IRSItem.ItemNumber, IRSItem.ItemDescription, IRSItem.Company, IRSItem.CompletionPercentage, IRSItem.Comments, IRSItem.Name FROM IRSItem WHERE...

Hello. I have a form with several comboboxes. This form will allow users to select whatever criteria they want and print a report using named criteria. The reports are working fine until I decided that I wanted to add an <all> option in the combobox. Here's my combobox, named ItemType. The...