Search results

Think I found something that will work for me... http://www.allenbrowne.com/func-09.html

I've got a form that has three separate dates in it (for this they are Date1, Date2, and Date3). These dates are tied to an individual record, so what I want to be able to do in that record is find the earliest date between the three, but all three might not always have a value in them. I've...

I’m not at my computer right now, so I don’t have it readily available. In all honesty, I hodgepodged some code together to see if it would work, but I’m hung up on setting the recordset to just select the records based on the list box selections.

I've got a listbox that I'm trying to run a command that will set a checkbox value in the associated table to yes. The listbox (lstPersonnel) has two columns (Name and Member Number). What I want to happen after I select the records I want, is to update the value in those records...

That did it, thank you!

That takes care of the Null row, but it drops the columns that are also null.

I'm trying to create a crosstab query that relies on dynamic column headings (user can change which columns are visible). How I want it to look: Present Admin 1 Operations 2 How it's showing up: Leave Present 0 Admin 1 Operations 2 While I do want all of...

Worked perfectly! Thanks again!

That gets me going in the right direction. I appreciate it!

Just like the table above, is how it should show. Right now, it shows like Department Present Leave Dept 1 2 Dept 2 2 Dept 3 2 Dept 4 2

I'm trying to create a query that compiles a running total of different criteria, but I'm hitting a roadblock by not adding an AND to my DCount function. What I want the query to do is count every selection of either Present or Leave for each Department without it displaying a total of 2 for...

All excellent tips. Haven’t had a chance to work on it at all, but this has definitely pointed me in the right direction. Only thing I can think of that could be an issue with pushing a new version every time is that the local admin might choose to install the update at the same time a user...

I currently have a fairly good sized (9 mb) database that I have shared with people. Upon initial installation, they are prompted to enter their local network data (basically where their copy of the database will be residing on their network). As I make updates to the FE file, I make it...

I guess the order doesn't really matter if it ends up in the table or not. It would be good to have it stored as a just in case, but it is what it is.

Yes, the numbers are displaying in the correct order. However, like I said in my previous post, getting the [TrackingOrder] data to actually populate in the table has me scratching my head.

It was a simple fix. Just need brackets around the Order and UseForTracking fields. SELECT T1.Location, T1.Order, (SELECT Count(*) FROM tblLocation WHERE [Order]<=T1.Order AND [UseForTracking]=-1) AS TrackingOrder FROM tblLocation AS T1 WHERE [UseForTracking]=-1 Now the only issue I have...

It's me again... :D So, I created a query and in SQL view added your code in. When I go to view the results I get a Syntax Error in the query expression. For reference, this is what I updated the code to: SELECT T1.Location, T1.Order, (SELECT Count(*) FROM tblLocation WHERE...

Great! I seem to recall coming across this when I was looking for a solution, but didn't really see the application. I think I'm there now. Thank you much!

Would that be in a query or in an OnClick event within the form?

I'm using the TrackingOrder column in a form to identify what goes where, so these numbers have to be 1-8, or else the form won't work correctly. I was going to leave it to the user to enter 1-8 manually, but that's assuming they will actually do that (which is not always the case). The source...