Hello, How would I go about creating a Top 12 values query? My data is as...

I have a simple query that calculates a number for each month. I want to add another field that calculates the cumulative total for each month. For example,...

Hello, any help or suggestions anyone could offer me with this would be greatly appreciated. Right now, I have a query that matches on Date and Zip Code and...

Here's the scenario... I have a Manufacturer number and a unit price for that product. The unit price should always be the same for the product. If it...

I'm using a form that displays buttons for all the current vendors in our company that have current purchase orders. What I would like is to click a vendor...

Hi folks. I'm working on a database project for a real estate firm. Some of their reports are done manually right now, and they want to begin using...

Is there a special handshake and a secret word I can use to get a response in one of these forums? Please, Abracadabra, Gates? I have asked questions in...

I would like to use a select query, I don't know sql or vba well enough, but can normally produce a pretty good access query. From table 1 I want to use 4...

hi, I have SQL generated at runtime. I added the WHERE clause, and this has been giving error messages ever since. Basically the goal here is to get the...

I've made a function that would calculate only business dates between current data and a date field (Nxt Cpn Dt). I've used the function dhCountWorkdaysA in...

I am trying to append two large tables of contact data. One table has 10,000 entries, the other has 7,000 entries. This a simple append query. The Error...

Hello. I'm making a database to manage the employees extra working hours. I have a column that already have the total of worked by hours by day. I want to...

Using a query, I'm trying to count the number of records in a table that are not null. It looks as though there's actually a space in the fields, so...

Hi friends, I would like to know about the SP(Stored Procedure) or a SQL Query which will copy data from: DB1 - tbl_alm3 TO DB2 - tbl_alm3 The...

I have an Acess DB with linked SQL tables using ODBC. I am trying to run a query which uses a form to specify criteria. Here's the criteria in the Date...

Just when you think you think you know Access, you try to do something more complex and get stuck again....With the help of your discussion group I was able to...

I have a database with information on carriers, lanes, and prices. I need to choose the cheapest 3 carriers for each lane. The lanes are either 3-digit zips to...

In Northwind, a DLookUp function on the subform populates with the price of the product being ordered. This is to record the Product price (which can...

Dear group, I have two queries, which if they are run separately from Access work as expected. When I run them via the code, each one after...

Here's the situation... Say I have a table of employees who may work at various sites in teams throughout a year. I want to be able to supply a partial team...