It has a built in report generator, but you are probably right that it will be faster to work in excel if you are not familiar with it. If you run your query, the result table will be a lot like excel. Click the top left corner to select all then right click to copy or copy with headers. Then it is an easy paste into excel.
Cameron On Wed, May 25, 2016 at 2:29 PM, Chuck McCown <ch...@wbmfg.com> wrote: > I actually have SQL running on the real live DB and my query is working. > Thanks for the suggestions. > I did a cut and paste into excel from the query. Not sure if it will > create a report. Have not seen that option yet. > But excel gives me the tools I need. > > *From:* Cameron Crum <cc...@wispmon.com> > *Sent:* Wednesday, May 25, 2016 1:24 PM > *To:* af@afmug.com > *Subject:* Re: [AFMUG] OT MS Access alternatives > > is it a .bak file or just and mdf? > > On Wed, May 25, 2016 at 12:12 PM, Chuck McCown <ch...@wbmfg.com> wrote: > >> I think I would probably have to set up a new database and import the >> backup into it. >> >> *From:* Cameron Crum <cc...@wispmon.com> >> *Sent:* Wednesday, May 25, 2016 11:04 AM >> *To:* af@afmug.com >> *Subject:* Re: [AFMUG] OT MS Access alternatives >> >> I'm not sure how you write queries to a database without accessing it? >> >> On Wed, May 25, 2016 at 11:53 AM, Chuck McCown <ch...@wbmfg.com> wrote: >> >>> It is just an exported database backup file. An mdb file. >>> I don’t trust myself with actually accessing the database. >>> >>> *From:* Cameron Crum <cc...@wispmon.com> >>> *Sent:* Wednesday, May 25, 2016 10:52 AM >>> *To:* af@afmug.com >>> *Subject:* Re: [AFMUG] OT MS Access alternatives >>> >>> Right click on Databases and select Attach. >>> >>> On Wed, May 25, 2016 at 11:47 AM, Chuck McCown <ch...@wbmfg.com> wrote: >>> >>>> Not seeing the import option... >>>> >>>> *From:* Cameron Crum <cc...@wispmon.com> >>>> *Sent:* Wednesday, May 25, 2016 8:45 AM >>>> *To:* af@afmug.com >>>> *Subject:* Re: [AFMUG] OT MS Access alternatives >>>> >>>> Yeah...easy to do with Sql Express, but make sure you get SQL Server >>>> Management Studio as well. Once installed, open management studio and >>>> import your DB. Select the DB and then click the "New Query" "button" at >>>> the top. Make sure the little pull down shows your database as the default >>>> "master" is sometimes in there if you haven't run a query yet. Now type >>>> your query and hit the "Execute" button. >>>> >>>> >>>> >>>> On Wed, May 25, 2016 at 9:33 AM, Chuck McCown <ch...@wbmfg.com> wrote: >>>> >>>>> Just want to write some custom query/reports. >>>>> >>>>> *From:* Cameron Crum <cc...@wispmon.com> >>>>> *Sent:* Tuesday, May 24, 2016 7:26 PM >>>>> *To:* af@afmug.com >>>>> *Subject:* Re: [AFMUG] OT MS Access alternatives >>>>> >>>>> Maybe SQLServer Express? It's free. I guess it depends on what you are >>>>> doing with database. >>>>> >>>>> On Tue, May 24, 2016 at 5:41 PM, SmarterBroadband < >>>>> li...@smarterbroadband.com> wrote: >>>>> >>>>>> Home, maybe. Looks like it. I’m just reading the web page. >>>>>> >>>>>> >>>>>> >>>>>> This is interesting for people who need occasional access. >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> https://products.office.com/en-us/office-online/documents-spreadsheets-presentations-office-online >>>>>> >>>>>> >>>>>> >>>>>> *Get started with Office Online now* >>>>>> >>>>>> No install required. Choose your favorite app. It's free. >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> *From:* Af [mailto:af-boun...@afmug.com] *On Behalf Of *Chuck McCown >>>>>> *Sent:* Tuesday, May 24, 2016 3:35 PM >>>>>> >>>>>> *To:* af@afmug.com >>>>>> *Subject:* Re: [AFMUG] OT MS Access alternatives >>>>>> >>>>>> >>>>>> >>>>>> Does that mean concurrent logins? That is pretty important in my >>>>>> application. >>>>>> >>>>>> >>>>>> >>>>>> *From:* SmarterBroadband <li...@smarterbroadband.com> >>>>>> >>>>>> *Sent:* Tuesday, May 24, 2016 4:31 PM >>>>>> >>>>>> *To:* af@afmug.com >>>>>> >>>>>> *Subject:* Re: [AFMUG] OT MS Access alternatives >>>>>> >>>>>> >>>>>> >>>>>> The home version covers 5 seats and is only $99 a year….. >>>>>> >>>>>> >>>>>> >>>>>> *From:* Af [mailto:af-boun...@afmug.com <af-boun...@afmug.com>] *On >>>>>> Behalf Of *Chuck McCown >>>>>> *Sent:* Tuesday, May 24, 2016 3:24 PM >>>>>> *To:* af@afmug.com >>>>>> *Subject:* Re: [AFMUG] OT MS Access alternatives >>>>>> >>>>>> >>>>>> >>>>>> No, $12/month total for 5 seats. >>>>>> >>>>>> They say 5 computers. One would hope concurrent logins. >>>>>> >>>>>> >>>>>> >>>>>> *From:* SmarterBroadband <li...@smarterbroadband.com> >>>>>> >>>>>> *Sent:* Tuesday, May 24, 2016 4:20 PM >>>>>> >>>>>> *To:* af@afmug.com >>>>>> >>>>>> *Subject:* Re: [AFMUG] OT MS Access alternatives >>>>>> >>>>>> >>>>>> >>>>>> That is $12 per seat? >>>>>> >>>>>> Yes, 5 PC but I think only one login? >>>>>> >>>>>> >>>>>> >>>>>> · One license covers 5 phones, 5 tablets, & 5 PCs or Macs >>>>>> per user >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> *From:* Af [mailto:af-boun...@afmug.com <af-boun...@afmug.com>] *On >>>>>> Behalf Of *Chuck McCown >>>>>> *Sent:* Tuesday, May 24, 2016 8:48 AM >>>>>> *To:* af@afmug.com >>>>>> *Subject:* Re: [AFMUG] OT MS Access alternatives >>>>>> >>>>>> >>>>>> >>>>>> I looked at those. Not thrilled. I may just go with 365. $12/month >>>>>> for 5 seats. Not terrible. >>>>>> >>>>>> >>>>>> >>>>>> *From:* Josh Luthman <j...@imaginenetworksllc.com> >>>>>> >>>>>> *Sent:* Tuesday, May 24, 2016 9:42 AM >>>>>> >>>>>> *To:* af@afmug.com >>>>>> >>>>>> *Subject:* Re: [AFMUG] OT MS Access alternatives >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> http://www.isunshare.com/blog/how-to-open-and-edit-mdb-file-without-microsoft-access/ >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> Josh Luthman >>>>>> Office: 937-552-2340 >>>>>> Direct: 937-552-2343 >>>>>> 1100 Wayne St >>>>>> Suite 1337 >>>>>> Troy, OH 45373 >>>>>> >>>>>> >>>>>> >>>>>> On Tue, May 24, 2016 at 11:39 AM, Stefan Englhardt <s...@genias.net> >>>>>> wrote: >>>>>> >>>>>> We’ve an Office365 for this. Keeping Office up to >>>>>> >>>>>> date is more expensive than renting it. >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> *Von:* Af [mailto:af-boun...@afmug.com] *Im Auftrag von *Chuck McCown >>>>>> *Gesendet:* Dienstag, 24. Mai 2016 17:30 >>>>>> *An:* af@afmug.com >>>>>> *Betreff:* [AFMUG] OT MS Access alternatives >>>>>> >>>>>> >>>>>> >>>>>> I tried to open and edit an mdb file with Libre and it keeps >>>>>> crashing. Hate to go buy access. Any alternatives that actually work? >>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
