Search results

Right now on one of my forms I am doing the standard Sort alphabetically. Is there a way I can do a conditional sorting? Like if [ColumnA]=1 put that first, if [ColumnC]=4 put that 2nd if [ColumnJ]=2 put that 3rd. So they are not in order or alphabetically but I will have simple...

That makes perfect sense thanks tpuhlig... I was looking around for row statements couldnt find any. Ill give this a shot tonight

Hopefully a simple question. I got a conditional formatting in a report that if a value in a column equals XXX make the word RED. Is there a way I can make it so that if value equals XXX make the entire row that its in RED? :confused:

Perfect huge help thanks. Subforms for some reason was not on my ribbon now that you told me what it is this makes so much more sense. Thanks again!

:confused: Noob alert in progress Pointers needed here. Basically I got 4 reports that are all based off queries. No forms. All I want to do is put these 4 reports into 1 report to make a dashboard. The queries are small but they are completely different and return very different...

I can tell thats going to be a helpfull site thanks jdraw. As for my issue just to get it out there. Lets say I have a table with 4 objects A,B,C, D I have a query using wildcards to search this table for specific data that works great. It prints it to a report. In that form when the...

Noob alert :banghead: Tried searching didnt find exactly what I want. I have a form that works all I want is a combo box that shows each tables field names. You pick the name and when you run your query it will SORT by that field name. Ideally I would like it to be that combo box with...

noob question.... I imported a few image background to test on forms. I noticed that even though I am not using several of them they are stored in the database making it a lot larger then I care for it to be. I tried a compat on the database but that didnt help. So where can I go to delete...

Beetle you rocks thanks for the help. Took me a bit to figure out but i get it. That helps a ton the way you explained it. Trying to learn by direction rather then having some show me. Like all database/programing stuff I want to fully understand the logic. If I could send you a beer I...

Ok that worked perfectly =) My issue is that if I put the "accesscode" field in that group it then returns past codes. For the query all I care about is the the date and client name. But for a form I want to return that code with the client name and date. Thoughts?

Hello everyone first off I am a noob with access :o So heres my issue.... I have a table with the following clientname| accesscode | datetochange The client name will have several entries lets say 1 for each month in the past and into the future. I want a query to show only a single...