Search results for query: *

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...

...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 the Report's underlying query to match PHV's comment, Nothing...

...IRSItem.Comments, IRSItem.Name FROM IRSItem WHERE (((IRSItem.ItemType)=[forms]![reports]![itemtype]) AND ((IRSItem.ItemNumber) Not Like ("*F*")) AND ((IRSItem.Name)=[forms]![reports]![auditname])) OR (((IRSItem.Name)=[forms]![reports]![auditname]) AND (("forms]![reports]![itemtype]") Is...

...type is table/query, the rowsource for the ItemType is SELECT IRSItemType.ItemTypeID, IRSItemType.ItemType FROM IRSItemType UNION SELECT "*", "<All>" FROM irsitemtype order by irsitemtype.itemtype; This code does not work. When I try to open this report, I get nothing. But -- when I...

Howdy folks! I tried to search on this one, but it didn't find any applicable info. I have a form with several controls that serve as filter. I managed to fix all of my filter buttons with the exception of this one. I have 2 calendar controls ...I'm trying to filter the data on a date range...

hmm...an incomplete flag? I've never heard of that. How do you do it?

Well, the issue is that I don't want to append anything to the tblmain unless all of the information is input by the user. Why? Because once the locationtable is updated, I will then run an update query and some append statements to add the info from tblmain to the imported table. If that makes...

...It's at that point where I want the user to select a command button that saves and appends all the updated information to the source table. *phew* make sense? What's happening now is that when i edit record 1, the info from record 1 goes into the unbound text boxes for subsequent records...

I have this function that updates a table, tblTable with additional fields, etc. That all works fine and dandy. However, I have to check if a code in tblTable matches with a code in tblMaster. That also works fine and dandy. If the code doesn't match in tblTable, I have a form that pops up...