Parameter question on Query in Excel
AAAAARRRRRRGGGGGGGG
Now I can not get it to work for Invoice History (Cell address with B in)
I have done exactly the same thing but can only get responses for one site
and not others.
I even tried editing the Visit report and changing the c to a b and then
saving it as Invoice - just to make sure I was not doing anything wrong. It
still does not work. I really need my head examining for agreeing to do this
- I should have admited it was beyond my capacity.
--
Leanne M (Aussie)
(Changed Display name from Leanne)
United Kingdom
(Don''t ask me what an Aussie is doing living in the UK!)
"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
|