Search results

I am not an expert. what will the SQL of of the Query2 be? should put the dlookup in the subquery?

How to get a value from previous record in a query The Following query has brought records for John’s math record from student’s score table named MyTable Query1 ID ---- Studentname ------ subject ---- score ---- month . 12 ----John ---- ---- ---- math ---- ---- 17 ----...

thank you for the instruction. well. when i look at the table i see a student name such as "John" or a subject such as "math" is repeated too many. These are foreign keys. I was still wondering if we could avoid having too many studentID and SubjectID in the table. However i am also thinking...

they get the grade every 3 months. I missed another column. with the respective date

I am going to record student’s scores in a table like the following : Student names are looked up from student_list table and subjects from subject_list table. students_cores table: ID, studentname, subject, score 1, john, mathematics, 80 2, john, physics, 87 3, john, history, 75 4, john...

Some employees are too distracted. Making one click to make two record in a sheet is easy, but making the second click will need extra IQ and attention. I wish it was possible to be done in one sheet.

Please help me to make this report: We are making an invoice which should be split for the costumer and also the store. Can we design a report to have the same identical result in one page such as the following? customer name: Akbar Bond Service-ID product adviser cost 54...

We have the following table: EmpName Payment 1 Jack 160 2 Steve 95 3 John 47 4 Jack 25 5 kate 12 6 John 23 7 Kate 21 How can we get the sum for each person? A result like the...

I still need to know the solution. any help with more detailed guidance to an un-expert dude is appreciated.

i am havuing the form in data sheet view. in data sheet view there is not a footer.is that right?

I have the following form based on a table: empName salary working jack 1000 yes/no Steve 1500 yes/no Janet 200 yes/no summary: [number] fields “empname” and”salary” are...

I have a report. I go to report properties, and open the record source to reach the query on which the report is made. I make some changes to the query. When I close the query it asks me to keep the change or not and I click yes. But when I close the report it doesn’t ask me to keep or discard...

thank you jdraw, the issue is i want my access file to be opened only in a specific computer, so that if the file is stolen it does not open. Solo712 provided a function. i am not an acces expert, so i dont know how to change that function if my computer mac is ff:ff:ff:ff:ff:ff. moreover where...

can anybody help me on this please?:(

There is a form with some fields and it has a button which goes to the next records. how can we make the button inactive otherwise all or some of the filed are filed? Thank you

Different users are putting data for our customers. How can we figure if we are making a duplicate record for the same costumers and prevent that? I mean for example a costumer name is “Scarlett Johansson”, and a record is made for her. Then another user is entering the same data for the...

thank you very much, lets imagine my machine mac address is ff:ff:ff:ff:ff:ff. then where in your formula i should put it. And where i should put the whole code? will the code run automatically when the file is being loaded? thank you very much

I am putting the student names in a form. I want it to alert me that a name is duplicated. But thats not this simple. For example a name is “Jennifer Locus” but I type “jenifer” with one “n”. Can access guess that this might be the same person and suggest me to correct the spelling or enter it...

thank you but i could not figure if i open the box properties and then, on click, then what i should write there. can anybody advise?

I have made a table which contains the data from some companies, such as company name, phone number and address, website, etc. I have also made a report over this table. How can I make this report, so that if I click on the box that has the company website, it automatically open an explorer...