I am trying to calculate the average of three column, some of these columns have zero and I don't want them included. See example of my table below class_name...

hiya i have been looking at Access databases as i have never used them before and i noticed the sample Northwind its called when you log onto Microsoft...

I have multiple combo boxes that I'm using as filters for a subform. I have two questions: 1) I would like to have an option to select "all" in one of the...

We have a DB with a DAP that I would like to distribute to several people to give them the ability to look at selected, limited data. The DAP is based upon...

I feel like I should know this, but I can't figure it out. I have one table with 1000 records, 50 fields per record. I want my user to be able to search...

I'm still learning. Thought I was making progress! Now, the sorting feature (when in an Access table) appears to be disabled. Can anyone help me figure...

I need to have a form that has two combo boxes that a user can select options from, and the records that meet that criteria will appear in datasheet form...

I've migrated from Ms Access 2003 to 2007 and have recently discovered that my Zoom Box Shift/F2 is not functional, when trying to access a Memo field. I've...

i am fairly new at this internet and emails. i was using an older pc w/ xp and i could get into music and all kinds of neat stuff and it was simple as long...

My applications developed in Access 2003 all open in Access 2007with the Navigation Pane Collapsed. That is what I Want... New applications developed in...

I have to import a TXT file which has data that is not space or character delimited. I have a schema provided to me about how the data should be parsed. ...

....from one PC to another, without installing it from scratch ? Background:- An "aged" MEGGER software "certificate printing" appplication, that looks like...

Hello, I have been working with Access 2003 for only about a month, and I think I understand the basics pretty well. However, I am having difficulty with a...

Hello, I am using a form that shows the results of a query. I would like to print only selected records using a check box. So, for example: If I run my...

I use up to 6 check boxes to populate the same memo field When I click the first check box "Ph1" the text is entered into the memo field on a new line "PATROL...

I'm trying to change my form to look like a continuous form, but when I change the property setting to continuous form, nothing happens

I have been asked to help design a clinical audit database which will record data from a paper data collection sheet. However, quite a few of the feilds in...

Hello, I have an apend query i wanted to use in a module and I cant get it to work. I tried the code below but gives me an error "Query input must contain at...

Is there any way to limit auto reponder message, i.e. "my new e-mail address is XX.XX" to one response per message from same user? Mike --

HI all, I will have 5 users of an Access 2007 database. What are the steps that I need to do in order for the database to be shared among all users and they...