Problem with Exporting Query

  • Thread starter Thread starter dinadvani via AccessMonster.com
  • Start date Start date
D

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
 
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.
 
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,
Click to expand...
[quoted text clipped - 18 lines]
Thanks,
DA
Click to expand...
Click to expand...
 
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>


dinadvani via AccessMonster.com said:
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,
Click to expand...
[quoted text clipped - 18 lines]
Thanks,
DA
Click to expand...
Click to expand...
Click to expand...
 
dinadvani via AccessMonster.com said:
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
Click to expand...
 
Back
Top