Search results

Hi- Any suggestions on how to make a continuous form view with new records as columns instead of rows? I have - date: 1/1/2010 topic1: reviewed topic2: competent topic3: reviewed date: 1/2/2010 topic1: reviewed topic2: competent topic3: reviewed I want - date: 1/1/2010...

Hi- I have two tables: Patients and Office Visits. There is a one to many relationship between the two (one patient has many office visits). At each office visit we collect different data points: table=visit MRN date height weight blood pressure hem A1c I have a top values query set up so...

great - thanks! now, what if i want the 5 most recent visits? I am assuming I change the "max" part...but to what?

Hi- I have two tables "Patients" and "Office Visits". There is a one to many relationship (one patient has many office visits). I am trying to get a list of the most recent office visit for each patient but when I sort the office visits in descending order and use the top values query to...

I am creating an ASP site to work with my Access database. It will be hosted on my companies intranet webserver. I am using Dreamweaver to develop the ASP pages. Any advice on a comprehensive, easy to use reference manual for using Dreamweaver with databases?? Most Dreamweaver reference...

Hi- I have a decent sized relational database in Access that I want to make a "fool proof" interface for. Ideally I woudl like it to look and feel like a webpage, but I want the database and interface to stay on a normal network drive - not a special web/database server (it will never go on teh...

can you give me an example of the SWITCH or SELECT CASE commands? I've never used those before and I'm decent with Access, but very limited with my SQL programming knowledge there will be hundreds of options to calculate BMI percentile here......I had planned on just writing each one out in...

I need to create a new field called for BMI percentile. BMI percentile is a combination of age, gender, and BMI. How can I create a field that shows me all of these options? I think it needs to look something liek this: BMIperc: iif[Age]="18" and [Gender]="male" and [BMI]=18 then = 50...

tables merged thanks for the helpful hints. I ended up creating new primary keys for each database - using your suggestion and appending numbers to the original primary key. I then found a great free online program used to merge tables. i had to do one table at a time, but it worked great...

Replica sounds like a good idea I found this article http://articles.techrepublic.com.com/5100-10877_11-6154732.html and realized that i should have made this a Design Master database with "replicas" from the getgo. However, instead I just made a blank database and copy/pasted it and renamed...

Hello- We are using an Access database for off-site data entry. We therefore have one master database we keep in the office and then a "template" version -which is identical to the master version except no records - we bring to each site, do the data entry and then merge that data back into the...

Data mismatch error THANK YOU for your help. The query works great. One glitch is that now every time I run it I get the error "Data type mismatch in expression". If I keep clicking OK through the error messages the query does eventually run. Any thoughts? THANKS

I have a table that looks like this: caseID date value I want to create a crosstab query that looks like this: Date1 Date2 Date3 etc etc caseID value value value There are 500 caseIDs in my table. Each caseID has up to 5 corresponding dates/values...