Search results

Hi here is the db, the query I am struggling with is called qryReportSelector3_ApplicationDate. Thanks Kev

Hi Thanks But it says there is the wrong number of arguments, I would try and troubleshoot it but I really dont understand how it works :( Ill try and strip out the data and post the db here if that ok? Kev

Hi Thanks for your reply, sorry i have tried i keep getting syntax errors, please could you be a bit more specific how it fits in with my existing query? thanks Kev

Hi Just to put my pennies worth in, as i'm am attempting a very similar thing.. I have created a series of queries based on my combo boxes. query one just filters out which type of application (and returns all values if blank) SELECT qryAllCasesWithClient.*, qryAllCasesWithClient.Type...

im no expert but wouldn't you need an outer join of some kind edit - or maybe a unionall, then a seperate query to do the sum

Hi I have been researching how to return all values in a query when a form critieria is left blank. I have made some progress, the combo box criteria queries were fairly simple, but i'm getting stuck with my date criteria. My query doesn't return null values when I want it to. I want it to...

Looking at this more, it is the full DATETIME being exported to excel, but it only shows the date, unless i format the relevant cells as HH:MM. Im thinking the way around this may be to create a second spreadsheet and link to the export, this way I can enforce the formatting I want...

Hi Thanks for your quick reply. The format of that field in the table is set to "short time" (it defaults to this when I put in HH:MM In this table the data appears to be just the time as I expect. Also, in the query qryRCADditionalDatesFilteredExport it appears as time, and it appears...

Hi I am trying to export a table from access to excel. It has a couple of columns with times in and when excel opens it just shows 00/01/1900 for all the values. Here is my query that creates the table for exporting: SELECT tblRoadClosuresAdditionalDates.Reference...

is it worth trying to put a trim around the parameters? - may be barking up the wrong tree...

what happens when you hard code the value? Me.BranchBuildIn = DLookup("[" & Me.BRANCH & "]", "30YearConv", "[RateNum] = %") Me.BranchBuildIn = DLookup("[" & Me.BRANCH & "]", "30YearConv", "[RateNum] = '%'") substiting the value that doesnt work where ive put %

hope someone is able to help soon... just to repeat what the guy said above, why you looking up me.branch, should it not just be branch, if that is the name of the field in your 30yearconv table?

Hi I just came on to post a question and saw this, this is a similar problem as I am having. Very simple bit of code that I have done dozens of times before but not working on this occasion. If you put your line in vba and step through does BranchBuildIn = Null (thats what I am getting)...

Well that's a pain in the preverbial, but thanks for the prompt answer. If you need me tomorrow i'll be redesigning reports!!!

Hi I have a report with a series of date fields. For me the dates show up fine, but for some other users they get ##### show up (i assume this means the field is too small to hold the data). why does this happen, is there anyway to force the data to display even if the field is too small...

or lightning bolt

in the words of Queen - Flash! ahhhhh

well you learn something new every day!!! Thanks so much, wish i had posted sooner, and not spent 2 days playing with querys and code to do something so simple.

oh, how do you set up an index on 2 fields and link them, I didnt know you could do that. I have attached a sample DB with my setup (sorry about the code that hopefully going to be redundant) maybe you can show me in that what i need to do. Thanks Kev

Thanks for that, i'd forgotten about table level validation for required fields. I put required in the table, but not the Unique, becuase it is possible for 2 customers to have the same surname. This gave rise to some unfriendly messages when the field was left empty, so i put in user...