Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Query Parameter
I need to set up a parameter field for criteria that is user defined. I need
it to be 'Like' (begin with) and I know that I would need to [Enter the information here] but when I put these together it does not work. Please can someone help as I am fairly new to this and totally self taught - well with a bit of help from this site! I am running the query in Excel using the Wizard. After selecting the data source and columns required I am editing it via the wizard. I set criteria on Visit Date field - is not null so that I dont get any blanks. I set criteria on Cell address to contains C as there could be B cells also in this field. And finally I want to set criteria on Site Name - so that the user can determine which site he wants to see the visit history of. The sheet/source contains only 4 columns, 3 as mentioned above and a column which is for date changed. The sheet is to record changes to a specific column in another sheet so records the data changed, when it was changed and what cell plus the name of the site for that record. I am not sure what other information you need so if I have not given something please just let me know. I am really new to queries and do not know where to go from here. A point that just occurred to me is that the sheet is currently empty. Not sure if that will have an impact or not but thought it best to mention. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Query Parameter
hi
you just having all kinds of problems with this, ain't cha. hang in there. like [what] &'%' In MSQ the percent sign is the wildcard character. See this site for more details http://www.dailydoseofexcel.com/arch...or-in-msquery/ regards FSt1 "Leanne" wrote: I need to set up a parameter field for criteria that is user defined. I need it to be 'Like' (begin with) and I know that I would need to [Enter the information here] but when I put these together it does not work. Please can someone help as I am fairly new to this and totally self taught - well with a bit of help from this site! I am running the query in Excel using the Wizard. After selecting the data source and columns required I am editing it via the wizard. I set criteria on Visit Date field - is not null so that I dont get any blanks. I set criteria on Cell address to contains C as there could be B cells also in this field. And finally I want to set criteria on Site Name - so that the user can determine which site he wants to see the visit history of. The sheet/source contains only 4 columns, 3 as mentioned above and a column which is for date changed. The sheet is to record changes to a specific column in another sheet so records the data changed, when it was changed and what cell plus the name of the site for that record. I am not sure what other information you need so if I have not given something please just let me know. I am really new to queries and do not know where to go from here. A point that just occurred to me is that the sheet is currently empty. Not sure if that will have an impact or not but thought it best to mention. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to choose if I use a parameter or not in a parameter query | Excel Discussion (Misc queries) | |||
Linking parameter query from Access to pivot table in Excel | Excel Discussion (Misc queries) | |||
Microsft Query: Excel, date parameter cell doesn't work. | Excel Discussion (Misc queries) | |||
How to put a parameter into an Excel Query | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |