Recent content by MickeyGreen

That was easy! Thanks.

I want to compare two queries as follows: Select all the records in query1 where the value in fieldA does NOT also appear in any record in fieldA of query2. Is there an easy way to do this using the query tools or will this require a vba function?

Is there a way to specify, field by field, the data types in a make-table query?

I put the following calculation in the query expression builder: HighValue: Max([Field1],[Field2]) But I keep getting the following error message when I try to save it: "The expression you entered has a function containing the wrong number of arguments" Any ideas about what is wrong with my...

Anyone? Bueller?

Thanks. I got that far but I have another problem. I have to convert some fields in the report into links in the html page. Complicating the matter further, these fields are actually in a subreport to the main report. Any thoughts?

I have an Access report that I would like to convert (or export) into an html or xml file. Is this easy? Any suggestions?

Thanks, I got both the vba and macro methods to work. I think I like the vba version better because it's easier to update.

I want to automate a process of exporting several simple queries to excel (and to overwrite the existing excel files). This has to be easy but I can't "record" the basic steps like I can in excel to get me started. can anyone help?

Thanks!! Doug, thanks, this works like a charm and I think I even understand it. One thing I'm a little fuzzy on is how the syntax works in the .Find statements. How does vb interpret .FindNext("Col_B" ='" & str2 & "'") ? Mickey

I have a report that lists values from a particular field from every record where the criteria is met. The default layout looks something like this: Value1 Value2 Value3 etc. I'd like it to look like this: Value1 Value2 Value3 etc. (and wrap around if necessary). How do I do this?

Any takers?

I'd like to run a query on a table stuctured as follows: [Col_A].....[Col_B] x-001.........AAA x-001.........BBB x-002.........BBB x-002.........CCC x-002.........DDD x-003.........BBB x-004.........AAA x-004.........CCC x-005.........EEE I want the query results to look like this...

I have an Access table with sales order data and one of the fields is customer "Industry" (i.e. Banking, Manufacturing, etc). I also have a field that I would like to update via the query named "Industry Total" where I want to show the total of all orders in the table that match the industry for...