Search results

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...

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...