I need to create a table that will be part of a larger intake form for Admissions into our hospital. This particular table will hold information about a...

Hi All, I'm getting ready to start a new application. The first time I did a database app, I didn't put default value in for my tables' text (or memo)...

With the need to create a relationship between tables, I am wondering if it is okay to link more than one table's Primary field with the main tables Primary...

Hi, Can anyone suggest the best way of storing a time value. I have a simple db table and need to track time taken on a particular job - if I choose...

I have an existing database which I do not want to change the table design of. I have written the following query: SELECT WO.WOID, WO.DateCreated,...

I have a log-database where data is added and deleted based on a timer. I can specify the size of the log, so when the log is "full" I delete the oldest...

I am creating a membership database for a church. Individual information is in three basic tables: tblFamily FamLastName (for entire...

Would like to eventually create a flowchart of my tables and their relationships. Any suggestions as to which program to use? Tables in Word with arrows...

Morning! I have a Invoice and an Invoice Details table. At the moment I have a services table, and you choose from a drop down which item to bill for,...

My company inspects damaged cars for insurance purposes. Up to now, (relating to this issue) I've had tblDamageArea populate a list box on my form where the...

I'm stumped on how to go about designing this database. It currently houses a number of different job functions which are all tied to locations (Tbl_MAIN). ...

I have a 2 departments here, each use their own tables to store project information. This will be used by Infopath and I need to figure out what would the...

What is the simplest way to put jpg's into an Access table? I just want to print them in reports. It used to work fine until, as usual a MS "upgrade"...

Hello all, I have an entry form that currently stores all of the data in one table. The user is to enter requests received by the branch into the entry...

I'm building an Access database to track income and expense activiities. I want to be able to categorize these activiites by account. I created tblAccounts...

Hello, I'm stuck. I have a field that requires different info based on a type and I'm not sure how to setup that up. Basically, if field1 is equal to x, then...

Newbie question: I'm creatinga database for incident reporting. I've got a table for each question, with records for each response. I'll link these to the...

I'm storing some fairly long filenames/paths in a table (they easily exceed the 255 character limit for Text fields). Does using a Memo field unnecessarily...

hi asked this question before then had to go on a trip so i will start over. i have this equation in excell but need it to work in...

I have a student database with current students and when I type "Archive" in the status column I want the record to transfer to the archive file and delete...