Recent content by CanvasShoes

Okay, I'm reasonably intelligent when it comes to databases, but this "simple" query is eating my brain. I have two lists of files, each located in a different spot. One contains all names of files that have been uploaded to our database, and the other is the company file storage location...

ARGH! The way they describe it, it seems as if they're talking about the query design section. Of course that was after a whole day spend trying to solve a cranky query and using ancient eyes on a tiny laptop computer screen. Thanks so much for pointing it out. I am having trouble with two...

So here are the instructions from MS on one of their pages Combine the select queries in SQL view On the Create tab, in the Queries group, click Query Design. A new query opens in Design view. Close the Show Table dialog box. On the Design tab, in the Query group, click Union. Nice, only...

What I was looking for is as Big John describes, I used first to denote the oldest dates, and last to denote the most recent (which is about circa 1989 which is probably why some of the errors are happening?). What is weird is that it worked perfectly with one of the queries (same tables used)...

The dates in this ancient (not my original data, it's data somehow copied off of an old obsolete computer system that I'm just trying to rescue and organize), are formatted like this - 6/19/89. My query is written such that I get a sum of all like material from each supplier. The purpose is to...

Thanks so much. It ended up that your assessment above was pretty close to right on the money. Not a blank column, but misplaced ones. I had originally exported the table to excel, added my data (I SO wish dbases allowed an easier manipulation of the data!), and then was ready to import it...

I hope you don't mind the hijack, but I have an excel import problem as well. I have an excel spreadsheet with exactly the same column heading names as the Access table into which I want to import it. But I keep getting the import error message "FIELD "F1" does not exist in destination table...

No, the data itself is, for the most part, correct, though I have to come in and do a few fixes once the lab is done. No, it's the headings. If we'd built these dbases ourselves we could tailor these to our own wants/needs. Unfortunately these are client required dbases and our ability to...

As in..."wut we got Heah...is Failuh to communiKATE" (but as always, it could be operator error and I'm just not advanced enough to know the obvious-to-the-experts fix on this) :D Mods, if this question is in the wrong forum please don't hesitate to move it. I just wasn't sure what category...

Thanks! I appreciate the help! (slowly but surely I WILL conquer Access :D)

I was afraid of that when I read your reply to the OP. Is there any way possible to rescue the corrupt frontend?

I don't know if the OP's database is split, but I'm having a similar problem and mine is a split database. We use this same format for a number of project sites and it's only the one site that is having issues (we checked to make sure it wasn't our computers or Access itself). The backend...

That's probably JUST the trick I needed. I only know JUST enough to be dangerous. :D And unfortunately, the MS websites don't list help in the terminology that laypersons use. As it is, I'd totally forgotten that I could just do a "save as" with the good database and then relink it to the...

I have a database that I didn't design. It's from a client and they didn't design it either (and it's rather a piece of crap). So, I apologize upfront if this gets complicated. Our client is the prime contractor of the client and we are the subs. Using or designing a different database...

Ahhhh, THANK YOU!! That was easy (you may now laugh at my silly end user self :D) Gemma, I'm not sure if that's what they did or not. I do need the formula to be pretty much equal to this for example: "any value lower than 2 gives me an A for one specific "cell" in my report. "any value...