TIA: I have a multi-table query; a child table has a memo field with lots of text. A multi-table query with parent and child table fields with no criteria...

TIA: I have a family table with a family address. I have related a related family members table with familly member info Is there a way through queries to...

Hello: Anyone have used or know how to calculate the quartile in a data using access 2003?. I already have used this function in excel. if this function...

Let me try again: TIA very much: Is it possible to change and existing Query Object's criteria via VB code?? If so how might it be done? Thanks again,

TIA very much! Is it possible to change an existing query object's criteria via VB code? If so how might it be done?? Thanks again, Joel

I have a VB6 SP2 application that suddenly fails to compile. I get the subject error message when attempting to do a Data Control refresh. I'm using Access...

TIA: I'm trying to return the last 2 records for each group of records from a table ie. I have a table for employees with salary history (records of date...

I have a query to select the MAX of the inspectionID by StructureID from the inspectionhistory table. But if there is more than 1 record per structureID and...

I have a query that sometimes is blank (as in, no records, depending on my criteria) Is there anyway to have all the values be 0 instead of there being no...

What is the criteria to put a data in a query. I what to have the user select the correct date. I've tried ## Please help me out. thanks

Hello, Let's say I have a query. There are three columns in my query. Balloon size, color, and type. Let's say the first record of my query is Large, Red,...

Hello, I have been concatenating fields in forms without a problem. But... when I do it with fields that are pulldowns, I get #Error. Perhaps someone has a...

Hello, I want to put pictures in my forms. I've borrowed all the code from the sample Northwind database. It errors on the code: With...

Hello, I'm trying to use this in a query. This is what it looks like in SQL: HAVING ((((IIf(="New",))) Between And )); It says that if the DrawingStage is...

How can I get this to equal 0.5 if the field has a D in it and 1.0 if the field only has a D? Something like this:? DDQTY: IIf(="D","1") or DDQTY:...

Hello, How can I eliminate a row or record that is a duplicate? -J

Hello, I have having trouble with this query, and am not sure how to go about it. In my table that's linked to another shipping database, I have a main order...

Hello, I'm joining two table in a query. One field is text, and the other is a memo field. It won't let me run the query. How can I get around...

Hello, I have a table with fields like this: Store location, quanity of red apples, quantity of green apples. e.g. Redmond,26,40

Hello, I have a query where one of the fields has a 10 digit date. It's some UNIX format that represents seconds from the year 1970. Does anyone know of an...