Recent content by liamrowan

Uhhh . . . that would be glad YOU got it sorted out. Thanks again.

I removed what I thought was the * but accidentally removed the source table, which blew everything up. However, when I reinstated the source table, the phantom field was gone. So your theory that something in the SQL was the root has to be correct. What is puzzling is that I have not worked...

I have a query based on another query. The source query has two number fields and only one row. ONE of those fields is selected as a field in the new query, and uses it for 5 additional calculated fields, for a total of SIX. When I run the query, however, there are SEVEN fields, one of which is...

Appreciate the responses. The null cells were the issue. WM

XP/Access 2010 I have a table with a column that has only blank cells or an "x". In the qry based on the table, the criteria for this column is <>"x". All of the rows that have "x" are filtered out as expected, but there is one lone row that has a blank cell in the column used for filtering...

I reported this issue on behalf of a colleague, who now tells me she has gotten the query to work. Thanks for taking the time to read and offer assistance. William

Please advise how to find the SQL for the qry, thanks.

Access 2012, XP In qryA I have a field of numbers. QryB is based on qryA, and pulls in ONLY the field with numbers. When I try to sum the field of numbers in qryB, I get the following error: Data type mismatch in criteria expression. I am trying to sum the column by first selecting the...

Sorting for "0" length does indeed get the fields to show up. Thx.

I have a query with a column that contains text values. 2228 of the fields in that column are empty and I want the query to return the records with those empty fields. In Critieria I typed Is Null, but when I run the query NO records are returned. I can't figure out why. Ideas? Thx, William

Great call, thx. It was indeed a join issue. Really appreciate your response. Wm

I have a table with a field that is comprised of percentages represented by fractions (e.g., .2512, .2556, .4563). The field name is "Percent." In the qry based on this table, there is a field with the following formula: CensusPovPerc: [Percent]*100 What I am expecting is the formula to...

Thx for this theory, which certainly made sense. However, after disabling Name AutoCorrect, the field name still changes to lowercase if it is changed in Design View, and the change still "sticks" if made in Table View. I also tried saving the database, closing, reopening after the disable...

I have a table that is created by a MakeTable qry. After the table has been created, one of the field names is in lowercase. If I change that field name to all uppercase in Design View of the table, save and close, the field name reverts back to lowercase when the table is reopened. If I change...

I have a 35 page report. The last page in the Detail section has about 2 inches of data at the top of the page, which leaves the rest of page below the 2 inches of data blank. There is a large Report Footer which prints on the next and final page of the report. Ideally what I would like is for...