I wrote an expression in a query as follows: Expr1: (-)*1440 For instance: 11/24/2006 11:00:00PM - 11/24/2006 10:59PM = 1 minute However the result comes up...

I have a parameter query based on a form. Under circumstances an application-form has to generated, but only for the active record. My criteria refer to a...

Is there a way to build a query that would export data in one database to another database with different field names? I am trying to export invoices from my...

I am trying to do some calculations in my query (basic) but it does not work. Example: test: (*)+. Any help is appreciated. Yes all of them are number data...

I am trying to find a way to get the average without the highest value and the lowest value in the calculation. Is there a "simple" way of doing this.

I am using MS Access 2003 and am trying to make a back-end for an excel pivot table. I have a vb form which I click a button and get the information from my...

Need help with a query written by someone else that is failing. Here is where I think the query is failing. If you need all of the code for the query, let...

i am studying BIS(Bussines Information System),2nd year,i have to start taking some courses,but i dont know what courses from microsoft that i need? please...

I'm new to access and am struggling to do what should be a simple task. I've got 2 tables. Both tables have the same 2 fields: ("Part Description" and...

I have a query that has "Treatmentdate", "Dose" and "Off" Treatment fields. I am trying to fill all the missing calender dates. Example: TreatmentDate ...

Hi:Is it possible if by mistake i entered the same date range again of same Appt which is already exist in table tblAppointments. It will not create new record...

Im running a crosstab query that is pullling data from a table that has records on a 30min basis. i wanted to pull the data and format the query to give me the...

It's simple: How do I write a formula which will give me the TOTAL NUMBER OF ROWS in any given spreadsheet? Why should this prove so difficult? Why wouldn't...

Hi all, I am trying to query a table and populate another table wit hthe result of the query. Everything works fine except for pictures in the table stored...

I have a database that queries for available rooms, this query shows the room name which is the primary key, and other fields displaying information about...

I want to make a database with Subjects of contact. Companies of contact. And, Names of contact. The "Names" fields (with phones and extention, email, etc.)...

Hello, How do query records that are data from today? I have a field called "ToDate" and I want to run a query that asks for all activity today and...

In the condition that Data in Filed A Field B or Field A Field C, Data in all fields is visible when I run the query. How to design this query?

Hello everybody, how can I get only the last date value from the table Tblabsent. I tried so: SELECT familyName, name, born, reason, max(absent) AS...

My database is as follows Access 2003 Access 2000 file format MS SQL Server 2000 as the backend I have form with a number of sub forms To troubleshoot, I'm...