Query Syntax?

[Ktx7ca]

I have this query

SELECT Book.BookNumber
FROM Book
WHERE (((Book.DateUpdated) Between [Forms]![INS-Export]![EXPLastDate] And [Forms]![INS-Export]![EXPNow]) AND ((Book.Status)="Sold"));

when I run it it works just fine , but when I use this Code in a button on the same form. it asks me to entry the dates.

Application.ExportXML acExportQuery, "Export Sold", " C:\Export\TestSold.xml"

I'm sure I'm missing something simple.

any ideas greatly apreciated

 

[randy700]

You may need delimiters around the date fields.
Something like this?

Between [b][COLOR=red]#[/color][/b][Forms]![INS-Export]![EXPLastDate][b][COLOR=red]#[/color][/b] And [b][COLOR=red]#[/color][/b][Forms]![INS-Export]![EXPNow][b][COLOR=red]#[/color][/b]

Randy

 

[Ktx7ca]

Hi Randy

Thanks for the help, I was sure I had tried that before, but on trying it now I get

The Expression you have entered has an invalid date value

 

[randy700]

Try adding a Debug.Print line to your code and find out exactly what you have.

Randy

 

[Ktx7ca]

HI the Error happens before I run any code, It occurs when I try and save the query

 

[alvechurchdata]

There must be a typo in there somewhere. What does the SQL view of your query say now that you've changed it.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[Ktx7ca]

Alvechurchdata,Thats what I was thinking, heres the SQL Now

SELECT Book.BookNumber
FROM Book
WHERE (((Book.DateUpdated) Between #[Forms]![INS-Export]![EXPLastDate]# And #[Forms]![INS-Export]![EXPNow]#) AND ((Book.Status)="Sold"));

 

[randy700]

And what value is in the criteria section of your query grid?


Randy

 

[Ktx7ca]

I'm not sure I totally understand your Question but in the

DateUpdated Criteria: Between #[Forms]![INS-Export]![EXPLastDate]# And #[Forms]![INS-Export]![EXPNow]#

and the Sold Criteria: "Sold"

with the # in place I can't save or change to datasheet view

 

[randy700]

Are you showing us the code from the query or from the button? We need to see the button code.


Randy

 

[Ktx7ca]

Hi Randy

The button code has not changed as is in my first post

Application.ExportXML acExportQuery, "Export Sold", " C:\Export\TestSold.xml"

 

[Ktx7ca]

I got this working by running the SQL in code

Thanks for everyones Help