Search results

I need to combine two fields into one simple count query and I just cannot figure it out. I have two fields: Merch and Merch2 Here is some example data and the result it should show: Merch ------ Merch2 Vacuum ------ Gift Card TV Gift...

Rich, Thanks for the reply. I actually do want to capture the day as it is one of the fields we export to excel for a spreadsheet. Is this even possible? I have been searching for a while and I am starting to think it is not.

OK, put it into the Control Source area and it works, but now the result (i.e.: Thu) is not being put into the table since the Day field is no longer the control source. Any help on how to get the day to not only show on the form in the text box, but to also stay in the table as a part of the...

After a lot of searching, I finally found a ray of hope here... The first post is exactly what I would like to do, but where do I enter the: =format([mytextbox],"dddd") formula??? relatively new to access if you couldn't tell and I am sure the answer will be very easy once I see it. Thanks...

I have a query that I have to run using two different sets of numbers in order to get the results I need. The problem is that these numbers do not mean much when the query is run and we see the result. I would rather have them see a word which represents the two numbers. Is this possible...

I have a question that I hope you guys can help answer as recently found this forum and it has helped me already. I am an Access beginner, but have designed and redesigned several databases using the tools available within Access for Forms/Tables/Queries, etc. I am very limited when it comes to...