I have two databases in Access97, one of the databases has 3 tables which are linked to the other. I just set the database passwords. the database with the linked tables has queries which use data from these linked tables. but now after I set the password the reports which run off these queries...
I have 2 small problems, hopefully someone can help me with. 1) I have a report which has calculations in them for many people. Sometimes though a person may not have data, and when you run the report you get a bunch of numbers as results but sometimes you get #error, im assuming its because...
is there any way to add or edit information from a query that selects info from multiple tables. I have a query that pulls info from three tables, I then need to edit a field from one on those tables based on the results of the query, but access keeps telling me that the records can't be edited.
...I have a field with the values M,T,W,H,F. Is there some way to sort it this way. Here is the SQL if this helps.
SELECT WeeklyResidentSchedule.*, Scheduling_Guidelines.Day, Scheduling_Guidelines.[AM/PM], Scheduling_Guidelines.Explanation
FROM WeeklyResidentSchedule LEFT JOIN...
I know that after you mess with the start up options you can bypass that by holding down the shift key when you open the database. Does that work for the database password that you can set up it tools > Security > set database password? just curious. If this is the case does anyone know a fairly...
I have this function in a report footer, =Count([Present]). The field Present has two values, "Y" or "N". I need to have a count of Present where the value is "Y". Any help would be appreciated.
I have a report which lists weather or not someone has attended an event simply by haveing a Y or N next to that event. I need to have a total at the bottom of the report which counts only the "Y"'s. Anyone know how. I tried =IIF([Present]="Y",Count([Present])) but that didnt...
I need to update the values of check boxes in a table. so in my update query i have selected the checkbox but no values that I enter in the UPDATE TO: area, seem to work I have tried true, "true", and some others. does anyone know how to do this?
I had to import some old data to my access database. this data lists a persons name with his/her year. ex.
Doe, r1
Doe, r1
Doe, r2
Doe, r2
Doe, r2
I need to make a query that will just select the first record of these repeating records. so after I run the query I get a table with
Doe, r1
Doe...
I had to import some old data to my access database. this data lists a persons name with his/her year. ex.
Doe, r1
Doe, r1
Doe, r2
Doe, r2
Doe, r2
I need to make a query that will just select the first record of these repeating records. so after I run the query I get a table with
Doe, r1
Doe...
yes the days of the week are in one text box. Its named [Days]. do you mean have five yesno fields named after each day and just check the days they can work? that would be a good idea, its just Im working with imported data from an old RBase and the data is listed in one field named days.
I have a report which lists for an individual person the days they can work. ex. M,T,W,H,F or a combination such as M,W,F. so it resembles this
john doe M
Jane Doe M,W,F
Tim Smith T
Bob Dell T,H
I would like to some how sort these results by days first by individual day and then groups...
I have a report which is based on a query. in this query there is a date field and you need to enter a parameter for a starting date and an ending date so I used: Between [start] and [End]. the query works fine and so does the report. I would just like in the page header of the report the dates...
sometimes while working with access I get a message asking if I want to empty the clipboard. What does this mean? and can I see the contents of the clipboard? For some reason access will not let me get into the design view of a table, telling me a form or query is open that it is bound to, but...
I have a table in a database that Im making. I am trying to open the table in design view but it wont let me. I keep getting an error saying that another query or form is open bound to this table but there isn't. it also says I may not have permission to open it in design view, but how can that...
tempclerk I actually did get the function to finally work but by having the table name it counts all of the [present] = true for the whole table. my report needs the count by individual person. aivars solution worked very well and it was simple
Thanx for your patience aivars, it did work. I know what the sum function is but what is abs, and why does this work and not the count. thank you though for your help.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.