Any One Here Using MS Access Database?

[Rasputin]

I need some help with a database that I have created and ned to generate a report.

[kcflyer]

I used to use it a lot at work but it’s been 5 years since I’ve even looked at it. Isn’t that a “wizard” you can use to create a report?

[Rasputin]

@kcflyer

I used to use it a lot at work but it’s been 5 years since I’ve even looked at it.

used it when I worked 20 years ago.

@kcflyer

Isn’t that a “wizard” you can use to create a report?

I used the Wizard and it generates a report.

Here’s my report:

I want to have a total at the bottom of the report by gallons and cost.

[crparrothead]

It has been over 5 years and I wasn’t good then.

[mcarley]

@Rasputin

I want to have a total at the bottom of the report by gallons and cost.

I’m far from an expert, but…Summing in reports - Microsoft Support

[kcflyer]

I did a lot of departmental reporting out of Access, but instead of a static report I created pivot tables in Excel to pull the data. The report usually was the final totals, but the user could drill down by clicking on the total.

[Rasputin]

@mcarley

I’m far from an expert, but…Summing in reports - Microsoft Support

That worked.

Thanks

[MaryContrary]

Dearie me.

Back in my business career we used to swear by, or swear at, File Maker Pro. Is that still a thing?

[Rasputin]

Here’s what the final report looks like in Excel.

[Rasputin]

@MaryContrary

File Maker Pro

Yep: Claris Store: FileMaker Pro.

I never heard of it until you mentioned it.

I have some limited experience with Oralcle and coded a while with Pascale.

That tells you something about my age.

[crparrothead]

I want it to be known.
This officially makes you a giant nerd.

[Rasputin]

You mispelled it.