Search results

Thank you! That has helped a lot!

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, Yes, I am still pretty new to Access and was trying to use 'enourmous nested IIF constructs' because my boss told me he only wanted me to drastically reduce the number of queries I need to run in order to produce the reports we need. I have to do some many data transformations to the 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...

Sorry, I should have said 'Tables' rather than 'Databases' originally. I imported tables from three different databases into my final database to create the query.

Nevermind... the expression above actually DID work! I just had a type in the expression.

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...

Thank you SO much! That worked perfectly and I was able to apply the concept to another two expressions. =)

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...

Amazing, thank you! Worked like a charm.

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...

Update: I was able to import excel files using the TransferSpreadsheet action. Thank you so much!

That is very possible. I was following this set of directions when I was looking for ImportExportSpreadsheet: smallbusiness.chron.com/import-excel-spreadsheet-access-macro-42538.html I'll try TransferSpreadsheet and see where I get. Thank you!

Thanks for the response! I did click the 'Show All Actions' option and looked through the available actions in the drop down tab. ImportExportSpreadsheet is still nowhere to be found. Any other ideas?

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...