Search results

Well...for my sports card database I put several different fields and subforms thinking it would be great to have everything right on one form. WRONG...there's so much stuff on there it makes it hard for me to view the information. So...here's the situation. On each sale or purchase I make, I...

just seen I never got back to you but thanks...this helps

Very well explained...thank you!

I now understand what you were saying back then...it makes sense. As I said, I'm a rookie to this whole Access deal, but I'm learning on my own with a lot of help from all of you. So, here's a thank you for helping me a long.

So simply, it will do no harm to delete the record and I don't need to worry about it further correct?? I've already accounted for this record in a newly added field for this same table so my numbers are still correct. The transaction ID is just my primary key to uniquely define each record...

Where's Bob Larson when you need him? LOL

You are correct and now I understand... I forgot about the totals for the query...that's what threw me off.

I get the feeling my ignorance is being pointed out??? LOL isn't this is what a forum is for tho?? To help others?? I ended up doing a crosstab query...should I have done that or not?? It gave me the results I wanted...calculated everything out perfectly except I've got a bunch of columns to...

thanks for all your input... To clarify, yes I do want to delete a few (records) transactions because I have properly accounted for them in another column. For example, I was creating a new record to list the shipping costs for a previous transaction. Well, I created a new field ([shipping...

I have a field called [transaction ID] in which I manually enter a new number for each unique record. 0001 0002 0003 0004 Just a simple question, if I delete 0003 then my 0004 will move up be right after 0002. There will no longer be a record containing 0003. Is this the best way to...

Do I need to do a crosstab query then? I did try one and here's the sql I came up with...I'm checking right now to see if it calculated the amounts correctly. TRANSFORM Sum(qryTransactionsNetPrice.Price) AS SumOfPrice SELECT qryTransactionsNetPrice.TransactionType...

I want to find the sum of the total price for each record that has the criteria in transaction type that matches 'card sale.' Or 'card purchase,' or 'memorabilia sale' etc. etc. Soooo in my table again, I have a record that is a 'card sale' and it has a price of $300. Again, I have another...

I don't have any option to do that, at least from what I can see. So starting at the top as shown in my screen shot, what would I do next? If I add a certain field, where is the group by option? Edit:: Found it LOL So now I have the field [Transaction Type] from my table so when I query it...

Please take a look at my screen shot...it will explain it much better than I could ever try in words. LOL Nonetheless, from the screen shot as you see, I would like to take [Transaction Type] from my 'tblTransactions' and find the sum of the total transactions equaling that certain transaction...

Thank you...when I get a minute I'll let ya know how it goes. Appreciate the advice!

it automatically scrolls down cutting off the top portion of the form. Why does it do this? I want it to keep at the same viewing level from record to record. many thanks! brady

no problem Bob...been busy too but I appreciate your help! I'll try and get those shots up here soon!

What happens when I want to put this form onto another form? Right now, I tried to put this form that has this search code in it onto another form, but it will not let me do that. Error in code... please advise...thanks!

Perfect...thanks for explaining that Chris. Maybe I should explain further what I'm trying to do with this form... I have a table for my customers, a table for my sports cards that I have, and a table for the transactions that occur with these sportscards. So, I need to create a form (to...

Wouldn't that have to be related to the table that the fields are referencing on the 1st tab? Could the subform be completely different and not related to the 1st fields in any way? thanks,