I'm having a challenge in desgining a database for a project. I have not created any tables for this project and have a general design question. I am trying...

I have a query that is calculating royalty for book and cd sales. My royalty field is currently =Sales*.2. This gives me the dollar value for the royalty...

I'm after some advice on how I should set this up...For the dbase I'm doing I have two contracts, 'Contract A' and 'Contract B'. Each have stock items and a...

Is it possible to scan documents into Access? Example: we send out letters and would want to be able to see copy of letter(s) sent. Could these be in a...

sI have created a report from a query. The report has 3 field, i.e. SKU;Product;QntyShipped. In the footer I want to create a TOTAL for the Quantities...

Anyone heard about MS discontinuing Access??

Hi, I'm wanting to set this up but am unsure of the best way to go about it. All I have is basically a 'service' which will belong to particular areas...

Hi I would like on a form, to complete some fields. EG am detailing an order placed by a customer. The customer details are stored in a seperate table. I have...

I have four tables which hold various pieces of data about individial companies. The information in these tables changes and I use a query to pull all the...

Hello All, when I go to Table Design, there is a column named Field 1 (it is text). When I switch to Datasheet View, it becomes hidden. Any ideas on how to...

Hi, Im designing a database for a large adhesives company, and I need help in writing a query to subtract the quantity of an order which will be specified in...

I've recently converted a database created with Access97 to Access2002 version. The problem is when I open up one of the forms I created before, a window pops...

Hi, I have the SelectOject macro attached to a command button that opens up the database window. But because I have the DW hidden by clearing "Display Database...

I`d like to relate two fields together so that when I choose one of them from a lookup list, the other filed get the appropritaed predefined value. For...

Access Novice - WinXp/Access 2003. I am a self taught access newbie. I have spent almost a year browsing these newsgroups as a daily ritual. Although these...

In my existing employees table, I need to add field to store data about the Housing Allowance employees are receiving from the Company. Not all the...

Access beginner. Access 2003 on WinXP. In Sales Order Processing Database I have the following tables. tblProducts ProductID pk...

Access beginner. In my database, I have an Employees Tables with the following structu tblEmployees: EmployeeID ) - Autonumber (pk) EmployeeName -...

In my database I have a Sales table. The data in this table will be used to analyze and summarize Sales related info in various reports. For Cash Memos and...

Has anyone created or seen a template for product pricing storage and sales quote creation? I would like to develop something like this... but if something...