Recent content by Sephiroth0327

I feel so silly. My query was fine - there was an extra column in my table so when I copy/pasted test data in, the Y/N values went into the wrong column. This can be closed/deleted.

I have a basic Revenue table with some basic fields. One of these fields in USD_REV_AMOUNT which is associated with a PROJECT_NUMBER. In the Revenue table, I have multiple entries for the same project number and I have a query which subtotals all the USD_REV_AMOUNT for each PROJECT_NUMBER...

How do I view the connection string though? I'm not familiar with that.

It is not setup to use Windows authentication. When I was sent instructions from IT on establishing the ODBC connection, they specifically instructed me to not use Windows Authentication. Perhaps this is because the password I use to authenticate to SQL Server is different than my...

Anyone have any bright ideas? Also, I just realized I created this in the Queries forum when that probably isn't the best place. Not sure if I can move it myself.

This query appears to also be pretty straightforward. If I am understanding you correctly, you have a main query which pulls from a subquery which pulls from 4 subqueries, correct? I have run into performance issues when using subqueries this way, but no where near 45 minutes. How about...

Wow - 45 minutes is a bit ridiculous. A couple questions come to mind: How many levels of subqueries do you have? I am assuming this query points to subqueries and those subqueries are themselves pointing to tables. Is this correct? Are the tables that you are pulling from on your local...

A number of factors come in to play in regards to query runtime. If you are working with extremely large datasources and your query is pulling from multiple subqueries, then this can certainly affect performance. If you provide the SQL of one of your queries which is taking a long time, I can...

Hi All, I have built various Access Databases (Access 2003) for adhoc reporting needs which have arisen over the last couple years at my firm. Each database has at least one linked table with links out to SQL Server (via an ODBC connection). When I initially established these linked tables...

Thanks for the quick post. I was originally using DCount, but I couldn't get it to work correctly. I just want to count the records associated with a given created date (I am using the [Created] field here). I'll take another stab with the DCount. I must have missed something.

Hi All, I do a lot of work in Access in regards to SQL, queries and linked tables, but have never gotten into Reports too much. I have created a basic report which pulls from a "Calls by Day" table. This table contains data pertaining to phone calls my department has received by day. My...

You, sir, are a genius. This is perfect. Thanks!!

Here is what I want to see: Project BarcodeList 111111 ABC 1111; ABC 2222; ABC 3333 222222 ABC 1111 333333 ABC 4444, ABC 5555; ABC 6666 444444 Null 555555 Null 666666 ABC 1111; ABC 2222 777777 Null 888888...

Here you go. Thanks again.

I have updated the query, as you indicated above, and it is running without any errors, but the "SubFormValuesFROMProjects" field is blank for all records. The resulting data, actually, is exactly the same as I was getting when I ran the query without the fConcatChild function, with the...