Search results

I have created a scheduling database for my department at work where people put in requests. Unfourtunately someone is messing with other peoples schedules so each individual record needs to be password protected To do this I have created a seperate field in the table containing vital...

So here is the deal. I have a database built that tracks patients in a hospital. Each patient has up to 8 reports possible but only 1 report will be used at a time. So the report is built and at this point what happens is each patients information which takes up half a page has been printed...

So here is my issue. I have one table full of employees 64 to be exact. then I have them electronically place schedule requests by choosing multilpe options for what kind of shift they are going to work. One of the codes is ED. I now want to be able to run a query that will allow me to see...

thanks for the help. I ended up placing it all in the query for the subform and then giving a name. it did have all to do with that difference part of the equation on the text 14

nope same #name? I think it has to be something about calling it a date diff function in the box trying to be evaluated

No thanks for the try no error message but get a #name# message in the box

So i am trying to create a box that will display whether a new care plan is needed for patients. Right now waht I have the background doing is i have one box that displays the current date. A second box where you place in the date of the last care plan and a third calculated box. that words...

I am trying to create an update query that when run will simply ask in a seperate box similiar to using this line on the criteria line of a select query Like "*" & [Enter any char to search by: ] & "*" When i run the above code in a select query it asks me what records i want to pull. I...

Ok so i got the totals to sum but now i have a new problem. One of the options is 1l and andother is 1s. How can i tell access to calcualte it by assigning 1l a value of 1 in the calculation

Thank you that fixes my problem on the query now how do i fix it so each day can be totaled in the report footer

So here is my problem i am semi access savy but i have having trouble with one thing. At work when we make a schedule there are 5 possibilites for how you want to mark your day. I have created a field using text as my parameters since my possibilities include both letters and numbers. At the...