Recent content by dnlbrky

Save the SQL as a query, and then just run it (once) whenever the source data (Sales) has updated and you want to see updated results for all months. You don't have to run it multiple times if there are multiple months. Note that this SQL assumes there is only one row in Sales for a given...

This thread seems very similar: http://www.ozgrid.com/forum/showthread.php?t=55840 Does it work for you?

Hi leobear. See if the following SQL works for you: It takes the original table (which I called "Sales"), and adds a column that subtracts 1 from the current month (to get the previous month). Then it joins this table (subquery, really) to the original table, but the previous month is joined...

It sounds like you have three fields where you should really only have one. I'm guessing a potential recruit can only be in one of the three states ("Current", "Archive", or "Recruitment in Progress") at any given time, right? If so, it would be better to create a table with a single field...

Thanks for your reply, Gina. I searched some more and found something that seems like it would work a bit better for displaying images: http://goo.gl/80Ery My vba skills are lacking, so I'm having trouble adapting their example (especially how to incorporate the "Use an http:// path in a...

No problem, PJSPS8. Glad I could help.

Create a named range for the data in Excel (http: //w w w .contextures.com/xlnames01.html), and then close the workbook. In Access, click on External Data and then Excel (in the Import & Link section on the left). In the window that comes up, browse to the Excel file, and make sure you select...

I'm a little confused about what you're trying to accomplish, but does the SQL below give you the expected results?

The title to your post mentions that this is a make table query. It sounds like you are creating a table, and expecting the resulting table to be sorted because the make table query is sorted. I'm not sure if you can do this from a make table--I think the table resorts to a non-deterministic...

Right-click on the table and select "Design View". In the Design tab (Access 2007 and later) click on Indexes. A window should pop up showing the info for all indexes. The first column in the window is the index name. It looks like the default value is "PrimaryKey".

I have an Access 2010 table with information about my contacts. I would like to show their Facebook profile picture in an Access form. I can store the FB usernames or IDs, and generate a link to the pictures (https :// graph.facebook.com/username/picture?type=large). How can I either store...

This may not be the best way to do it, but it should work... Create a table called "_Base10". Name the field "Number" (and might as well make it a primary key), and add the numbers 0 through 9. Number ------- 0 1 2 3 4 5 6 7 8 9 Create a query called "001_0to99" with the following SQL...