Search results

Brilliant, thanks!

How would I use that? my expressions is already: Expr1: Avg([time_resolved]-[time_occurred])

Hello, I have set the decimal place property of a text box to 2. Then when i run a query that puts data in that box, the deci places are still well over 2.... It lokks to be over riding it, how do I stop this?

Hello, I cant work out why this but of code won't work... Me.priority.SetFocus it cant be much wrong, cause its one line!! any ideas? it just doesnt set the focus..

As the name suggests, the border wont change on some of my forms. Others are changing no problem. Any reason why this may be?

Yeah sure. I want it to return the fields: staff.EIN, staff.full_name, staff.email_address, role.role_name, team.team_name for the record in the staff table with a certain EIN (which is the primary key) and the user picks this EIN from the combo box located here...

thanks for the advice, doesnt seem to have worked though :( SQL looks like this after following that: SELECT staff.EIN, staff.full_name, staff.email_address, role.role_name, team.team_name FROM team INNER JOIN ((staff INNER JOIN role ON staff.role_id = role.role_id) LEFT JOIN...

Thanks!! Still getting a syntax error though :( SELECT staff.EIN, staff.full_name, staff.email_address, role.role_name, team.team_name FROM staff INNER JOIN role ON staff.role_id = role.role_id LEFT JOIN allocation_to_team ON staff.EIN = allocation_to_team.EIN INNER JOIN team ON...

This query wont work with a LEFT JOIN, I get a "JOIN expression not supported" alarm... Works fine with an INNER though... Basically, not every staff member has an allocation to a team, but I still want to see their records. Maybe theres another way to do this if access doesnt support Left...

Hello, How do I get rid of the warning messages when using a delete query? I then want to add a simple yes/no box, that will stop the query is no is pressed. Any help appreciated!

It's now returning data. Is there anyway to bring it back in a different format? currently its just in days. I'd like days and hours if possible? The date stored is in DD/MM/YYYY HH:MM

Sorry, it just doesn't return any data... (there is data in the table within the range so it should) Good spot, changed the where but still no data..

Hello, I have a table that stores two dates inside it, I want to find the difference between those dates for each record, then find the average of all the differences... The user enters the date range (for the first date field of the two in the table) using text boxes on a form. I've...

Brilliant, working now! Thanks

Hello, I have a text box, I have pasted this into the control source: =[qryIndividualFaultVolumes] then on a button I have this code: me.qryIndividualFaultVolumes.requery However, I get a Method or data member not found error when i click the button? Any idea why?

Hello, I have a query that pulls up the sum of records that holkd a date value between two dates, and groups them by the person that created them. How can I show these results in a graph? that will update everytime a user clicks a buttons (as they may wish to change the two dates to search...

Hello, I want to stop access adding a record when im on a form and press enter on the last text box. Or, it empties all the cells if its not a data entry (I think thats all it does) Is there any way to stop this? I cant see anything in the events properties?

Thank you!

Hello, This date function should return the date and time from exactly one month ago, any ideas as to why it wont?? =DateAdd("mm",-1,Date())+Time()

Hello, I have a form where the user selects an ID from a drop down, then the details are searched for using a search query and shown in the text boxes below it. I want the user to be able to make any changes to the data, but I only want the data to be saved once the user clicks an Update...