Search results

I agree with jdraw on this. Try and explain why. However, one thing you could do is make to make a new table with on of them and then do an append query on the second table and map the fields accordingly.

OK, So I did a make table query on my original table with the filter and then a append query with the new table. Let me know if there is a better way or if I might be missing something on this.

CJ, That worked exactly like I wanted. One last question. Any ideas on how I would combine this new query and a query that filters out the kits into one? I have new field names for the quantity.

CJ, Thanks for this. Will look into this later today and get back to any other comments/questions I may have.

Yes, I am still asking a question. I have attached a new file: Lines 1-9 shows the current transaction table (What it is) Lines 12-25 show the new transaction table (What I want it to look like) Lines 33-40 show the Kit Component table. What I would like to do is figure out a way that when...

My data is normalized And I have linked the sales table to my Kit Component table. I guess, I am trying to figure out what to do next to make sure all of the customer info flows and the right values come out for multiple kits. (I hope my example spreadsheet made sense)

This may seem too rudimentary, but did you try Compact and Repair the database? Sometimes if the file size starts to big or becomes overly complex, Access crashes.

I have looked for a similar question, but could not find one like it. I am not even sure if this is the right place to put this question, but here I go. I have a table of sales information. Part of my products are kits that are a combination of individual products. (Think of it as a value...

Figured it out on my own through a different resource. http://www.techrepublic.com/blog/microsoft-office/run-a-parameter-query-within-an-access-form/

Plog, The begin date of the would be based on the input in the form, which would be allowing the user to input the date on which to calculate.

I am trying to build a query based on a number of factors. First, I am referencing a table of sales [ALL_SALES_DETAILS] and data within a form [frm_MainMenu]. In the table, one of the fields is the the transaction date [TRANS_DATE] and I am trying to figure out the [MaxOfTRANS_DATE] based on...

No like queries or domain functions (However, I am doing a Sum based on Groupings and Where's). Do have an indexed field that a Join is based on.

I am having an issue running queries. They are just running very slow. I have split the stand alone tables into a separate file, and compacted/compiled the heck out of the database to be about 1% of the original size. However, the queries still run slow. Most of the linked tables I base the...

If you want the grouping to start a new page, click within the Footer for the group, Go to the Report Design tab, use the Insert Page Break. It will show up like this ----- Then move it to the bottom of the footer so you include everything. Hope that helps. J. __________________ Please...

JHB, I have. Should have put that out there too.

I have searched and searched and cannot seem to find someone with the same issue I am having. Any/all help would be greatly appreciated. Background: I have a huge database of transactions by item. I have written a query to pull a portion of the transactions based on date/product family/etc. I...

Thanks for this. I open the same table when I open a file, so I did the same thing just for the table.

Thanks Rain..will do. I think I already found out one solution to a question I did not know I had.

Hello all. New member here from North Carolina, USA. I have accessed this site looking for advice/direction for some time and finally decided to take the plunge. I use Access (2010) daily in my job and have used Access to some degree since 2001. Everything I know is self taught. But...