I get an error message when trying to make a cross tab query. First, I set up a regular query with the criteria set to the value of a combo box on a form....

I am working with a large database which I did not design myself. There are all sorts of queries and queries which query queries which query queries! (The same...

I need some help w/ defining a dynamic query. 1. Let's say I have a table that contains 4 fields: - Name - Address - City - State 2. Now I create a query...

I have a database with a date as a field. I would like to have the option of either entering a date range to select records in a query or allow users to select...

hi all, was wondering if i can do user input variable x rather than fixed value on SELECT TOP.what i did at the moment is fixed one whioch sql shown...

Hi, I've got a macro that gets the information from the file, runs all the queries BUT then i want the information to be exported into a an Excel format save...

I am trying to create a query that will give me a cumulative change in contract amounts for each change order that is issued. Each Contract can be identified...

I have the following query that needs to be reworked. I have combined the severity fields into one. The data that is stored in the fileld is S1,S2,S3 or null....

I'm italian, and I've created a search form for a database access, to use it in a web page. It works, but in the same page i see the input window, where i...

I have created many pre-determined queries for users to run but would like to give the user the flexibility to create their own queries. This would minimize...

Hi, Is there any way to increase the number of OR rows available on a query and thereby increase the number of single conditions that can be fulfilled for a...

I have two date columns, create_date, closed_date. I'm trying to get the number of hours between these two dates that includes only work days (M, T, W, TH,...

If a database has hundreds of queries, is there a relatively quick/simple way to find out if any of them are redundant? Thanks in advance.

I a 192,000 record database of transactions. Each transaction is a record, and often each customer has many many transactions. How can I combine these...

Hi there! I have a quick question about DLookup.. I have a form that I have setup to autofill depending on the customer chosen in a drop-down. I have the...

Hello, Long time Access user (2.0, 97 and 2002/XP). I am using Access 2000 at work (new to that particular version), and I found something very unusual that I...

I was wondering what sort of query I would build if i had the following I have a range of products and i want to be able to measure their sales in Volume and...

I am trying to build a qery that shows numbers in a database in away that can be exported to a GPS. The source data has the format 99 99,999 and the end...

Hi, Does anyone knows if it is possible to update a recordset which is retrieved via a pass-through-query by executing a stored procedure. The stored...

I have a master table that consists of a list of numbers from the DNC list. I have a series of tables that are created each month when new leads come in. I...