Recent content by JediYodaNT

Well, to explaing the flow issue. We have an older system that we are moving accounts off of and onto a new system. On "Date X" all accounts with the given prefix from the "Phase 1" list will have been moved to the new system (which my team does not have access to), and then on "Date Y" all...

So, I have a new project that I'm putting together for my team, and I'm sure it's something simple, but I'm at a loss for how to go about this. Any help you guys can provide would be greatly appreciated. I have two lists of accoutn prefixes, phase 1 and phase 2. All accounts with a prefix...

It seems as if the values I'm getting are the grand total from the entier table, instead of the values for that specific date. I'm not really sure why I'm getting counts that high.

Thanks Banana. So, I gave it a try, and as I was hoping for, I got the prompt to enter an Input Date, but the values it returned were way off. Any idea what might have caused that? dbDamo, is this were I'd enter the Parameter fields like you had mentioned? I was looking for a specific box...

Here's the crosstab query without any filtering. What would I need to add in order to get receive prompts asking for a start date and end date? TRANSFORM Count(Entries.ID) AS CountOfID SELECT Entries.Process, Count(Entries.ID) AS [Total Of ID] FROM Entries GROUP BY Entries.Process ORDER BY...

The problem is...it didn't ask me for anything. When I rn the 1st query in it's own, as I wanted, two prompt windows come up asking that the user supply a start date and an end date, which is what I wanted. Now, the next process needed to be a crosstab query that would provide my breakdown...

Hey folks. I could really use your help again. So, I created a query that lists all the transactions entered with a certain entry date, and as a criteria used "Between [Enter Start Date] And [Enter End Date]" which worked like a charm. Next, I wanted to have a crosstab query that would run...

Hello everyone. YOu guys have been a great help so far in getting my database up and running for my department. I've been able to get most all of my main Entries form completed and behaving as desired....with one exception. So, I've created a functioning link between the Function combo and...

Thanks again Scooterbug. I appreciate your breaking that down for me. Hopefully I will have time this afternoon to play with that myself and see what I can come up with.

Ok, so I'm looking at the tables you used. In the Associate table, did you create this field as a lookup to the ID number in the site table, or did you you simply type the 1's and 2's and create a relationship between the two? Sorry, I really am completely new to this. I just started...

Scooter, your example is exactly what I'm trying to do!!! Awesome! Thank you for the sample. It'll take me a little time to reverse engineer it so I understand exactly how you pulled these pieces together, but I'm sure I'll figure it out.

Well, I did in fact use a lookup, per the guidence of this guide. This technique worked great for my Function and Sub-Function synced combo boxes. http://msdn.microsoft.com/en-us/library/bb404901.aspx The problem is that I have not been able to repeat the process on the Site Associate level...

Ok, I'm a little turned around here. I am trying to do a similar thing here, but lack the training to know how best to do this. I thought I found a way, but it's not working. Reading this thread has me even more turned around. Situation: I have a form that I am working on. One of the fields...

That makes sense. Thanks for the warning. So, when creating my primary table, I'm just going to create two placeholder fields on the table, then when creating the form, I'll create two combo boxes and have the values from the combo boxes saved to the two place holder fields. If I'm taking...

Thanks for the link. I'll see how I can try to apply it.