Recent content by hunterfan48

When I do the query design and add my two tables, it automatically pulls over my relationships that I've shown in my original post. Why are no values returned when I leave the relationships there?

Any ideas?

I've posted my relationship screen so you can see what I'm working with. I want to return the price from my transactions table for the value '1' in the ID field in this transactions table. That would be my first field in the query. The next one would be to do a sum of the sellprice field in...

That sample database above works great. What if you run into more complex entries? For example, there may be 2 credits needed and only one debit. How would you account for that in your journal table when one line only allows for one entry in the debit and credit fields?

I have a question about your database...can we discuss please?! Thanks! Brady

I'm using this query as a subform to match up with my main form. I have this subform on a tab. It does exactly what I want it to. When the transaction ID changes, the subform changes to match up that ID value from the main form to match up with any cards that has that same ID in either the...

Guys, I'm sorry. I didn't receive any emails letting me know of your recent posts. I'm not getting help from another site and you guys have been all extremely helpful and I'm grateful for that. The SQL is working. The reason it was giving me a parameter value was because when I double...

They are still the same...nothing has changed.

UPDATE: I think this is working now. I'm sorry for the confusion! Can I only make changes to his query in SQL view?? I'd like to add more fields to show up from my inventory table. ok...I got it now. I apologize for my mistake. I had my field names entered wrong. transactionID is actually...

My inventory table does have a BuyingTransactionID and SellingTransactionID that are a one-to-many relationship to Transaction ID in my table Transactions. A single card ID may have more than one transaction ID. For example, that specific card ID may have been bought with transaction # 0023...

Your thinking is correct in trying to get it to do what I want. But the query isn't working. It is asking me for a parameter values. How can I just get all cards to be returned?

You are 100% on with what you are trying to do. Now we only need to get this code to properly work.

It wants me to put a parameter value in? Let's say I have 100 cards (100 records) in my inventory table. Well, this query that I want to run, I understand that because I have both a buying and selling field within my inventory table, one card or record might have to be repeated twice in...

Ok guys...thanks for the tips. I'll be sure to check further into this to make sure my database is sound. Back to the original question though, how can I get a query to return all card values that match a specific transaction?

You were very kind to take some considerable time to evaluate my screenshots and provide some much needed feedback. Please don't take offense at any of my replies. I'm just simply typing what I'm understanding. I do realize that I'm the new one here trying to learn, asking questions, etc. I...