Search results

Hi all, I am trying to build a query to show the total sum of hours a staff member has done in a certain department and the amount of sleep ins they have done. Each staff member has a unique ID. In the query I can get all the information but it shows on two lines dependent on department. I want...

That's perfect. Knew I had something in the wrong place. Thanks for your help!

I'm new to "LIKE"

Right I'm stuck then. I am changing the query from the prior one which said if Notes was blank then run the query but stop if it wasn't

Sleep In: IIf(([Notes] Like "Sick*" Or [Notes] Like "A/L*" Or [Notes] Like "Half*"),IIf([Time Out]>=#21:55:00#,"Sleep In",""),"") Changed it to this but still it doesn't seem to work. Think I'm missing something.

Sleep In: IIf(([Notes] Like "Sick*" Or "A/L*" Or "Half*"),IIf([Time Out]>=#21:55:00#,"Sleep In",""),"") Hi All, I have a column in a query and I want it to do the following... If the notes column starts with the word sick, A/L or half then the sleep in column should be blank. If it does not...

Hi, I see what you're saying on all points and I would love to stream line it all to be fair but I'm pulling data from a csv file from a third party and they only allow a file of that type. A lot of the data is redundant but once I have completed a month the data will be cleared so stream...

Hi, I have a query that holds data based on a field. If the field [Device In] is "TimeStation-1" in TblTime for example it holds "AV" in the field [House]. Trouble is some fields are blank and when this is so I want it to pull the last two letters from the [Notes] field. I have attached the...

Hi, Unfortunately the data comes from a third party all in one file hence the randomness of the table. Cheers, Paul

Crosstab works beautifully thanks a lot!

I kinda want a query like this... Id Name A V L H P S --------------------------------------------------------------------------------------------------------- 01 PAUL...

Hi, I have a query that gives a value in a column either "A","V","L","H","P","S" or blank. I want to be able to count the amount of occurunces of each letter and hold that number in a column. Is it easy to do? Cheers, Paul

Here is the database...

Hi all, Bit of a big ask this one. I have a database with a query that gives us a few extra details from our table. It tells us whether someone has done a sleep in and then based on whether it is a weekday or weekend gives us a letter corresponding to that. Using three devices at each location...

Should I mark the other as solved? Or link to this one?

Yes I guess it is. I just changed the way I put it cause I realised it wasn't just macro based.

Hi, I have a database with my staff in. If they are car drivers I take not of their Insurance and MOT renewal dates. I have built a query that gives me a reminder date ten days before and 5 days after the renewal. I also have an email function that emails my administrators the dates of these...

To be fair a function would be fine. I have created a query that holds the 10 days before date and 5 days later date so could pull the data from there? I just said macro cause I don't really know much about this kind of stuff. Cheers, Paul

Hi, Yes I've done that. One that has the date of the nenewal in it and then one with a date of 10 before and 5 after. But i don't know how to use those values in an email macro. Cheers, Paul

I have a table with dates for when Car insurance and MOT run out. I have an automated email that goes out to the admin staff to say when they need renewing. I wondered if it was possible to pull the data and email 10 days before the renewal date and then 5 days after to make sure it is done...