Search results

I import a CSV field which has not preserved the CR/LF when it was exported from BCM Remedy. There is no setting for that. The memo field prints on my report like this: 2012/05/23 3:13:45 PM PCOLLINS This is not considered an emergency, but should be reviewed in more detail to see if this site...

When I export my Remedy data to a CSV file, it automatically removes the CR/LF (not sure why). As a result, when I import the CSV file into an Access table the field becomes one LONG line of text. FYI, the import specification has that particular field set up as a memo field. Here is an...

I had been deleting and overwriting an existing table with imported data in a Event Produre on a form opening. It has worked fine for the past couple of months. I then created a relationship between that table and another, and discovered I can no longer delete the table as it has a...

I have a table of data I run a query on. The table has a location code and a account code. A location code can have one or multiple account code records. I am trying to write a query that does the following: Filters ONLY on location with one specific account code + at least one other account...

Is it possible to apply conditional formatting on a field in a report based on the column number relative to other columns. ie Jan is in column 2, Feb is in column 3, Mar is in Column 4? The conditional formatting is to identify the fields which are "future" and only estimates, based on the...

I have a table which is a snapshot in time for monthly cost of a service. Each service has a start date, and if the service has been canceled, it has an end date. If the service has not been canceled, the end date field is empty. I have a form which allows the user to determine what "year"...

Importing into MS Access (Solved) I have an interesting problem. I have an Excel spreadsheet I want to import into MS Access. I have preformated all the data in the spreadsheet. I have several text fields, two date fields, one long integer, and four currency fields. If I save the file as an...

I am using a form to determine if a user wants to include all locations, All HQs, Divisional HQs, or only the National HQ in their report. The pulldown in the form gives them those options. The database itself is imported and doesn't have a field to determine what type the location is. So, I...