Search results

Thank you for the suggestion lagvolt. I've attached a picture of what the SQL statement returned. Please compare with the previous pic I sent a few postings back.

Thanks meetvaset! Ditto!

Yes. It's set to unique values, not records.

It is just entered as date. The DataType is formatted only to accept date - no time. To recap: Basically I have 20 people that applied for the job posting on 1/17/2013 for the DAY/TWI shifts. When I fire up my form and click on the combobox I just want one instance of 1/17/2103 and DAY/TWI.

I already did. Look at the 3rd reply in the thread.

May a visual will help? Please see the attached. Thanks.

The GroupBy unfortunately did not work. I still get the same date 20 different times along with it's corresponding posting. Thanks though.

Thanks Mr. Ziggins. I don't have a clue as to how to use the GroupBy command. The problem is that I would like to show a two-column combobox based off of the FullTimersT table. However, I am not able to get the combobox to just show me unique values.

Sorry....didn't answer the "how does it fail". It shows the values but not in a unique manner.

Hi lagbolt, Thanks for answering. Here's the SQL: SELECT DISTINCT [FullTimersT].[PostingBeginDate], [FullTimersT].[SortsHiring] FROM FullTimersT ORDER BY [PostingBeginDate]; Where "FullTimersT" is my table, "PostingBeginDate" is column 1 and "SortsHiring" is column 2. When I use the wizard...

Hello - Here's my dilemma: I have a table that keeps track of job postings and how many people applied for each posting. So, for instance, I can have 20 people apply for a job posting say....on July 18. On another column I have the shift name for that posting such as DAY Shift. So, I have...

Wanted to drop a line and say thank you for letting me be a part of this MS Access help center. I am relatively new to Access. I have a good working knowledge of VBA and I am starting to really dig Access. I hope one day I can help someone.