Search results

Any idea guys?

Hi guys, I have been managing a database system for a homeless shelter in my volunteer role. There is a certain feature that would help improve accuracy of the inputted records, as well as freeing up time for staff. That is - auto filling a user's Gender and Nationality when inputting a record...

I managed to get two seperate queries working - one with calculates the amount of blank fields each staff member has left in the Staff_Driver column, and another query that calculates how many blanks each staff member has left in the Staff_Passenger column. Can anybody suggest how i could...

Alan - It is definitely an aggregate query I am using, I have narrowed the problem down to the Staff_Driver column because when I remove the relationship with this column then there is no problem with the query and the Staff_Passenger column counts perfectly. I will have a look at it further and...

Thanks very much for your help Alan. I did as you said, however when I run the query I get the error: "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data." Any idea how to solve this?

Forgot to mention that the purpose of this is for staff training and to make staff aware of how much fields they are leaving blank, in order to try and reduce this and improve the quality of data. (I tried using the required property in the tables but soon realised that this was causing errors...

Hi, I am an admin volunteer in a homeless shelter and I’m in the process of creating an Access system for the office, I just need help with one final bit. Currently there is a table called Outreach, which stores all the records detailing staff encounters with people on the streets. Two of the...

severin your sql code worked perfectly, thank's very much.

I cant seem to find a way to private message :S

I will pm you the download link for my database.

Thanks for the reply, I have thought of one way, maybe you could have a look and suggest some help. I have created a form named 'Calculate Totals'. There are 2 datepicker fields name 'Start Date' and 'End Date', which are used as criteria and allow the user to specify the date range. Each...

Hi guys I am new here, I am a university student helping out in a homeless shelter that has lots of admin work. Currently the Excel system they use is slow and laborious, as well as full of errors, and I am creating a basic Access system to help. One main laborious task is to count the amount...