Problem with Exporting Query

[dinadvani via AccessMonster.com]

Hello there,

I have built a database and I need your help on this. I have built a form
with a command button and this button pulls out a query.

Now the problem is that when I export this query the format for date field
changes and so is with the currency field commas are not there in the file
which is exported. I can't do "Analyze it with excel" as the file gets open
up and this option is not available then.

I need your help to find out ways in which I can export this query without
disturbing the file format.

PS : The data is very huge so it doesn't allow me to create a report for this
query.

Any assistance would be appreciated.

Thanks,
DA

 

[Ken Snell \(MVP\)]

Often, you can use a calculated field in your query (in place of the real
field from the table), and use the Format function to "cast" the data in the
format that you want.

 

[dinadvani via AccessMonster.com]

Thanks for your reply.

But this thing is not working out properly for me. Is there any other way to
do this?

Thanks,
DA

Often, you can use a calculated field in your query (in place of the real
field from the table), and use the Format function to "cast" the data in the
format that you want.

Hello there,

[quoted text clipped - 18 lines]

Thanks,
DA

 

[Ken Snell \(MVP\)]

You'll need to post the SQL statement of the query that you're trying to
export, and post sample data of what is in the source tables and how you
want the data to look in the exported file.

--

Ken Snell
<MS ACCESS MVP>

Thanks for your reply.

But this thing is not working out properly for me. Is there any other way
to
do this?

Thanks,
DA

Often, you can use a calculated field in your query (in place of the real
field from the table), and use the Format function to "cast" the data in
the
format that you want.

Hello there,

[quoted text clipped - 18 lines]

Thanks,
DA

 

[Dhaval Dave]

Hello there,

I have built a database and I need your help on this. I have built a form
with a command button and this button pulls out a query.

Now the problem is that when I export this query the format for date field
changes and so is with the currency field commas are not there in the file
which is exported. I can't do "Analyze it with excel" as the file gets
open
up and this option is not available then.

I need your help to find out ways in which I can export this query without
disturbing the file format.

PS : The data is very huge so it doesn't allow me to create a report for
this
query.

Any assistance would be appreciated.

Thanks,
DA