Search results

Sounds like you might want a case statement or some SQL in VBA with a few IF/WHERE statements in? If I'm understanding - you don't want all permutations of your query criteria right? Could you give an example?

Sickkkkk! Congrats Bob!!

DataSetName: IIf([DataSetID]=1,"Sample",IIf([DataSetID]=2,"300","Both")) I mean I use the above for a nested IIF statement in a db. I think this is what you want...

Hmmm ergonomics are different from aesthetics. Putting controls in a logical order and presenting information that is easy to understand is obviously important - I also think this is they key to having "good looking" forms. Most of my work is grey, too :) As is some of the really clever...

Let's see yours first ;) Edit: I work for a large firm too and aesthetics aren't important here. Obv they don't want to look like shit but arsing around too much is probably a waste of time. Content >>> Style.

Hmmm it sounds like you could use a CASE statement for each permutation??

Use the combo box onclick event and build the SQL for the recordsource in there. I added a dummy "name" in my Staff table for this. I then chuck a where clause for the SQL in an IF statement using something like: If sTeamMember <> "ALL" Then 'If ALL ignore WHERE statement sSQL = sSQL...

I'd stick this in the click event of the combo box and stick the WHERE clause of the SQL in an IF statement. Then set your SQL string as the recordsource of the query/listbox whatever. Something like this: If sTeamMember <> "ALL" Then 'If ALL ignore WHERE statement sSQL = sSQL & "...

In the AfterUpdate event of the button or whatever requery the control that displays your records i.e. me.listboxname.requery

Hi MS, "1. The settlement date sums for P1, P2, and P3" That one. As per my post - I added P01 etc. twice. In the one column I included a "WHERE P01 > 0" and in the second P01 column I summed the values. Worked pretty well but I guess it wouldn't be too efficient on a huge set but whatever...

Hi Neil, It's not - they represent the changes from one forecast to the next. I've got it anyway - I pulled each column in twice, set a where condition to >0 and summed t'other column. Seems to work :/

I have a data set: SettlementDate P1 P2 P3 01/04/2008 -55 -55 -55 01/04/2008 7 8 8 01/04/2008 -6 -6 -6 I need to group by settlement date where the data is <0, and in another column where the value is >0. I can do this is in excel but the set is too large really...

Hi David, Thanks for the response. That sounds ideal. I'll take a look at it today/tomo and might post back with the results :)

Hi DC, Ya, you have it spot on, I'd like to enter the dates in Excel and pass them to the queryin access in a kind of "between X and Y dates" string then pull the data into the excel data sheet. Thanks for the paper, interesting stuff.

Could anybody point me in the right direction? :)

Hi all, hope everyone is well. I have just finished an Access db. I'd like this to be the back end to a simple Excel programme. I need to set a DateFrom and DateTo field in the query from two excel fields. It'll then read the query into a data sheet in Excel which a chart/summary table...

Do you have a form open based on that record? i.e. are you trying to delete the record whilst you have it open in some kind of form? Or is somebody else in the db if it hasn't been split?

Whilst an elegant solution couldn't you just write an update query?

This is so so true. Before I joined my present company out of university this wasn't considered for a customer forecasting system. We have meter data (a site can have many meters) and portfolio level data. We often get requests for aggregated data at various levels i.e. customer which is a...