Search results

As I was working on an Excel pivot sales report based on MS Access records, I came across an Excel conflict between its ‘Top10’ ranking (sorting) functionality and the ‘calculated fields’ functionality that I also need to use in this report in order to find the differences between the sales...

Hi there, I’ve got stuck in preparation of this sales query. The primary sales table contains a mix of Canadian and the US detail invoice sales records. All sales records are in their native currencies The secondary lookup table contains daily US/CAN foreign exchange rates (FX). I need to...

I am working on a typical sales query and I need to generate three new fields based on the Date field. For each Date record, I need to calculate its pertaining: - fiscal accounting month - fiscal accounting quarter and - fiscal accounting year the date belongs to. Fiscal Months: Unlike...

I am getting the following error when I try to link MS Access 2010 to a SQL Server Express 2008R2 table: 'idx_table name' is not a valid name. make sure it does not include invalid characters or punctuation and that is not too long. Details: - the table name is: italpasta-etp.etp.timehistory -...

I need to filter two date ranges from the table. The table contains the date entries from Jan 01 2007 - Oct 24 2008. The requirement is to filter the following date ranges: Jan 01 2007 to Oct 21 2007 and Jan 01 2008 to Oct 21 2008 This needs to be done using the Design View and not the SQL...

I need to insert a calculated field in my query that will for each calendar date record show which fiscal month the date belongs to. The START DATE for each fiscal month is the the first Saturday after the last Friday in the previous calendar month and the END DATE is the last Friday in the...

Is there a way to setup Access to flush all data stored and re-load with new data while keeping intact the table structure, queries, etc...? If so, Access should do it in an automated fashion every night. The reason I am asking is that this new report writer I work with does not work if Access...

I was wondering if a new Access query can be built to replicate the sample Excel report attached (sheet name: "US"). The working Excel report cannot handle a large number of transactions involved and I am forced to do everything in Access. My challenge is linking the existing sample Access...

I am working on a query where I have two selection criteria that affect each other. The first one (field: "accnum") excludes all string values that begin with the "US" while the second one (field: "desc") keeps all values that contain string "MONTHLY". I need to tell Access to "force" the first...

I have linked Excel with a few Access queries via Data>Get External Data>New Database Query option. Everything worked fine until I moved the .mdb to a different location on the hard drive. Now whenever I try to refresh from within Excel, I get the following message: "Microsoft ODBC Microsoft...

I am relatively new to Access and this question may be silly but I'll give a shot; I have been designing a company report based on the sales records exported from the company's accounting system. I already have an exported set of the last year data in Access. My intention is to run daily...

I need to trim the following query field: "LQ2daily.description" from both left and right side. The field contains text strings like this: FG - Prod - Mfg Sub-Totals --- FG - Prod - Mfg - Whole Grain Sub-Totals --- FG - Prod - Mfg - Egg Sub-Totals --- On the left side I need to trim "FG - "...

I have a requirement to build a query based on three sales tables. The challenge is that the "product pricing" and "rebate" fields are in their native currencies (Canadian dollars, US dollars and Euro). The US entries are flagged with the "U" values, the European entries are flagged with an...

I have a challenge importing a space-delimited text files into Access if one of the fields contains multiple words separated by a space. For example, the "Description" field: Date Description Amount 05/14/08 This is a first line $1234,50 05/15/08 Another line $9876.20 How can I tell Access...

Please find attached a sample query... Is it possible to create the following logic in query: "If there is a "SHIFT2" or "SHIFT3" value on the last Friday in month, then change the date values for these entries to the next date (Saturday)" In the attached sample, there is a number of such...

Is it possible to group and summarize fields while in a query instead of doing it in the report section? Please find the query attached. For each day, I need to group the "Expr1" field (shifts employees worked) and "Date" field and to summarize their corresponding "Cases" and "LBS" values...

Is it possible to convert the text field that comes in this form: :80421 to the following datetime format: MM/DD/YY 12:00:00AM Please note that the text field contains a colon at the beginning. The number 8 represents a year (2008), the 04 represents a month (April) and the last two...