Search results

Hello! I'm using Access 2007. I had a query that worked fine a few days ago. I had to change a few things this morning and I now get Error 3125 "Reports - Campaign " is not a valid name. I've tried changing the name and it still has the same issue regardless of what the query is called...

I'm trying to measure ROI of marketing campaigns. I've gained access to our Dynamics CRM system via odbc as the reporting feature in Dynamics CRM is balls. Essentially there are 4 tables: Campaigns Leads Opportunities Opportunity Products In a nutshell when a lead has shown interest in a...

Hello, I have a crosstab query that selects and counts all contracts that are due within 3 months of Febuary, March and April. I'm trying to pull counts together and I'm using Select Case for the criteria as below: Public Function Months(DiscDate As Date) As String Select Case DiscDate...

Hello, I'm not sure how easy or if indeed it is possible but I have a query that is pulling through values for contacts. I have two tables Accounts and Contacts, for some reason or another the values in contacts have duplicates of the same contact but a seperate job titles. See below...

Hello, I'm writing my first module ever and I'm a bit stuck. I'm having to put this in a module because the IIF I was using within a query was too long, I assume a module is my only choice? Anyway here's the code I have so far but it returns "Data Type Mismatch in Criteria Expression"...

Hello there, I'm not even sure a cross tab query covers this. What I'm trying to do is create a query that will count how many companies I have in a particular catagory. I have decided those catgories by SIC codes and I have numerous columns along these lines that count how many within each...

I have a query with 3 tables MDD, Contacts and SettoDisc. The first 2 table have all the info I want to pull from the query and the third table has a field in it called [MPN] which matches the field [extref] in MDD. I want to exclude any records from the query where [ExtRef] matches [MPN] and...

I have a query where I want to sum a running total. I've used the microsoft example as it's exactly how I want the query to be shown. I thought I had the correct syntax but I keep getting #error when the query has been ran. Here's the syntax: Totals: DSum("CountOfExternal...

I've had a quick search but couldn't find anything specific to my query. I'm trying to run a query but if one of the fields from the query returns null I want it to check a field in another table and populate it with that value if 2 dates match. I have this as an expression in the query...

Hi, I have 2 tables tblMPN's and tblIncidents and they're linked by account number. In MPN's I have the field fldQuoteName and I need to only select records that match fldIncidentID in tblIncidents. However, the data in fldQuoteName is inconsisistant. It contains a string which is a...