I would like advice on creating a dynamic graphing website to display clinical data on a intranet website to better aide clinicians. What my superiors are seeking is a "Data Mall." My programming/server-admin. experience is minimal, but my Linux-hobbyist mentality
hates the MS Access solution that is being built.
[more inside]
posted by rosswald
on Jan 16, 2013 -
4 answers
Are there really no web front end design environments that are as stupid simple as MS Access form design for a SQL Server back end? I can write a real clever stored procedure for SQL Server and assign cute and short aliases to every element of the result set and crank out an Access form or forms in no time and distribute it as a light weight front end with only execute permission required. Is there some analog for a web front end?
[more inside]
posted by Rafaelloello
on Apr 24, 2012 -
4 answers
Help me help myself- Please recommend books or websites that will help me to better understand SQL.
[more inside]
posted by bluejayway
on Mar 1, 2012 -
11 answers
I'm trying to write a SQL query on an 8 year old broken Access database that I didn't build, now on Access 2007. It's fun, I tell you what. I'm having trouble with a left outer join.
[more inside]
posted by hotelechozulu
on Oct 28, 2011 -
5 answers
I have a MS Access 2000 table with approx 300,000 records. I need help with constructing a query.
[more inside]
posted by selton
on Feb 13, 2011 -
3 answers
I need to create a query in Access that shows the percentage of a total. I can't grasp the SQL statement I need.
[more inside]
posted by desjardins
on Jan 26, 2011 -
7 answers
I'm having trouble formatting a report in Access that ONLY shows checkboxes that are not checked. I probably need some help on the SQL front.
[more inside]
posted by desjardins
on Dec 20, 2010 -
4 answers
I have a (hopefully easy) SQL question. I'm working in MS Access. Simplifying things a bit, I have a table with a TaskID, and a TaskStatusID. I want to get a list of each TaskID, and the newest TaskStatusID for each. (Details follow.)
[more inside]
posted by inigo2
on Apr 21, 2009 -
7 answers
I have been asked to make a proposal to upsize an Access database to allow for a few more concurrent users (currently 10) and ideally improve the overall performance of the system. Am I getting in over my head?
[more inside]
posted by cbrody
on Mar 10, 2009 -
11 answers
We use clinical software that uses a MS SQL database. It has a five million records weighing in at 40 GB. The software doesn't have a mobility option but we need one. The company has it on their feature request list but its at least 3-5 years away. HELP.
[more inside]
posted by bleucube
on May 29, 2008 -
20 answers
Why isn't a query in Access returning the correct data compared to the equivalent query in SQL Server. More inside.
[more inside]
posted by zackola
on Mar 31, 2008 -
11 answers
How can a fool make a table in an Access database reference another table, using SQL and ASP?
[more inside]
posted by dirtdirt
on Jan 11, 2008 -
10 answers
Please help me with a giant SQL-ish mess. I need a better solution than MS Access for dealing with millions of records and building queries.
[more inside]
posted by loquax
on Nov 19, 2007 -
12 answers
Help me properly set up a very small relational db. This is a teensy bit over my head, so mainly I want to establish that I'm not going terribly wrong before I get too far into this.
[more inside]
posted by desjardins
on Jun 6, 2007 -
5 answers
Access SQL Query - I have multiple individuals each with an address. I need to make mailing labels, but if two or more people share an address, I would only like one label.
[more inside]
posted by odinsdream
on Apr 18, 2007 -
9 answers
Microsoft Access. An SQL "GROUP BY" query. How do I generate the
mode of the values that it's grouping, when I want averages in other multiple fields?
[more inside]
posted by Jimbob
on Dec 13, 2006 -
3 answers
Access SQL:
How to use a short list of numbers stored as text in a table cell as the criteria for a query?
[more inside]
posted by Zetetics
on Nov 6, 2006 -
9 answers
How can I import selected fields from one database into another database?
[more inside]
posted by fvox13
on Mar 16, 2006 -
6 answers
How can I manage my databases that are exploding in size? Can I run SQL Server on my laptop?
[more inside]
posted by benjh
on Dec 9, 2005 -
9 answers
Say I have a database
DATA.MDB
Inside
DATA.MDB there is a table called
ImageTable.
In this table is a field named
fimageOriginalFilePath. There are aprox 4000 entries.
Each entry holds an absolute path to a directory on the C drive. For example
C:\pictures\10131009
I want to automatically replace the first character of each entry with the letter F. So that each path points to the F drive.
Can it be done? Can it be done without MS Access? Can it be done by a person with no programing skills, knowledge of databases, or understanding of SQL queries and the like? If so, how? Thank you all.
[more inside]
posted by Grod
on Apr 17, 2004 -
14 answers
