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

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

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

Here's another spin on this same topic. (Sorry to barge in, but it's related). I have a form that I want users to utilize to edit records. The form's recordsource is based on a query, Missing X without Y. The form has the following fields. LocationCode - control source: Locationfield...

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