Recent content by Pattyb628

I have a report that I am running based on a UNION query that joins three tables. The three tables are linked from FoxPro 2.5 through an ODBC connection. The report runs fine, and I get no errors, except that almost every time I run the report, I get different values in two specific fields...

That worked perfectly. I'm pretty sure it would have taken me a long time to figure that out. Thanks Pat! You're the best!

Dcount Okay, I think I have to use the DCount function. So far, I have this: DCount("*", "[Vouchered & Non-Vouchered Services]","[Service]= 'ASSESSMENT' And [Service Month] ='7'") But this gives me a syntax error (missing operator). Anyone know what I'm missing!

Hello, I am trying to count records in a report based on other fields in the report. I have two fields: [Service], and [Service Month] Basically, I want to place a text box on the report that counts the number of records where [Service]="ASSESSMENT" & [Service Month]="7" I put this in the...

I've linked a FoxPro 2.5 .dbf table in Access 2000 Prof using ODBC. I specified a unique identifier in the table so it would be updateable, but every time I try to update a field in the Access table, I get the following error message: "ODBC -- update on a linked table failed [Microsoft][ODBC...