Possible to Change MS Access Query Format?

[awigren]

I am making a database right now in MS Access. The reason is because we are trying to get away from the Excel file that we originally stored the data for more easy access.

I had to put one of my links in query format and my boss made it clear to me that we were trying to get away from the database format.

Is there any other way to show a query? Or is the datasheet the only view?

Thanks

[Stang02GT]

From now on please make sure you are posting in the correct forum.


Moved to Access.

[missinglinq]

"my boss made it clear to me that we were trying to get away from the database format"

I assume what you meant to say was that your boss doesn't want the datasheet view which is similar to a spreadsheet in Excel. What you need to do, after designing your query, is to create a form using the query as its Record Source. You can do this, if need be, by using the Form Wizard, playing around with the layout until you find a format that suits your needs.

Welcome to Bytes!

Linq ;0)>

[FishVal]

"my boss made it clear to me that we were trying to get away from the database format"

I assume what you meant to say was that your boss doesn't want the datasheet view which is similar to a spreadsheet in Excel.
.....

Something tells me that the "boss" wants to look it like Excel spreadsheet, not like "database format" he has not got accustomed to. :D
I've heard many complaints like this.

For your boss' convinience you may

• use an Access datasheet form which resembles Excel spreadsheet (though not to full extent)
• design an external db query in Excel (though it will be read-only)
• bind programmaticall y Excel spreadsheet to Access datasource (this will require rather comprehensive coding)

Regards,
Fish

[missinglinq]

Maybe you're right, Fish! I thought since the boss didn't like it in "Query format," which I take to mean in the datasheet format that queries display data in, that this was what he didn't want!

Linq ;0)>