Search results

So I used the Builder in Access to build the formula for my query, but when I go to run the query I get dialog boxes asking me to Enter parameter value? What am I doing wrong?

Ok, I'm really not sure how to write SQL yet so hopefully someone can help with this. First, from advice I gained from another forum I have made separate LENDERS and DEBTORS tables to make things more clear. Aside from that change, things are set up as I explained above. I would like to create...

Ok, so use an AutoNumber field to speed up queries in the future instead of using the usernames? The LoanStatus in tblLOANS comes from tblLOANSTATUS. Do you have any good reference you can point me to for figuring out how to do queries that calculate the scores?

Ok well I'll try to keep my questions here then. The database will be to keep track of USERS and LOANS. I am planning on the following tables: tblUSERS(UserName, JoinDate, Posts, Notes) This table will simply store records of users and basic info about each. tblLOANS(LoanID, Debtor, Lender...

I do have a book (2 in fact) and I'm currently taking a course in Access, but I learn faster than most and was hoping someone could help talk me through things. I do not want someone to build this for me, but rather I'm looking for someone who I can chat with and make sure I'm doing things...

Hello everyone, First let me start by saying I am very new to Access, although I am extremely proficient with Excel and VBA. I want to begin learning both Access and databases in general and I have a small project to work on to help me learn. The project is as follows: I am part of an online...