Search results

That sounds a lot like something I had to do. Can you give an example of where you'd need a variable and what you'd use to calculate it?

I added a criteria of [Start Date]>1-1-85 to the field so that the null value wouldn't be included. It's a b.s. fix, but it's a fix. EDIT: That wasn't the fix...the fix was that I didn't tell it what form to look for [Start Date] in. [This message has been edited by UniqueTII (edited...

More info: The reason it is saying I have empty fields is because three of the fields in the table have default values, which creates a blank record at the bottom of the table. I can't change the default value of [Start Date] because it is a linked table, and I can't take away the defaults of...

I did a search on that error and this is what I found: Database Results Error Description: [Microsoft][ODBC Microsoft Access Driver] Extra ) in query expression '(MemberID = )'. Number: -2147217900 (0x80040E14) Source: Microsoft OLE DB Provider for ODBC Drivers One or more form fields were...

Are you using 97 or 2000? I don't know if it makes any difference, but I am using 2000.

I am still getting the same error.

I am trying to make a field in a query that is based on another field. In my reports, I just used an IIF statement to get the output I desired, but now I want to put it right into the query so that I can merge with Word a whole lot easier. The field I want to add is [Term], and it's based on...

Yep, I was looking at the wrong ones. I think I should have this project all wrapped up tomorrow...and I don't need it done until next Wednesday. Thanks for getting me on the right track.

With the SS# one, it's necessary in the report, but the field in the report is [Student Info SSN] while the prompt says: "Enter SS#" Why is it different like that? I checked the query for fields that don't exits, and I don't see anything. The prompts for the second report say: "Enter a start...

I am trying to change an old report that I didn't design, and every time I open it, it asks for criteria. There are two copies of the report, one asking for a student's SS#, and the other asking for the starting and ending dates of his/her employment. The problem is that I don't know why they...

Thanks a million! I'll give that a shot at work tomorrow. I found out a way to do it using a query, but your way sounds a lot easier.

I am making reports for students' work study verification forms, and what I need to do is say whether the term is "summer" or "academic year" based on the start and finish dates of work. Is it possible to say that if the start date is after May 16th the term is summer? For example, one of...

Thanks for the link...I found a different way of doing it after a couple hours of fighting with it, but it always helps to have a couple plans of attack. I explained what I did in the other thread.

What I did to do about the same thing (search for employers based on contact name or phone number) was to make combo boxes of available values in both fields and then in the code I put: Private Sub cbxTelephone_AfterUpdate() Me.RepostSubformE.Form.Filter = "[TelNum] = (cbxTelephone.Value) "...

In the header of my form, I have two combo boxes, one for name and one for phone number. In the details of my form I have a subform that lists all of the information in a query, which includes the two fields in the combo boxes. What I want to happen is that when the combo boxes are changed, I...