Search results

I'm trying to pass a parameter to a form that was created from a query and am having trouble. Below is what I'm attempting, but it still prompts me to enter a value when the form opens. DoCmd.OpenForm "frm_AllocationList", acNormal, , , , acWindowNormal...

Thanks kevlray. I was able to specify a range and that did the trick.

I'm sure this is easy, but I can't seem to find a way to do this. I'm very new to Access, so appreciate any help. Basically I want to import an excel file that doesn't have any column headings and the data starts on row 4. I already have a table with all of the column headings set in Access...

Got it, it worked perfect. Thank you so much. I'm very new to this, so trying to learn as I go. I appreciate the patience.

Thanks. Sorry, I'm very new to Access, which is probably why I can't get this to work. Can you look at the attached updated query and see if this is what you were describing? I seem to get an error when I try to run it.

Sorry, the filter criteria should also include "XX". So, Asset Group = FS, S or XX

See attached file. The "Holdings_Table" TAB contains all of the sample data and the "Query_Results" TAB shows the expected results of the query. I want to show a % of the occurrences of each Exchange, but only where Asset Group = FS or S or XX.

ENXL would be in the "Exchange" Column of the Holdings Table. There are thousands of records, so I only took a screen shot of the first few dozen - which is why ENXL isn't shown. Do you need a copy of all the data? Basically, I'm trying to Group By on the "Exchange" column and calculate a %...

Thanks plog. There is only 1 table. See attached pics for the "Holdings" Table and the result of the Query that I attached in the original post.

Hi everybody, I'm very new to Access and I'm attempting to write an expression in a query that will calculate the % of the count of "Exchange" field (Exchange is a text field and is grouped and the count based on each unique name) where the total count is based on the filter where "Group" =...

Hi everybody. My name is Jason and I'm new to this forum. Everything I've seen here so far has been great and I'm excited to continue my MS Access learning journey here. I'm new to MS Access, but I have done a lot of MS Excel development over the past 10 years. After seeing the expanded...