Hi, I have Access 2000 and my records are all by individual day date. I want to be able to run a pivot table and chart that shows monthly totals but...

Hi. I've created a field in a form that calculates the age from the birthdate of the previous field. But I would like it to figure in the table. All the help...

I am trying (alot of emphasis on "trying") to create a database of students and the classes they are taking. Basically I need to be able to printout...

Hi Everyone I have a database that has run quite successfully for about 18 months. We do have several different operating systems ie windows nt, windows 2000...

Store the field value as a date (much more useful than just a year). Access the data through a query in Access e.g. qryYear: FieldYear:Year() ASP will be happy...

Access Newbie needs help with QBE grid... My DB has fields for CompanyName and Status. The Company name does not have an ID or reference number, it's just...

I'm an unable to select a record via a combo box, in help "Find a record by selecting a value from a list" it says "In the first wizard dialog box, click the...

Tried this question first in the Query discussion group, didn't receive a response, and since I'm a newby perhaps this is the more appropriate forum for my...

How do I set in Code... If a field = 0 then the text is white and what event do i place it in? Thanks DS

I'm missing something. Fairly new to Access and trying to build a selection application. I'm presenting a list of customers in a continuous form "ChooseCust"....

I would like the outcome of one combo box to affect the contents of the next combo box. eg. In the first box I have regions (North West, North East, Midlands...

Let me try to explain this. I am trying to create a sales commision report. In this report I have to give each an itemized list of their sales commisions for...

With the help of Rick Brandt, Dan Artuso, and John Vinson through a previous post I wrote this function to loop through a table... But I am getting an error...

Hello, Is it possible if I can convert a .mde file to .mdb format? Many thanks. Herman -- Message posted via http://www.accessmonster.com

I can't figure out for the life of me how to choose more than one option in either a Look-up list when viewing it in a form - or when you create an option box...

Trying to increase the length of a field from 3 to 25. Try to save table in design view and get the message that "can't change the data type. Not enough disk...

I am a novice Access user and I've created a database of our equipment. I want to copy the data to Excel and to also copy the Database to our network. I don't...

While I found previous comments helpful, I still have an issue I can't seem to figure out. Say I have a table with an "ID" field, an "In Date/Time" and "Out...

I’m trying to help a non-profit organization in my spare time (of which I have none). I volunteered to set up a database having no idea it would be this...

I am new to creating databases and would like recommendations for what program to use. This is for our basketball league with over 1000 kids playing. Some...