Search results

no problem - on re-reading your question I know it's probably not 100% what you were after but hopefully it'll give you a shove in the right direction ;)

Try something like this... obviously substitute your own fieldnames! PARAMETERS [Start Date/Time?] DateTime, [End Date/Time?] DateTime; SELECT mytable.userID, Count(mytable.recordID) AS NewRecords, ([End Date/Time?]-[Start Date/Time?])*24 AS Hours, [End Date/Time?] AS [End], [Start...

Try this? SELECT [Customer Name], Sum([Quantity]), [DeliveryMonth] FROM ( SELECT Customer_Name, Quantity, Delivery_Date, Month(Delivery_Date) AS DeliveryMonth FROM WINDMILL UNION ALL SELECT Customer Name, Quantity, Delivery_Date, Month(Delivery_Date) AS DeliveryMonth FROM CRUSHER ) AS U...

another option is you 'repeat' the calculation for work days within the Iif, ie SELECT Resourcing.Project_Title, Resourcing.Start_Date, Resourcing.End_Date, Resourcing.[Time], Resourcing.Trainer_Name, Resourcing.Training_Type, dhCountWorkdaysA(Resourcing.Start_Date, Resourcing.End_Date) AS...

Finally got round to sorting this over the weekend and I'm glad to say it works.... I used a separate unbound text box for each part of the time (with simple 'between' validation on each part) and then used a bit of code to sort it into the correct format and store it :) The proof of the...

Ah ok, the solution I'm using won't work for you then. Having said that, you will need to bear in mind a potential problem with a cross tab for the dates along the top: it doesn't like to show headings that don't have any 'data' against them - so unless you have something on every day, there...

You might be better having the dates as the rows and the employees as the columns.... just think about how many columns you would need to represent just 3 months of dates! I have a form in my database that might do what you're after, but it all depend on the structure of your current database...

thanks, will give it a go..

I'm struggling with putting together a form to allow the input of times into a database that I'm building... the purpose of the database is to log stage times for competitors on a car rally! The users need to input a start time and end time for each car on each stage, along with any stage...

what exactly is the controlsource of the text box on the subform? And does that text box show the correct number in it? Does it show anything?

If you want the separators, would it not be =[Business rule 1] & iif(isnull([Business rule 1]),"", ";") & [Business rule 2] & iif(isnull([Business rule 2]),"", ";") & [Business rule 3] ?

... or depending on how and where you're using it, could you use Conditional Formatting?

do you have any criteria on any of the fields you are selecting from the transactions table? If you do, then that may limit the results you're getting... as Paul said, we need to 'see' your SQL...

would you want the answer to be batch 275?

what happens if you also set the 'enabled' property to false?

But given what you said in your OP, syedadnan, then 0-33 should be C-1, not C-3? And Paul's example would find that for you?

The other option is you add a table which holds the value you've got and the ones you want to display, and then use that table in a query to 'lookup' the value you want to use / display... eg for the OP : tblCWGrades with 2 fields (or more, if you like ;) ) I tend to add an ID field to my...

can you not just put ="*" & [PCC] & "QR" & [ID] & "*" ?

IIF statements need to have a logical test, a value if true, and a value if false. If the first logical test evaluates to false, then it will move on to the 'value if false' part, which can be another IIIF statement... I THINK what you need is the statement below...

I can see how that could work.. the problem is this was supposed to be a 'build it and leave them to it' database - they just run the exports from the other system, then open the database and print off the reports.... don't really want them to be having to run updates on the data in the...