Search results

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...

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...

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...

Hi All, Ok, my database is very simple. I am dealing with three tables: Projects (contains a list of project numbers) dbo_contract_project (Table which contains basic contract information along with associated project number) ACT_Contract_Private (Table which contains additional contract...

Hi All! I am new to the forums here and am running into a small problem with my Crosstab query. Hopefully someone can point me in the right direction. My Crosstab Query is very simple. My column header is a field named "Region" and my row header is a field named "Created". The "Created"...