Search results

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

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

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?

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?

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