Join 3,561 readers in helping fund MetaFilter (Hide)

9 posts tagged with access by desjardins.
Displaying 1 through 9 of 9.

Related tags:
+ (105)
+ (47)
+ (38)
+ (35)
+ (34)
+ (28)
+ (23)
+ (20)
+ (14)
+ (13)
+ (13)
+ (13)
+ (12)
+ (11)
+ (11)
+ (10)
+ (10)
+ (9)
+ (9)
+ (8)
+ (8)
+ (8)
+ (7)
+ (7)
+ (7)
+ (7)
+ (7)
+ (6)
+ (6)
+ (6)
+ (6)
+ (6)
+ (6)
+ (5)
+ (5)
+ (5)
+ (5)
+ (5)
+ (5)
+ (5)
+ (5)
+ (4)
+ (4)
+ (4)
+ (4)
+ (4)
+ (4)
+ (4)
+ (4)
+ (4)
+ (4)
+ (4)


Users that often use this tag:
desjardins (9)
benjh (5)
Jimbob (4)
dy (4)
dance (4)
JonnyRotten (4)
strangelove (3)
monkey closet (3)
SirStan (3)
diode (3)
jeather (3)
Just this guy, y'know (2)
charred husk (2)
Admira (2)
Proginoskes (2)
ctmf (2)
doomtop (2)
JeremiahBritt (2)
Foam Pants (2)
Servo5678 (2)
Brainy (2)
sandra_s (2)
mtstover (2)
mecran01 (2)
horseblind (2)
bigmusic (2)
By The Grace of God (2)
elgilito (2)
keep it tight (2)
Anonymous (2)
rosswald (2)

Merging Duplicate rows in Excel or Access

I have a table with duplicate values in one column. Some of the other columns have a value, some don't. I want to have one row for each record, with all of the colums values in one row (NOT CONCATENATED). I can use Excel or Access for this. [more inside]
posted by desjardins on Jun 19, 2014 - 18 answers

Best practices for software development documentation

I do some developery-type stuff at work and the more complicated it gets, the less organized I am. I often find myself wondering why I did this or that or what I was trying to accomplish with it. I reuse a lot of the same functions and bits of code but I don't have a good system of keeping track of them. I know about commenting within code, and I do that, but I'm looking for a larger system of general best practices more than a specific solution. [more inside]
posted by desjardins on Mar 12, 2013 - 15 answers

Need help with SQL statement

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

Data connections btwn Access 2002 and SharePoint 2007, how do they work?

I need to pretty quickly get up to speed on how to integrate an Access database with SharePoint. I know Access well, but I don't know SharePoint at all and don't understand how data connections work. The really fun part: I have Access 2002. [more inside]
posted by desjardins on Jan 11, 2011 - 8 answers

How do I append rows to a table in Access from two related tables?

How do I append rows to a table in Access from two related tables? [more inside]
posted by desjardins on Dec 27, 2010 - 3 answers

Need help formatting an Access report from a query and SQL help

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

Automatically generating an email from a query in Access

I have a database in Access that is essentially a list of projects and associated tasks. I have a query that lists all projects due in the next 30 days. How can I automatically generate an email from this query? Ideally this would just magically send an email whenever the query is populated with a new project. [more inside]
posted by desjardins on Dec 10, 2010 - 8 answers

How to run a query in Excel 2007?

How do I group values by a variable in Excel 2007? Essentially, I want to run a query. [more inside]
posted by desjardins on Jan 25, 2008 - 8 answers

Need help developing a small relational db

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

Page: 1