Search results

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...

[/B] This SQL doesn't use any of the fields I actually have in my table. I tried inputting it, but it doesn't work. I think you understand what I'm trying to do. I simply want each card ID to popup on a subform that relates to the main form's transaction ID number. Thanks for the...

Well, since I now have added a field to this table to account for shipping costs, if I put the cost (let's say $1.75 for example) into the column shipping costs for transaction #0050 and then put another record in (that being transaction #0051 to account for the shipping costs of transaction...

Thank you kind sir...are there any off the top of your head in your own experience that you can think of that would be unintended consequences?

I apologize for the delay, but I do appreciate the response. I was advised to go with this structure and I do believe it to be for the better. Here is what we're looking at. Please see attached screen shots. Thanks!

Hello, I have a table I created for keeping track of the transactions within my business. Up until recently, I would enter the shipping costs of something I sold as a new record (row) in my transactions table. I realized it would be much easier to simply create a 'shipiping costs' field within...