Hello, I'm trying to create a database that keeps a roster of employees. the problem is, the report that acts as a directory will not be alphabetical. It...

I need to be able to pull specific fields from a table based on inputs in a form. I have two Tables set up as follows - the first is called TYPE and the...

I know this is 'off the wall'. I have to come up with a couple interview questions for a client to determine if an applicant is qualified technically to do...

I want to an increment field based in a selection I make in combo box. I have a combo named Country and I want each time I select a country the increment to...

Hello! Getting wrapped around something basic: I have 2 tables: tblDog with DogID (PK, Autonumber) and DogName (text) tblBreed with BreedID (PK,...

How can I input an entire address on a from or report , this list is currently in excel? I want it to enter like the example below when chosen from a drop...

I have been tasked with creating a database that will generate requests for documents owned by corporations such as banks, phone companies, etc. This would...

I have a bunch of restaurant receipts in a database and I want to sum all the items of each receipt. Each row of the result set would be a receipt number and...

I am working on an Access Database in Access 2003. There are two main tables that hold the most important information. There is some information that is in...

Example: I'd like to take the date of birth date which is format like 11/14/1971 and the first three character of the firstname field example: Carol I'd...

Hello - I'm working on a database that has some many-to-many relationships. I've used Access several times however I am fairly new to creating databases. ...

I try to open a database designed in Microsoft Access XP , in Microsoft Access 2007. All forms and tables seems to be ok but NO COMMAND THAT I WRITE IN VBA...

I have recently been put in charge of coming up with a solution to a mess of data that is unuseable. Currently information is being read every half hour and...

In report header I need fields : requested by 1) Date supplier name request order# payment terms (either cash or cheque) 2)

Why should I use the JOIN ON syntax instead of the WHERE syntax? In my antique book Jet Database Engine Programmer's guide Page it says (page 119) "This is...

Hi all I am creating a data base that tracks information pertaining to musical performances by a group of musicians. I have five tables: Songs: SongName,...

I use access 2003 I have a table named products ProductID ProductName Unit Price Residential $15 Commercial ...

I am designing a data base for my business and I want to import data from an excel spreadsheet. I have put my spreadsheet in the same order as the table,...

Hello, I am new to the databases and the database in access that I am creating is linked to a paradox database. I have one table that I update with all the...

ok, so my query is this I have a work order table which has a one to many relationship with an accommodations table and a one to one relationship with a...