Get data for previous dates and a database oddity

[RichardMGreen]

Hi all

I suppose this is two questions in one.
Firstly, I have a spreadsheet with a load of query names which are run via some code (I'll post if if anyone needs it). Most of the queries require an input which is supplied via cells on the spreadsheet and work OK. Two queries, however, don't need any inputs and are not returning any data to the spreadsheet even though they have records when run in the database.

Anyone any ideas on that one?


Secondly, within the database I need to be able to get data for a month 6 and 12 months ago from a supplied date.
E.g. If I supplied todays date, then I would want all data for January this year and July last year.
All the supplied dates are pre-built in the spreadheet (see above).
Anyone any ideas on this one?

I'm not sure if that is going to be clear enough, so feel free to ask for extra info (don't know what else anyone will need).

Any help would be greatly appreciated.

 

[RichardMGreen]

Thanks James.

I was treating the Access query as Access SQL which is different to proper SQL. I've made the change and it now works via Excel. The only problem is I can't now run the query in Access because of the change of wildcard.

::edit::
Solved that bit as well. Put the Access wildcard as an OR condition so it looks for both in both (if you see what I mean).
Now works in Access and returns the correct results to Excel.

Thanks for stating the obvious!!

 

[james_lankford]

Solved that bit as well. Put the Access wildcard as an OR condition so it looks for both in both (if you see what I mean).
Now works in Access and returns the correct results to Excel.

ooh, that's a good solution
I actually 2 versions of every query DOH !

yeah, that adodb can be a real pain
I forget that * % thing every couple of months and sit there totally frustrated out of my mind

"I can SEE the row in the table ! I'm looking at it right now ! Why does this stupid query not work ? !"

15 fist pounding minutes later
"oh yeah, I forgot"

 

[RichardMGreen]

Only 15 minutes????? I've been staring at this since Monday!!!