Search results

Change the 'x' to 1 (and '' to 0) and use sum, grouping on date?

I understand that a movement in or out is recorded in a single record and (IMO) your suggestion to create 2 movements for an internal movement is correct. I read your original post as 'How do I create 2 movement records?' and my reply was intended to be read as 'after doing whatever you do to...

How are you adding the one record when the transaction doesn't involve a movement within the warehouse?

Thank you! I have a client that often needs to reprint several, sometime hundreds of pdf files. As they all have their file location stored in a database and this should help greatly. Now I just hope they use Adobe to print their pdfs!

In that case, the code should look like Private Sub ListBox1_AfterUpdate() Me.YourTextBoxName.ControlSource = "='" & Me.YourListBoxName & "'" End Sub

[posts quick reply] - edit, didn't realise this was in the SQL Server but have left answer regardless I would build a query showing your 3 fields and for each hour, a field to calculate if the phone was in use for any part of that hour, something like...

In the AfterUpdate event of your listbox field, add the following; Me.Caption = Me.MyListBoxName where MyListBoxName is the name of your listbox

Sorry, I didn't realise you were using Sum to abbreviate your formula. I would put the formula in the Control Source of the General Repair field. The Control Source would actually be along the lines of; = [Invoice total] - ([Box1] + [Box2] + ....... + [Box12]) The square brackets are needed...

Do the txtother and txtinvalid fields both contain data? I don't really get what the attached is demonstrating either

You will need to use; General Repair = Invoice total - (Box1 + Box2 + ....... + Box12)

Is there any chance you could post what you found? Please ;)

It would be much easier to do this in a report but as you asked ... It's not nice but save the following (replacing tbl_YOURTABLE with your table name) as a query called "qry_Rank" before opening it; SELECT IAKey, HouseholdID, Assets, DCount("[IAKey]","qry_Rank","[IAKey]='" & [IAKey] & "' AND...

I would add a responsibility field to your junction table.

Assuming your text field is called field1 Left([field1],InStr([Field1],"]")) and Right([field1],Len([Field1])-InStr([Field1],"]")-1)

Sorry, I meant to say; How is the query that generates your example data sorted? Also, you wouldn't need to sort by the 'calculated' id field as it would already be in that sequence. If you want to upload the database with the query and the example data, I'll see what can be done

If that is the case, you will never get the example you've quoted (will you?)

Me.Parent.MySubForm.SourceObject = "sfrmB" where MySubForm is the name of your subform

How is the query sorted? What are the field names?

Not to me but then I'm not in the best frame of mind at the moment

SELECT [Client Number], [Name], Balance FROM tbl_Clients WHERE ([Bookkeeper number] = 22 OR [Bookkeeper number] = 24) AND Balance >300