Search results

I got the query to return the exact same records as card inventory table! I think this is what I need. Thank you sir! Btw...how would I use this query to create a form where I'll be able to enter a new card and also enter it's proper transaction value for both buy and sell?

Ok...alright so take my buy query and my sell query and put those together into one??

Buy and Sell were just two queries I created based off of my table Transactions. I did this that way I could enter in a specific transaction number for the buy transaction and one for the sell transaction. I was advised when I started my database to only have one table for transactions and...

Will do. That was bad taste on my part. Warning well received. Thanks

Forced to??? No big deal...I didn't mean to offend anybody. My bad...I wont do it again. What's the big deal now??? It's over

Could you help me with this query? What do I need to do fo fix this issue I'm experiencing again??

It does help...thanks. I will say that your suggestion I have toyed with a few times, but it's not quite right so I haven't used it. The reason being is that a single card can have AT MOST TWO TRANSACTIONS. It may not always have 1, or 2, but I have to be able to allow for it. Take this...

anybody have any suggestions for my last post??? Here are some screen shots showing what's going on.

It appears I figured it out now, but how I did it confuses me. I went into my query design view and clicked the 'Totals' button in my top menu. It appears to have fixed the problem of the CARD ID's being duplicated. However, one thing I did notice is when a specific card ID has both a...

YES YES YES! I believe this is almost perfect. Tell me how we fix this last bug though... For ANY ONE Card ID, there can only be one BUY TRANSACTION and one SELL TRANSACTION. A Card ID doesn't necessarily have to have a value for either one, but a single card can have at the MOST one...

David, I think that's a great idea and something I have toyed with myself. However, the tricky part comes in with the 'add/select card' from a list. That's gonna take some work. I basically have everything else except this part which I'm working on now. Thanks for your suggestion...your...

Ok....I'm getting real close I think. Here's my latest SQL for my most recent query. SELECT qryInventorypart1.tblInventory.ID, [buy/sell].buy.[Transaction ID], [buy/sell].sell.[Transaction ID] FROM qryInventorypart1 LEFT JOIN [buy/sell] ON qryInventorypart1.tblInventory.ID = [buy/sell].[Card...

Hey thanks for the tips. Jeanette, After posting that SQL from instruction #2 in your post above, it wants me to put in a parameter for buy and sell ID??

I guess I could...I just don't think that would be the most effective way of inputting the data. Don't you think there's a better way? Thanks for the suggestion... Brady

SELECT tblInventory.ID, buy.[Transaction ID], sell.[Transaction ID] FROM ((tblInventory INNER JOIN tblTransactionID ON tblInventory.ID = tblTransactionID.[Card ID]) INNER JOIN buy ON tblTransactionID.ID = buy.[Transaction ID]) INNER JOIN sell ON tblTransactionID.ID = sell.[Transaction ID]...

One way that might be a possibility is to add two lookup fields to my Card Inventory Table. (Although lookup fields in tables is discouraged) I would create a 'Buy ID' and a 'Sell ID' field for my table. It would be a lookup of all the ID values in my transaction table. Wouldn't this work...

Thanks again for the response. I hear what you're saying about queries, but how else would I find a way to enter a transaction ID for selling a card and also buying a card?? That I'll have to keep working on...

Another member told me that as well...I will be switching that ASAP. However, why do I need a Primary Key field?? How will that help with tying more than one card to a specific transaction ID. Eventually, I want to be able to design a query that will have a field for entering a transaction...

Ok Bob...this query wasn't quite working for me after several attempts. I will try to head in a new direction. Thanks for responding.

Yup I do have backups! Thank you for your help!