Ms Query

[Guest]

I posted this in the Excel group but didn't get a response. Maybe someone
here has an answer. I have a pivot that I've connected to our SQL db using
the MS Query. I'm having two problems with the query:

1. In Access I create a date range to see dates between 3 and 15months ago
with the SQL statement "
WHERE (Trx.TrxDate) Between (Date()-485) AND (Date()-120)"
- no problem in Access but not the MS Query program. When I do it through
the Excel MS Query it says the Function 'date' is not valid. How do I
describe the current date in the MS Query program?

2. In the same wizard I cannot combine two fields (in Access I would use
Expr1: [Field1]&", "&[Field2]. Is there a place to do this in MS Query?

Thanks Ian.

 

[Guest]

Fiest question -- I am not sure but try [SYSDATE]

 

[yeguo]

I posted this in the Excel group but didn't get a response. Maybe someone
here has an answer. I have a pivot that I've connected to our SQL db using
the MS Query. I'm having two problems with the query:

1. In Access I create a date range to see dates between 3 and 15months ago
with the SQL statement "
WHERE (Trx.TrxDate) Between (Date()-485) AND (Date()-120)"
- no problem in Access but not the MS Query program. When I do it through
the Excel MS Query it says the Function 'date' is not valid. How do I
describe the current date in the MS Query program?

2. In the same wizard I cannot combine two fields (in Access I would use
Expr1: [Field1]&", "&[Field2]. Is there a place to do this in MS Query?

Thanks Ian.