Search results

the thought that I had was to incorporate and IIF function into it. As it stands the criterea looks something like this Like "*" & [S2 Concatenated]![Concatenated List] & "*" But if [S2 Concatenated]![Concatenated List] is "" it brings back everything. I thought that I could do an IIF...

This 95% answers the question that I have, but when there is nothing in the text box it brings back everything, when I would prefer it to bring back nothing. Can anyone help?

Hello all Is it possible to automate the "analyse with excel" function via a button on a form to export a query or report to excel. I would use the transfer spreadsheet, but I do not want it to export to a particular location, I just want them to open in excel in a brand new workbook that is...

The recieving data type in the table I am appending to, is Number, with a Percentage Format at 2 decimal places, the same as the data type within the Append Query

can you not just use the "Find Unmatched Query" wizard?

I have a query which is based on other quieries that returns a number in percentages, for example 28.24% (format set in properties to percentage and 2 decimal places) Now I want to run an append query based on this information but when the data transfers across it rounds the data to either 100%...

Firstly thanks loads for the reply, I appreciate it :D To be honest though that went way over my head (I really should do a SQL or VB course or something). I will try to describe the problem a little clearer with tables names and column names and the like I have a database that is looking at...

Hello All Firstly I have been reading this forum for a while picking up hints and tips and am very grateful so big grats and thanks to all you guys for the help The problem I am stuck on at the moment will hopfully be quite simple, but I should point out I have absolutely no skill or knowlede...