Search results for query: *

Good morning Sunshine! I dont know if that title does any justice to what I'm trying to do, but here goes... I have a form in Access 2010 that has fields that appear/disappear based on whether the user clicks a check box. If the checkbox, is clicked, the next option appears. I thought that was...

Hello all, I have a module that exports a query to Excel. It's a very nice little thing (thanks, in no small part, to the help I've gotten here). Anyway, I'd like to have a layer of formatting so that the first column is filtered (the little arrows show up without the user having to click on...

Good morning, I have a query where I want to use two fields to give a record of a status of either "In Process," "Alterations," or "Complete." In order for a record to be "In Process" I need the tool name to have a name that starts with A and have a Null [Actual Completed] date. For the...

Good morning everyone, Question: I have a crosstab query that tells me the count of tools by project. For one of the projects, I need to exclude tools that have an S after their name, but not on the other projects. How do I have the crosstab query exclude those records just from that project...

Hi all! Me again! :-) Question; how would one write an expression in a query that will return the last used column from left to right? Hmmm.. maybe that didnt make sense. OK, so I have columns I through V with dates. If I, J, K, and L are populated, but starting with M - V is null, I want this...

[bigglasses]Hi all, Kind of a newbie here... hoping to get some info on how to write code in order to have the report that I'm having generated in Access, exported to Excel through a module, have colors based on what is in the cell (specifically date information.) For the first column to have...