Search results

Q re digital signatures OK. I know this thread is old. I've spent 4 days on the internet trying to educate myself about digital signatures and I am depressed. It appears most of you are fulltime developers. I am not. I have a small business where I write Access applications and other...

Progress!! I downloaded the sample queries. One thing I was doing wrong was on the queries I hadn't 'unchecked' show on the Mo# field. Anyway, I have successfully used your methodology and with just 3 queries and one report I can run a report for each month showing that's month's figures and...

Thanks for your replies. I'm reviewing the downloaded DB and your comments and will get back to y'all(!) --- Mile-O-Phile: where would I put your expression? And since I don't have an actual date but a number field (1-12) and text field (Jan, etc.), does DateSerial still work? Thx.

QueryA has records for all 12 months, and has fields named: Month#, AccountType, SalesRep, and Sales$. A new query, QueryB, has these same fields, but I enter a Month# from a Dialog Form and QueryB gives me values for that particular month. (The Month# is just a number and not a datefield...

Thanks for reply. I got a dialog form to work as indicated, but I used a listbox bound to a Month field. (I thot of adding Mo# field later thinking any 'sum' code would be so much easier) I can change to combo box. But it's my Q1, Q2, Q3, and Q4 I need help on. I thought of entering...

This is a great website, folks! Here is my situation: Records are being downloaded from a mainframe into an Access table. Unfortunately, the field names are AugCurrSales, AugPriorSales, etc. for current year and prior year sales. I started creating reports, but already have SOOO many...