Hello All, I am doing some simple calculations on a form and they are not being generated correctly. Here is an example. Here is the data: HistContractPrice...

I have an append query that requires the definition of two "parameters" as it executes. The problem is that each time I run it I have to manually enter the...

Hello, I am running Access 2000. I would like to create a query in my date field that will show all records that are more than 45 days old. In other words if...

Hello, I just used the startup feature for an access database file, and set the file to not display the database (the table does not show being opened) :...

Hello is it possible to use thin querie in Ms Access select test case champ = 1 then toto case champ = 2 then tata .... like we can in SQL server or what is...

I need a expression for a query thinger. The database has 4 possible values for a field called "Voltage", these values are 11, 33, 0 or NULL (NULL being...

Hi, I have two tables. One is called Attendees and the other is called MailingList. They both have a common field called ID. There is a check box on a form...

I found a common workaround for the lack of additem in Access 97 and 2000. Tablebox is the combo box I'm populating. Fields are a little harder. You have to...

I am creating an online database for our school employees to be able to enter their walking miles every week. I'm doing this using a web page, form, and then...

I am using access 97 at work. I am using a form to enter report criteria. In the report I have specified field 1 or 2 or 3 to select the data. That all works...

I use a matching records table to select records in a query. This is a multi-user environment where all objects are in a shared database. 1. Is it possible...

I have created a query with specific data in it. I want to create an expression (or something) that gives me an 'autonumber' always starting at 1 and...

How do I calculate the median in Access?

Hi. I am building a form for people to use to analyse the data in my Access2000 database. The SQL is built up in VBA depending on control values set in the...

I have a report called Store List which will create a store list for all of the stores that are contained in the database. Now I want to be able to use a form...

Well first off I have two question that I think should use a count in a query. Question 1. I would like to make a query that figures turnover rate by a month...

The macro pauses for the msgboxes when you run a make table query. How do I answer yes to the questions so that the macro keeps running?

I have a query with 2 tables. They are order header and order detail. They are joined by Order Number where Order number can occur only once in order header...

I'm using the update query below. This query is not working at all, and I'm stumpted as to what is wrong. Basically what I'm trying to accomplish these 3...

ok I've seen tons of answers to this question but none of them really work for my purpose, or I just simply don't understand. Here's what I'm trying to do: I...