I am not sure if I need to use a junction table or not. I have the following tables: Doctor ID (PK) DocLNM DocFNM etc. PtID(PK) PTFNM

I am trying to build or find a template to schedule conference attendees based on a group that I assign them. Attendees have required sessions based on their...

Can anyone help me figure this out? This statement works: SELECT TblEricRevenue_Star.CU, dbo_COMPANY.LegalName, dbo_STATUS.Descr, dbo_STATUS.Abbr,...

for your financial needs visit www.plicorp.name

I am familiar with Access, how to create, tables, forms, queries, and reports and how they all link together and use for a single-user mode. However, I have a...

I have a form with a subform to issue purchase orders. The information from this/these form(s) is stored in two tables . tblPOHIST holds information...

I would appreciate if someone can help me with the validation rule for medium date on a table design property e.g. 30-Jun-2008.

Hi, I have an access 97 database on wich many users update and insert information. Recently I link some views of a SQL Server 2005 database and I have...

I have 3 separate clients for whom I have installed an Access database. The databases have been in use for 5 years in one instance and 3 years for the other...

I'm new to access and haven't gotten to know programming code yet. I'm just learning how to build a database with access tools. I've built a .accdb database...

I have a table with 2 fields: Team and Country. I'd like to create a second table that has these 2 fields and some others. How in the new table to limit...

Hi there - i am such an amateur when it comes to swtichboards. I have learned that the switchboard wizard is no fun. I like building my own. Today my concern...

Hi All. I need to present data from a scheduling database in a type of year/monthly/weekly layout similar to that used by Outlook. Instead of trying to...

Hi I am setting up a database to keep track of our training classes. I have to track absences and count them for the week as well as a cummulative count....

hiiiiii i am so confused about the table design what i want to do can't ; for example i want two table which all about invoicing such as TABLE ONE TABLE...

Experimenting and learning Access 2007. I have several tables. I manually deleted the records in each table, so that I can start with new data. The ID Value...

I am trying to create a job tracking database. I have the company information in a separate table. And I created an event table to store all the...

I have a link to a SQL Server table that works well when I first create it, but after a period of an hour or so, it produces a "Connection failed" message...

I am progressing with my student database, thanks for all help so far, my next problem is this. I want to record student discipline infractions. This means...

Table 1 Field one is a value recored once every minute Fields include "TimeStamp" and "pH Value". Table 2 Field one is a value recorded upon a change in the...