Search results for query: *

Hello all..I'm having some difficulty trying to figure out how to delete a space in a field if the first character is a space? I have a series of loan numbers..but some of them, when imported, have a space as the first character. How could I construct a query to look for those and delete that...

Good morning, I'm having a problem building a query on a type I've not worked before. Here's the situation. I have a field (we'll call this a FEE) within a table that contains multiple fees for a given loan number. I have another field (we'll call this a REMAINING AMOUNT) that contains an...

Hello all, I'm trying to figure out how to build a timed event that will close my access database at 6:30 in the evening. Now I know I can use the timer event and based on a certain intervals, but that won't work well. Can you advise of a solution? Thank you in advance! Mark

Hello all....I can't seem to find a way to query Odd or even days. I'm working with a date field....although I imagine it would work with a number as well... Could anyone help me? Thank you! Mark

Hello everyone. I have a problem I'm Trying to resolve. I have a control in a report called [Completed]. I have, at the bottom of my report footer, a count for that control. The range of values in this control is either "yes" or "no". I can't seem to count these individually. Can someone...

Hello all. I may be going about this the wrong way, but I'd like to password protect a control that will open another form. Is this possible? Or is there a better way to go about this?

Awesome....and a very quick response. Thank you PH!

I'm obviously doing this wrong..can anyone figure out how to fix my problem? Thank you! DatePart("yyyy",[date_maturity]-10)

Good morning everyone, I have a question I hope someone can help me with. I would like to delete any duplicates in a query. Now I understand I can use the "find duplicates" query to identify, however if I were to delete those records, woudln't that also delete all instances? How would I go...

Afternoon everyone and Happy Friday! I have a question I'm hoping someone can help with. I have a subform that is tied to a query. I would like to have a box which will ask the person their first name (I already know how to do this part). What I would like to do...is based on what name they put...

Thank you. Oddly it's not working right for me. It's showing everything on the same line with Squares between each piece of data. This is a memo field, does that have anything to do with it? Here's how my query looks: t_notes: [temp_table_MI]![t_notes] & Chr(10) & Chr(13) & "Topics...

Hello all, I'm trying to figure out how to add a return when pasting several controls into a memo field. what I'm trying to do is add return lines after each field. For instance: [Control1] [[Control2] [Control3] When I'm creating the query, I use: [Control1]+[Control2]+[Control3] How...

Ahh...excellent, thank you for the quick response!

I have an iif statement that I'm not doing right. Can someone correct this? Thank you! F5: IIf([Welc_AK20060328]![Field5]="000" Or "TX75087000","good","Not good") right now it just returns all "good"...even though there are all kinds of different data.

Does anyone know how to setup this query? I'm trying to find out how to delete the first, say 5 characters. Example would be Pre-qry 0001974668845 post-qry 74668845

I guess In the end I'm trying to code the following, although I know I can't use a where in this statement? =Sum([Clundquist]) where ([month_day_today])=([month_day]))

Thanks for your help. Actually I added a month (datePart) control so that works..probablem it's counting everything. =IIf([month_day_today]=[month_day],Sum([Clundquist]),67) What I'm actually trying to accomplish is this: I want to count all day's records where month_day_today is equal to...

Hello everyone, I'm hoping someone can help me correct my code (which I know isn't done right). Here's what I'm trying to do. What I'm tring to do is sum up the field "Clundquist". However, I only want it to sum that field if the current month (formatted date part in date_today) is equal...

One more thing.....I tried inserting a popup function so the person enters the number of loans to transfer. This would also work just fine for me (I don't necessarily need to use the drop down control). However, my code brings up an error. Can you tell me if this could work? INSERT INTO...

Actually this would be an append query. I really wouldn't use a report. I'm basically trying to click a button so that on click function runs an append query. That append query would look at a forms drop down list to determine how many records it's going to append.