Recent content by StayAtHomeMom

It worked!! Thank you for clearing the cobwebs!! And thank you PHV for the link about Joins. I will bookmark it for future reference. You guys are THE BEST!!

Here is my SQL, even though I know it's wrong: SELECT [SalesDetail].TerrNo AS [Terr No] FROM [SalesDetail] INNER JOIN MexicanZips ON [SalesDetail].CustZIP = MexicanZips.BorderZip WHERE ((([SalesDetail].CustZIP) In (SELECT [BorderZip] FROM [MexicanZips] As Tmp ))) GROUP BY [SalesDetail].TerrNo;

I’m confusing myself! All I’m trying to do is a Select Query from a large table with a matching field in another table. My large table is SalesDetail, and my other table is MexicanZips. There are too many Mexican Zips for me to place in the criteria row of my Select Query, so I put them in a...

GlennUK, You are an ANGEL!!!! Thank you for your help!!

Multiple TerrNos within Regions. However, one of my Regions only currently has one TerrNo. And it seems to be the culprit that's throwing off any any subtotals after that one-Terr Region.

Hello, Is anyone aware of a patch to fix subtotal errors in Excel 2002? I have a spreadsheet with columns (left to right): Region, TerrNo, RepName, Distributor, Customer, Jan-Dec totals. The first 5 columns are text, and are sorted in ascending order, starting with Region. The last columns...

I have a Select Query from a table that chooses a part number, a customer name, and a sum of the Dollar Amount. It is in order of part number, and then descending dollar amount for each of the customers of that part number. See SQL below: SELECT [POS Detail].PtNo, [POS Detail].CustName...

I am using VB code behind a button on a form in Access to create an Excel file (from a query) and format it. Part of the formatting is to place formulas in a column, using cell contents from another column. For instance, starting with cell N2, the formula should read “=L2/$L$15”; cell N3 would...

Hello, I don't work much in Excel. I program in Access most of the time, but this task requires me to stay in Excel. I have 2 files. I must compare the cell column of one spreadsheet(it's a PartNumber) to the cell column of a Master List of Part Numbers. If it's not found in the Master List, I...

THANK YOU ZmrAbdulla! I had tried searching for clues before I wrote my question, but I was using "list box" instead of "combo box". Thanks for the tip. After many dumb syntax errors on my part, I got my form/code to work correctly. Thank you again!!

Hello all, I have a form in my DB with several list boxes (where the sources are each simple Select queries from a table). The user clicks on selections within each list box, then clicks a command button that runs VB code to create a report based on their selections. I want to add a new list...

STOP THE PRESSES!! I found the reason it didn't work. I had an error in my Join Properties. I'm sooo embarrassed... Thank you anyway lespaul and golom for answering my call for help.

I'm sorry Golom, I don't know what you mean when you say try UNION ALL. Does that mean the statement would read UNION ALL SELECT...?

Hello all, Can Union queries have WHERE clauses? I tried to insert one, and the "union" part doesn't work. The one query I use grabs data for the current year, and one query grabs data totals for the last year, and I merge, or union, them together. It works great until I tried adding a...

Hello, I don't even know if this is the right forum to ask this in, but here goes: Does anyone out there use Microsoft Money? I am a volunteer treasurer for my daughter's swim team (non-profit). I need to know if there's a way to "batch" a job to print a set of customized reports. Otherwise, I...