I have employee time ticket entries that include "start time" and "end time". I need to calculate the total number of hours for each entry, but when I subtract...

Hi, I have a form with scrollbars. The fields are filled with data when opening the form. On my computer, everything works fine, but on the users' computers,...

Hi all, I have a chain of linked tables in one to many relationship as such: Customers Table is the main table with these tables linked to it: 1. Payments 2....

Is there an EOmonth Add-in for Access similar to the one in excel?

I built a customer invoice form with a control that would give me a grand total of the costs column, but it will only work if there is a numeric value in each...

I'm trying to open various Access DBs from Excel and I was wondering if theres a way to supress splashscreens and other runtime events. I can open the DB and...

Hello All I have two queries that work OK. They each calculate a particular value ( in the first query, and in the second) for each in table (using certain...

I got the error message "Must Use Updateable Query operation" when I tried to update or add a new record on Access 2000. The same application works on other...

I have a query that returns a handicap score for each of the 16 players in my league for each week of play. Based upon that handicap score I now need to assign...

I need to query a database where I need all the transactions from start time 22:00 and end time is 02:00 I have a parameter query set where date is from "x" -...

Hi, I'm going to give a simple example of my DB. I have two tables: Student: (2 fields) student_id (atuo number), name (string) Event: (2 fields) student_id...

Hi, 2 tables have the same structure, each contains an auto number field.I need append table1 to table2, but not success. The error message is Key value...

Hi all, I have a chain of linked tables in one to many relationship as such: Customers Table is the main table with these tables linked to it: 1. Payments 2....

Hi, -- Thanks

I tried to use a query to delete data in a table in specified date. The date criteria is in different table. I built a link between 2 fields. When I run the...

Anyone who does reporting of descriptive statistics will agree that it is imperative for Access to have a median function. It is pretty embarrassing for...

Patients PatientsKey, PatientsName Doctors DoctorsKey, DoctorsID Charges: ChargesKey, ChargesDate

Hi, I was wondering is it possible to get a resultset of records by using a daterange? I know between ... and ... will give me results. But how about if a...

Hello, I have difficulty with some invoices so it seemed to me logicaly possible to resalve this problem in Access. I receive quite often long invoices with...

I currently have linked tables to an Oracle database. I have altered the table and refreshed the link using the Linked Table Manager utility in Access. After...