The following is in the OnOpen event of a form. It is designed to populate an ocx control in the form. Dim rst As Recordset, stSelCrit As String stSelCrit =...

I've built an expression query to calculate two fields as: % NCOTH_NEW ORDER RATE: IIf(IsNull(/),0,/) The issue here is if I replace 0 with text "N/A" the...

I have a query that has two fields, and . I want to exclude records if both these fields are null. what is the best way? I did create a field filter:...

Morning all, i have a pretty simple query totaling up the Incidents for a year. The field I am looking up is a text field, that has a lookup to another...

I have 2 DOB fields (client and spouse) in a table that I currently print off the birth month and call them on their b-day. I really wish I could figure out...

Does anyone know how to get check boxes to work in a query where there are two tables joined? For some reason the check boxes don’t work when there is a...

Hello, it would like to join two tables, Table1 and Table2, however when joining table2 the items listed in that table need to be divided by 2. I normally do...

I have a query that displays Balance Due for veterinary doctors. The query produces this: Vet Name Pet Type Last Visit Balance...

Hello All, I am using using Martin Green's creating queries on the fly but I am having some trouble. Below is the code I am using for the On Click even for...

Hello, I'm trying to Insert a record from a table into itself. The problem is field which is a Primary Key, autonumber field. If I leave it in the...

I have an append query that is being used to populate a table. I have two fields that are being pulled from data on the Form that initiates the append they...

I am running Access 2003 and was searching for a solution to my problem and came across this...

I have ready all the posts and they have not helped so I am asking for this one. I have a table with a date field "mm/dd/yyyy" in it. I am trying to create a...

I have the following SQL: strSQL = "INSERT INTO taDEFENDANTS(TrusteeDefendantID)" & _ "VALUES(lngTrusteeDefendantID)" & _ "WHERE...

I have 2 tables that are related by the field . The database is fantasy football related, just to keep practicing and learning new Access stuff. I have a...

For an excuse to play with Access 2007, I have created a database with all of my Fantasy Football league information. I have 2 Tables that are as...

I need to make changes to an update query but when I open the desing view it only shows the field that being updated. How do I view the hidden fields?

I have an update query I need to make changes to but when I open the design view it onlt shows the field that is updating. Can anyone tell me how view the...

I have four fields that I what to show the sum total of for any given year. I already have a query that will list all of the individual transactions for...