Search results

I'm trying to set up a combobox on the subform that will let a user choose one of multiple values (value from Auth Numbers Query) and when the record is entered it fills a field in tblAuthorization via Authorizations Query. I can get the combobox to display the correct information, but I have...

As an update, I actually did end up doing this with just the Where sorting. I set two buttons in a group to be equal to true and false, where Active = -1 and Inactive = 0. Then I just set my query to show Active where it was equal to the ConsumerSelector group.

Ok, so i made up the expression for the above and, after saving, Access changed it to the following Field: [Consumers]![Active] Table: Total: Where Criteria: True and False Field: [Forms]![Consumers]![ConsumerSelect] Table: Total: Where Criteria: 1 And 2 The changes in the criteria (True...

Is this possible? Make an option group for my three options, where Active=1, Inactive=2, Both=3, fill these values in a field (wherever), then use a query to generate the data based an if statement? I'm not sure how the function would look, but... Field: [Active] Table Consumers Total: Where...

I have a fair-sized data set going into a form that I want to filter based on a checkbox. I have a table with records of all of the consumers we have worked with, with current consumers identified by a checkbox (Active). I've created queries that show either all active or all inactive based on...

Table Arrangement: Timecard, Consumer Tracking, and Billing I apologize, in advance, for the novel. I'm making a fairly involved database and my knowledge of Access is barely scraping past mail merge. I'm improving and I think I have the general concepts (small number of forms display and feed...

I expected you couldn't say hello to everyone, and yet... Thanks for the welcome everyone.

The welcome wagon is longer than previously imagined! Stretch wagon?

The introductory post asks you to introduce yourself. Hello expanding void! It surprises me how quickly this community is growing (Based on the number of "I'm new here" threads started just yesterday), and I can't help but wonder how unprepared the welcome party is to such an onslaught. With...