Search results

Hi everyone, I may be out of my depth on this issue, but I thought it was worth bringing to the forum anyway. Let's see if I can explain myself clearly... I have several (about 10-15) queries that I have designed to run monthly reports. Various pieces of the criteria for each query need to...

Hi, I have a table of data going back to 2007 that needs to be looked at on a monthly/quarterly/annual basis. I am able to filter the data when running a normal query by using Between [Start Date] and [End Date] in the Criteria section of the Date field. I now need to apply this same...

Hi everyone, I need to run a Query off of a Query. (Query 2 off of Query 1) Query 1 works perfectly, but it exceeds the character limit and therefore cannot be opened in design view. It can only be edited in SQL view. When I create Query 2 and attempt to add Query 1 in design view, I can...

I have three different databases from three different departments and I need to pull Date of Death information from each of them. If Database A has a Date of Death, great. I can just map in the Date of Death from Database A. But, if Database A is Null, Database B is Null, and Database C...

Hi Everyone! I am trying to use the expression below to transpose strings of 4-6 numbers (140504) to a string of 8 numbers with "20" in front (20140504). Some of the [Receive_Date] fields are empty or are 0, and in those cases, I need the expression to return a null value. New_Receive_Date...

I have a table with acct numbers of various lengths, ie: 246 18 36895 352119 472 I need to run a query so that all of the acct numbers are 8 characters long with zeros as placeholders in front of the actual acct numbers, ie: 00000246 00000018 00036895 00352119 00000472 I tried using the...

Hi everyone, I need to create a macro in access (my first one ever) that will automatically import roughly 50 excel spreadsheets. I have gathered that I need to use the ImportExportSpreadsheet action, found in the actions catalog pane, in order to do this. However, I am driving myself crazy...

Hi everyone! I recently started my first actuarial job and am completely blown away by the (seemingly) complex things I am asked to do in access. I know how to create basic queries and edit a tiny bit of sql code, but cannot do more advanced things like creating macros (which I was recently...