Search results for query: *

Hello, I am not very familiar with Access but am trying to learn. I am trying to figure out the best way to create a weekly report. I would like the report to look like this: Member Name Time In # guest Sun Mon Tue Wed Thu Fri Sat Doe, Jane 2:00 PM 2 x x x x...

Ok. This is what I have so far. It will give me an error message when the user enters the wrong member number but now it wont give me the message when the correct member number is entered. I know I am probably missing an Else statement but I'm not sure where to place it. Any suggestions...

Can someone help me edit my code to check for errors if the user enters a member number other than one that is stored in the member table? I have no clue how to do this.

That works like a charm. THANK YOU, THANK YOU, THANK YOU!

When I use this I get [highlight #FF99FF]"data type mismatch in critera expression"[/highlight]. DLookup("MemFName", "TblMember", "MemberNum=" & Me.MemberNum) This is how my tables are setup. MemberTbl MemberNum(PK) (text field) MemFName (text field) MemLName (text...

I have updated my tables so that they are normalized. This is what I have. MemberTbl MemberNum(PK) MemFName MemLName SignInTbl TimeID (PK) MemberNum dtmStamp NumGuest I have the following code for my command button. What I would like to have happen is when I click the...

I am trying to refer to a field in another table but I don't know the correct syntax. Can someone please help me out? I am new to this so I really dont know what to do. I have two tables : MemberTbl MemberNum(PK) SignInTbl TimeID (PK) MemberNum TimeIn NumGuest MemFName...

Thanks all. I got it working. Here's what I did in case someone needs it. PARAMETERS [type your date here] DateTime; TRANSFORM Sum(tblProjectHours.BillableHours) AS SumOfBillableHours SELECT tblProjectHours.ProjectID, tblProjectHours.BillingDate, Sum(tblProjectHours.BillableHours) AS [Total Of...

Hello all. I am really new to access. I am trying to create a database to keep track of the hours I work on projects each day and then create a report which shows the hours worked on each project by the week. The week starts on Monday and ends on Sunday. I would like to be able to prompt the...