Search results

Ok, I'm understanding this, I think, but I'm still puzzled over this particular query. I already know what the arrears days are, and this solution would let you work out the arrears days based on two dates (unless I have this completely wrong). So, if I already had a column for arreas, would...

hi Not to sound too stupid, but What parts of the column would I put those expressions into? Would AgeofDebt be in the Field name, and DateDiff("d",DateLower,DateUpper) be in the criteria? Or is it all in the Field name/criteria?

Hi I'm busy learning access but I've come up against a bit of a problem when constructing a report. I have a query which my report links to with the following columns that I draw through to my report; Value, Currency, AdminOwner, Arrears At the moment, the report is split by AdminOwner...

I've just built a couple of queries which use a criteria to lookup the name in a field so I can build a report. So, in the 'admin' field I've just used "NAME" to give me the results for just that person. How do I write the criteria where field name is blank? I've tried just using "" but this...

Thanks John, I made a backup of the entire database for just that reason! It was actually in the parameters section, so once I removed this all was well!

Nevermind, I've just figured it out!!

I know this is a rediculously easy question, but I'm learning access as I go, and I've only just started. I'm trying to dismantle a query/form that someone else has put together. When I open the query, it asks me to type the name of the person I want to run the query on. This refers to a...