Search results

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

This should work accumlated column: [Client]+[Sales]

Thanks. I did try that and Access just seems to grind to a halt and then crash. I'll try and remove the space in the field name and see how I get on with that. Any other suggestions?

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 updated the code using the correct syntax, I think. I've used iif as I'm not familiar with nz(). At the moment it's not actually finished running, it seems to take an age.

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

Genius, Thank you sir you are my hero of the hour!

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