I'm trying to create a query which calculates an employee's pay, but their rate depends on the date. I've created one table with employees' names, fall rate,...

I've a column with values and I want another column with the calculation of the difference between the current and the previous column, something...

I run a site for the golf course I belong to and they have asked if can set something up where people can sign up for tournaments online. It should...

someone kindly listed a template to assist make a database. i have since lost it, and hope you can show it once more

I have a form that has a start date field and an end date field. This is linked to a report that runs on a query for start date and end date. I have made the...

I am working with chess matches from different schools. I have a query with: 1) Match ID (PK) 2) Player1 ID 3) Player2 ID 4) Player1 wins 5) Player2 wins 6)...

Hi I run Win 2k with Access 2K. I have a table called "Add Names" with has 3 colimns in it. Column 1 has a "First Name" in it (ie; John) Column 2 has a...

I'm opening up a form via vbe code on a button to datasheet view since users can sort and this view works best for accessing this particular...

I need to create a report for my team. I'm running out of time in my contract and my supervisor hasn't had a chance to do this, so I need to take care of this...

If I have a subform that tracks files in the office, what do I need to do when creating a report to get only the last entry in the table for each record? In...

I am trying to pull data from a database where I want to show only those records that are the same in 2 fields. For example, I have and Orig field and an...

Err Msg: The changes you requested to the table were not successful because they would create duplicate values in the index, primary key or relationship. I...

I'm not sure they're border lines, but in the form header (or it's the first thing in the detail) there's a horizontal line all the way across the page. Also,...

How can I find out if my application will run on Pocket Access without actually purchasing a device where it can be installed? If there's a more appropriate...

I'm using query builder to look for all records in a column that contain the word "free" I'm using *free* in the criteria line which returns records...

I have a report containing a bar chart. The main report and bar chart are linked with patient ID. That is, datasheet for bar chart has patient ID...

When i going to open the database "ABC", it show me the massege "You can't make change to the database objects in the database "ABC", This database was created...

How do you format for zip codes and phone numbers like the date. When I enter in a zipcode 01234 I get 1234. Also I would like phone numbers to come up in...

I inserted a label box while creating a form. In order to go to the 2nd line within the label box I hit Ctrl Enter. The spacing between the lines is too big...

Hello I wanted to use "Northwind Traders" sample for start to lerrn access but when I opened it, I did not know what may I do.