Search results

Yes, ideally once a month. There may be situations where it needs to be uploaded other times in the month, in which case it would delete the existing data for that month, then import. I realize once a month is not often for the user to delete one space character, and it really isn't a big deal...

Well it will actually be different file for each month, so there will be several files to which it would need to link. And I've found that when a table/query is linked to an Excel file, it has slowed the database down.

Is there a simple way to just skip importing this field? It's actually not a necessary field. I just don't know a way to skip a field on an import.

The file comes from a billing system we use. The user will export an Excel output and save it to a specific folder under a specific name.

Hello, I'm trying to set up an import of an Excel file. One field in Excel, "Sales Tax" has a lead space, so " Sales Tax" is its Excel name. Since I can't name a field in Access starting with a space, the only way I know to import properly is to manually remove the space from the Excel file...

@Plog your last post got me thinking. In the underlying query, I used the same iif statements for [previous renewal] as I did for [nextrenewal] (iif x is null...,null,y) and that fixed the problem. Here is what it looks like:IIf(nz(RenewalDate,"")="" Or nz(RenewalMonths,"")="" Or nz([Periods...

I don't know if this helps, but [previous renewal] is based directly off of two other fields: nextrenewal (date field) and renewalmonths (number field). When I change the criteria to WHERE nextrenewal = #7/1/15# or when I change it to WHERE renewalmonths = 12, it works fine.

It's a little messy...tblContract.FirstRenewalDate, tblContract.RenewalType, tblContract.RenewalNotice, tblContract.RenewalDate, tblContract.RenewalMonths, Int(DateDiff("m",tblContract.RenewalDate,Date())) AS [Months Since], IIf(nz([Months Since],"")="" Or nz([RenewalMonths],"")="",Null...

I'm having trouble getting it under 2 KB. I stripped it down to all but 2 tables and 2 queries. I stripped the tables down to 10 and 28 records. I even deleted unnecessary fields. There is no code, no objects, no links.

plog: Yes, [previous renewal] is calculated in the underlying query. I should have specified that. I tried to the datevalue(), but it did not work. Same error. I even tried wrapping datevalue() around [previous renewal] in the underlying query, but to no avail.

Yes, I'm using query builder. The format of the original field was set to mm/dd/yyyy. I changed it to Short Date, but that still doesn't work.

Sorry, I actually typed that wrong. There was not a space in the query name. It is as follows:SELECT contractid, status, updated, [previous renewal] FROM qrynextrenewal WHERE qrynextrenewal.[status]="active" and [previous renewal] = date()

Hello, I'm trying to create a query based on another query. However, my WHERE statement is causing a data type mismatch for a date. My code is: SELECT id, status, updated, [previous renewal] FROM qrynext renewal WHERE status = "active" and [previous renewal] = date() If I remove the " and...

Thank you pbaldy, I will give that a try!

Hello, I'm wondering if it's possible to set up an automatic Outlook mail merge with attachments from Access. We have several account managers, and each one receives a different version of the same report - filtered to his/her accounts. For now, I have set it up for the user to select the...

CJ_London, It turns out, only one letter is being sent to each company, with all recipients listed (in order) on that letter. Any suggestions for how I'd do this mail merge? I've honestly never done a mail merge before, so I was having it export to Excel and allowing the user to do the mail...

Hello, I'm trying to create a line chart based on monthly sales over the past year. But the graph doesn't match the crosstab query it's based on. So even though the query reads: month sales jun-13 $1000 jul-13 $2000 aug-13 $3000 ... jan-14 $4000 ... apr-14 $5000 may-14 $6000 But...

I did think of that, but it's being used for a mail merge, so certain fields need to be separated. Right now, I'm seeing if I can convince the user that all contacts don't need to be on one line in Excel. As long as this file isn't being used for reporting, I think simply doing a left join...

No sorry, it's not like that. Contracts ContractID ContractName Contacts ContactID ContractID (to link to Contracts) Contact # Title First Last So if I have one contract with two contacts: Contracts ContractID=1 ContractName="ContractX" Contacts (first record) ContactID=1 ContractID=1 Contact...

Hello, I have two tables, and I'm trying to create a crosstab query...I think. One table is Contracts, one is Contacts. Each contract could have multiple contacts, but they are numbered (1, 2, 3...etc.) based on importance. I want to create a query that keeps each contract on one line, and...