Search results

x_x' Since I am such a newbie at this....How would I go about setting up the NotInList event for the Combo box?

I've been attempting to make a form with the form wizard, and most of it has been going swimmingly until I realized I could run into a potential problem. So I have an Office ID and Office Name in one table and another table with all the information in the those offices. I've linked them...

Wait. How do I do that? If I have an autonumber primary key, wont it give keys to every single patient name? How do I get it so that it doesn't count the duplicates?

I think I might've actually figured it out. I used a working query that counted the patients correctly and added the table it to the query I'm working on. Then I linked the first name and last name together. o__o I think it works...*goes to check*

=_=' It uniquely identifies patients with their first/last names. You can yell at me. I know this is really bad, but this was the only information given to me when we first started, even when I mentioned they needed their Patient IDs, and I then it would involve me having to go into 500+...

I am working on a query for a family friend, and after setting up the columns, I'm winding up with a problem. I am trying get the query to count the total times a person has visited the office under certain values, "W", "WI", and "CO-TX" in a column called [Ser]. If it was a separate query...

That last half of those instructions kind of flew over my head. o_o' Thanks for the suggestion, (and pardon the late reply, I actually thought I had already posted this but I guess I forgot to hit the button at the bottom.) I'll probably try this on my spare time when I get the current...

Kinda, I guess? I took a look at their current program and it looks pretty unique. The main problem is, no one bothered writing it into the (one and a half year's worth of) Excel sheets they've been using (heck, I already have to go into each one of them and change the fields so they're...

Yeah. I was thinking the same thing with two john smiths. Fortunately, there hasn't yet been two people with the same name (oh thank the heavens). And I think they'll be putting a note on that in the future when they run across it.. Unfortunately, they don't wish to use an ID number for the...

Well....I did some tweaking and I *ALMOST* fixed the problem. SELECT [Financial Daily].[First Name], [Financial Daily].[Last Name], (SELECT COUNT(*) FROM [Financial Daily] AS T WHERE [Date Attended] between Nz((SELECT TOP 1 [Date Attended] From [Financial Daily] AS T WHERE [Date...

CJ, I took your advice and changed the fields (and added an additional field) so there is a [First Name], [Last Name], and then [Date Attended], I've also added two different people with similar first names and similar last names together (a Jane Smith, and a John Carpenter). While the change...

Oh my gosh. It works. I bow before you and your awesome knowledge of Query making, good sir! Now to figure out how the process works so I can write another one in the future. THANK YOU AGAIN!

Pleasant dreams, and thanks for helping out. I'll keep on trying to get it to work in the meantime with my limited Access knowledge.

Would it be something like (and I know I'm butchering the language) Count(IIf([Closing]=no, [Date], "")< Iif([Closing]=yes, [Date], " ")) Or something of that sort? It's probably incorrect...and it'd have to count the X after the date as a new entry. x_x my brain hurts. Here's the...

This is what I basically wound up with the first time. It's counting the total entries checked and the total entries unchecked instead of the dates from one checkmark to another. Name_-_Times Visited - Closed John Smith - 2 - (checkmark) John Smith - 6 -

So what's coming up right now is just names and the total times visited So John Smith - 8 I'm trying to get it so that it'll stop counting a section once there is a check box in Closing. And then the next date it'll start counting everything after the check box until the next Closing.

Bob, I am getting an error box with, "Your query does not include the specified expression 'Iif(Not[Closing]=0, "yes"," ")' as part of an aggregate function. I'm guessing there's something wrong with the formula? Oh wait, I'm copying and pasting the same thing. BLAH. hold on a sec. Edit...

Just to let you know, "Times Visited" isn't Correct and I'm doing this in Design View..x_x.. SELECT [Financial Daily].[Name], Count([Financial Daily].Date) AS [Times Visited], IIf([Closing]=Yes,"yes"," ") AS Closed FROM [Financial Daily] GROUP BY [Financial Daily].[Name]...

SOLVED: Newbie doing Queries - Help would be appreciated For the last week and a half I've been thrown into Access and my SQL skills are pretty much abysmal so I'm doing this in design view, just throwing this up here now. I am working on a patient data sheet, and I'm trying to set up a query...

Hi there! I am a new member and a newbie to Access. I will probably be in here a lot from now on, seeing that I've been drafted to create databases and queries for a family friend. Hoping to get some answers to a bunch of different questions. :D