Search results

The field size is set to 8 for the table's properties. Unfortunately access doesn't allow me to change it because it's a linked table. I'm going to have to edit the DBF files, but I don't have the proper software for it. I'm going to reach out to our application vendor to see if they can...

That is correct.

Sorry let me try to clarify. If I open the database file transact, the column officerid contains domainname\userid But when I run the query I originally posted at the beginning of the thread, it's only returning dominname.

All returned values are 0; But I just noticed something, and I should have seen this before.... Until yesterday I've only seen the report once or twice and always just assumed the report was cutting off letters because we only saw "domainnam" down the list. When I run the query (without...

Alright, I feel like I'm close. I was able to get this working on one of the W3Schools demos with phone numbers and the "-" sign, but was unable to get it working in my environment. Yields #FUNC! error throughout the officer column. I bolded my changes. SELECT undrwrit.decstatus...

Hello everyone! I have a relatively basic understanding of Access, SQL and queries, and I could use a little bit of help here. I work at a small bank. We're using Access to run a query against several .DBF files to generate a report for our users which displays a list of declined loan...