Search results

Basically that's it. But I just need to count the number of Contracts (meeting the criteria of course). But instead of getting the Count of Contract No FROM Contracts, it's giving me the Count of Contract No FROM ItemsOrdered. Is there some property in the join that I can change? Like I said...

Sorry about that. I am trying to count the Contract No field in the Contracts table. In that table, it is the primary key, so they are all unique, no need to worry about using distinct, etc. (so I thought!) There is also a Contract No field in the ItemsOrdered table. That is the field the two...

I have two joined tables, one to many. The problem I'm having, is the field that they are joined on, is the one I'm trying to count. So access is counting them in the wrong table, basically. Here is the SQL: SELECT DISTINCTROW Contracts.ProductID, Count(Contracts.[Contract No]) AS...

Glad I could help! We all try to make things more complicated than they are at times......I'm known to do it a LOT!!

Zaeed - In your example, is "Bob" the field that I'm updating or the field that I'm searching?? So in no way do I need to clarify in the statement that I'm using 2 different tables? I really thought that's where my issue was coming from. My mistake. Smig - Are you supposed to name the...

If you view the form in datasheet view, you can click on the column name, the down arrow, to select the whole column. Then just click and drag it to where you want it. Hit save, the new layout should be saved.

This doesn't seem like it should be complicated, but for some reason I'm not figuring it out. I just want to update a field in a table based what is found in another field in another table. So, I have a Public Function with a Select Case statement. Then I'm trying to call to that function in...

I only have 2 tables, one for the Contracts that get imported in and One that is a list of Employees and ProductID's. Well, and a TempTable for the import, but there isn't anything in that outside of for a few seconds during import. Orders come in by Contract Number. My department never goes...

That doesn't really work in this instance. There are millions of schools, school districts, and Home school parents all over the world. Just because say, Jefferson Elementary places an order, that doesn't mean that contact info will ever be good for anything again. Next time it may be a...

I will try to put this as succinctly as possible, but bear with me! I have a table containing records (duh), and a Form that is used to display those records. More than one record can, and usually does, have the same contract number (separate records for each line in the order). What I'm...

Thanks, I was afraid of that. The "Powers that be" want this to be as automated as it can be. Basically, the more user involvement required, the more room for errors (this part I agree with). If I could just figure out how to have VBA go to the Spreadsheet, and Delete the first 2 rows before...

Thanks for your help! Greatly appreciated. It did in fact get me on the right path. What I have now, is a TransferSpreadsheet copying the data from Excel (as is) to a TempTable. Then update queries to delete the unwanted rows, Trim the spaces, then an append query, then a command to delete all...

I have a fairly simple Access Form to import new records when reports are run. Reports are run from an Oracle database (no, I can't just connect to it) and put into an Excel worksheet (only output option). So, I just have to import the excel spreadsheet into Access. The code that I'm currently...

First..Thank you, thank you, thank you, for all the assistance! I guess/think I figured it out. I emailed the database to myself to look at it at home. I have 2007 at home, 2003 at work. 2007 is apparently smarter, it added some things on it's own. And now everything seems to be fine, doesn't...

Filter by Form doesn't allow the search capabilities that a Query does. If I put the text "Valley" in the Ship To Name field of the form as a filter it returns no results. But if I put it in the query, it does. Filter by Form doesn't search strings within a field. You can't use the Like "*"...

I can see how that would work nicely if I was just searching by 1 or maybe 2 simple criteria. But I have 7 different criteria that can be searched by, combined or individually. Several of them use the Like "*" operator to search for strings. Plus, it's a split database, it defeats the purpose...

I am using a form (I call it a preform) that users select or enter criteria in, the click a button, and another form opens with records that were filtered by a query based on the criteria they entered. The query seems to work just fine. If I just open the query, and type parameters into the...