MS Access 2007 Date Query Question
My question is 2 parts: 1) I need to build a query that will look for dates in a date field that are >= 4 1/2 years from a date specified by the user. For example, if the user enters Sep 2011 the query would return all records in the database that are 4 1/2 [...]

Answer Question   |  March 31, 2012  3:17 PM
Access Database, Access Database Format, Access query

Get the latest unique entries for user ID in Access database
I have a database with a table that lists message entries. Each entry has an autonumber field ID, and a UID field that groups messages. My question is, how can I get the latest entry for each UID? Example Table: ID UID Message 1  1     Some Text 2  2     More Text 3  1     [...]

Answer Question   |  November 24, 2010  3:46 PM
Access, Access Database, Access Database Format, Access Tables

Find Due Date From X months in Access 2007
I have a database that has several different training topics each that a due at different intervals. I have a date completed field [Date completed] and reoccurs every x months [recurrence] and then the next due date [due date]. How do I get my database to calculate and store the next due date? Please use [...]

Answer Question   |  November 18, 2010  5:35 PM
Access 2007, Access Database, Access Database Design, Access Database Format

Trying to learn – How to filter dates…
I have a DB that lists a date in each column, so that when I run a simple query I can pull up only the dates that I need. I have tried (filtering by exculding dates not needed) but now my DB is too big to spend the time going through each date, to only [...]

Answer Question   |  April 13, 2009  2:27 PM
Access Database, Access Database Filters, Access Database Format, Microsoft Access

Database Access 2007
Hi, I have created a database and created a query with some fields from my main table. Now I would like to add more fields but I can’t any hint? When I go into my design mode those new fields do not apper?

Answer Question   |  March 20, 2009  7:25 PM
Access 2007, Access Database, Access Database Design, Access Database Format, Microsoft Access

Vertical text in MS Access 2003 report
I’m trying to create report headings that are perpendicular to the data fields. I have lots of fields with numbers and the headings fit on the page if they print at a 90 angle — on a slant would be nice too. When I make a label (or text box) and change the properties to [...]

Answer Question   |  January 23, 2009  9:09 PM
Access 2003, Access Database Format, Microsoft Access

Access Database – Colorize one word or letter
How do I colorize one character in a field in a table? I want the letter “O” to be in red for one customer and blue for another customer in the same column but different rows.

Answer Question   |  January 6, 2009  5:25 PM
Access Database, Access Database Format, Microsoft Access