Search results

I have a report that I have to run that is supposed to show a list of 4 digit codes. However if the code happens to start with zeros it will not display them. Example if the code is "0062" it will only show as "62" but I need it to show all 4. I've tried to use input masks but other than that I...

Thank you. That worked! I wondered if it would be something simple like that lol

I have a query that I want to be able to export to an excel spreadsheet with the date appended to the file name and then also auto-format the spreadsheet. I can get the export and the date to append just fine using this module Public Sub AutoExportReceipts() DoCmd.TransferSpreadsheet acExport...

I couldn't figure out where to plug that in at lol What ended up doing was creating a query that pulled the previous week using something I found on another site Year([Payment_Date])*53+DatePart("ww",[Payment_Date])=Year(Date())*53+DatePart("ww",Date())-1 then referenced it in the dsum instead...

So I am not very good at writing criteria. I have a column where I would like to total the number of payments made by a client for the previous week. Here is what I have so far. DSum("Payment_RentTransaction","TblRent_Report","ID_Number=" & [QryClient_CurrentResidents]![ID_Number]) That's just...

Hey, I'm trying to use an aggregate function inside another aggregate function and I'm having a difficult time. I don't really know what all I need to put in here. Here is what I have: dlookup("Amount_Owed", "TblRent_OwedAtDischarge", "ID_RentOwed = " & DMax(""ID_RentOwed""...

Sorry I haven't been on too much this week. I apologize, I'm not too good at explaining myself on here. I was just going to up load what I had so you could see but some how (I'm still not sure what I did) I got that message to stop coming up.

It's a query. I learned not to use spaces in names only recently. By then I was most of the way into building this thing. It does get a little frustrating at times but I'm getting very used to when to use brackets, underscores, and/or quotations. The idea of having to change all of the code...

I wouldn't be able to tell you. I don't know anything about SQL. I just use what ever access builds when I'm in query design haha

UPDATE [Meetings 1] RIGHT JOIN [Current Residents] ON [Meetings 1].Resident = [Current Residents].ID_Number SET [Meetings 1].[In House] = Nz([Current Residents]![In House],0)+Nz([Current Residents]![In House 2],0), [Meetings 1].[WHU] = Nz([Current Residents]![WHU],0)+Nz([Current Residents]![WHU...

Just checked it again. Brackets are where they should be and the spelling is correct.

I'm sure this is a round about way of doing something simple but it's my first time trying something like this and it's the best I could come up with. I have to append to and update 5 fields ("Resident", "Meeting Date", "In House", "Outside", and "WHU") in a table named "Meetings". The record...

Here is how I have it set up. I followed an online tutorial to make it.

I've tried that but it creates a new record at the bottom of the page like I'm adding a client. I'm usually entering several days worth of class records in at a time, I'll put in the attendance for one date and submit it and it get's recorded on the correct table, however the values in the text...

Yeah, I'm finding that out.

I have two issues I'm running into tonight. Using a continuous form I've created a basic roll call where I am able to enter the date of a class and track how many classes each client attended using an append query. The clients ID #'s are being pulled from their info on one table (where most of...

I just go it. thank you that was an awesome idea

I've never done a Tab control before. That would make things so much easier. How is that done?

I'm very new to access and I've tried looking on the internet on how to do that but I can't quite find what I'm looking for. Here's what I have: A table that hold my client's info [residents] A form that searches all of the records [search_form] and 3 forms to enter in the client's information...

Hey Everyone, I'm very new to the whole Access thing. I've tried messing around with it in the past but didn't get far. I made my first working database for my work at the beginning of the year and it's been evolving slowly as our needs have changed. I don't really know anything about writing...