Search results

What is it exactly that happens when you try to open the database? How are you trying to open it, by starting Access first, or from a shortcut to the db?

If you're thinking that the ticker-less funds need a symbol because you're going to use that field for the primary key, I don't think I'd go in that direction. I'd use an autonumber for the PK so that it would get populated during import. The ticker can be stored in a separate field with some...

The symbol for the security . . . AAPL = Apple, AMZN = Amazon, etc

Edit: Posted in parallel to the two above me . . . sheesh! Is $5,548,437.27 the total of EVERYONE's sales? My guess is that's occurring because there is no condition criteria that tells the expression whose sales to total. It sounds like you want your query to total sales for a given...

Try starting without the where condition and then add it if it seems to be counting correctly and you don't get errors. =DCount("Pharmacy NPI Number","Main") If this is counting all rows in Main, then add the where condition to the end of it.

Maybe I'm missing something, but you're trying to count the occurrences in the Main table, right? Shouldn't you be DCounting the [Pharmacy NPI Number] in Main?

Edit: parallel post.

The data from any table can be exported to .csv format. If you database is relational, you may need to construct queries and then export the data from those. If you're using Access 2010 (and possibly 2007???), you can export directly to an .xlsx format.

Make a multiple section of the controls you want to resize using a shift + click. The hover over the side of one of the controls until the pointer turns into and east-west arrow. Drag to resize all at the same time.

If you have calculated fields in your table, then yes, you should remove them as it is not proper to store the results of calculations in a table. The code that Bob gave you is the essentially equivalent of a SQL query in VBA form so that you can use it as the Control Source for a field on your...

You didn't provide much to go on, but one thing you can do is construct your report to group by the individual. Then in the section header or footer, add a text box whose Control Source is: =Sum([YourFieldName])This will total YourFieldName for each individual.

If I read the query properly, you are totaling the Units for each 790ID. There probably isn't any reason to group by the CourseStatus since you're only considering the Completed CourseStatus. If you are trying to build a form that simply shows the 790ID and the totals, say, to scroll through...

Check to insure that the report's "Close Button" property is set to yes.

Is your form's record source the query? If so, just add the field from the query just as you would add a field from a table.

It sounds like you may not have the proper record source for your form. Insure that your query has all of the fields you wish displayed on your form and then design a form using that query as the record source for the form. You'll be able to add the count field to be displayed on the form.

This will get you part way. I don't know how to replicate what you get filter-wise from the ribbon. One thing you can do is to put a button on your form that runs DoCmd.RunCommand acCmdFilterByFormThis will put your form in a mode where you can select the filter using a dropdown selection...

I'm using 2010 presently, so I'm not sure what button wizard you are referring to. You can build a filter button from scratch easily. Use the button wizard to place a button on your form, but cancel the wizard. Go to the expression builder for the on-click event and invoke a filter with...

Have never tried this, but you might be able to use DSUM using a Shipped = criteria.

I think what I was suggesting in general is that you have to MAX the [Time Table] so that you only get the latest record and then JOIN (probably LEFT) that to everything else you've got going on in that query.

To be honest, I don't really understand what you've got going on. I know you are doing a query to count schools which you say is working properly. One of the fields, presumably in the query since it is not in the list of fields for the tables you posted, is "countofschool". Is this field...