What kind of table design should I think about for calculating employee overtime? I am designing an office cost analysis db. Obviously part of this cost is...

You have fields in the query that are not in the tables --- tbl_Customers.CustomerID tbl_MIGWorkorder.CustomerID tbl_WorkOrderClaimAmt.WorkOrderID Your table...

WE have a old system @ work that drives me nuts, I have to write a order by hand and then enter the info manualy into a PO register in Excel and again into its...

Hello, I'm having trouble creating a db that would allow me to track software on employees workstations. I can't seem to link the Products table to...

Hi Everyone, Need a report or query to show all employees, their credentials and when their credentials expire. If an employee got credentialed before July...

I had 12 buttons with macros opening 12 different forms all on one Form that I titled startup and used as a switchboard. An IT person told me I'd have quicker...

Would like to know what is the best way to share a database on a share drive. The db that I am working on right now is being shared by two individuals on a...

I have a database which I have a reference number field. Is there any way that I can make the number start at 1 at the begging of each year.

I have the formula: =((()+(*)+(*))/((++))) * 100 which is supposed to find an overall percentage of the work completed based on monetary values entered in...

Hi everyone I use Access 2003 and have seen several sample databases which have at least one table with multiple keys. I understand that there can be only...

Hi. I have a table with 180,000 entries. I can filter on field so I only see 1,500 of them. Is there a way to save / cut / ?? to get the 1,500 into a separate...

i have created a new project in table and am on design view and was wondering on how to insert a formula. please reply a.s.a.p thanks.

My main application is split, uses custom menus and does not display the database window. Some users want to be able to create their own queries. So I...

Hi, I am attempting to create a turnover databse for our organization. The main things they want to see info on is the "Postition Number". Like how many times...

What do you do if you want to have more than 255 fields in 1 table? Is there some trick to making one, or is it impossible? Is it a bad structure to have that...

I have two tables, one with employee names and the other with work groups they will be in. There are many groups and the employees can be in any number of...

I am trying to preview my form and the message keeps coming up " The specified field 'PostalCode' could refer to more than one table listed in the FROM clause...

hey all, is there a way to reset an autonumber field to 1 thru any kind of code? thanks, rodchar

Hi, I am new to access and trying to set up a database, basically I want to store a customer with details including address,contact details etc and then I have...