Recent content by crazy_loud

Thanks gemma, that does simplify things alot. Lesson learned. I was tired of changing three tables all the time whenever I was trying out stuff! But assuming that I'm copying these 3 zone tables to the master zone table to make things easier, I still don't know what expression to use in the...

Thanks gemma, I couldn't put them into one table because there is no field on any of these imports (they are being taken from Excel spreadsheet lists) that says which zone the records belong to. The names of the worksheets in Excel are the names of the zones, each contains the exact same...

Hello all, Is there a SQL function in Access that will allow it to return (as a field value) the name of the table where a particular record was found? The reason that I want to do this is because I have a single table (Table A) with building address records counted and broken down by state...

For reference - I'm going to try doing this with two queries and a UNION clause, and will post back if successful.

Thanks Moniker! That change to Nz did the trick. I will be certain to re-format the postings I make in the future to be more readable.:o

Hello all, I have made a crosstab query that is sporatically making duplicate counts. I'd like to know how to fix the problem, but more importantly - I'd like to know why and how my query is giving me these results so I can avoid making this same mistake again. The relationship is set up so...

Thanks for the response Wayne, Clearly I am not thinking out this query correctly. I'm going to re-design it after I've pondered for awhile about how one would make this concept work...

I have a query in Access 2000 that I can't get to force a certain value in empty rows for a particular field column - maybe someone here can see why? The SQL for the query is as follows (give or take some)...: TRANSFORM Count([Testing DB].[DB_ID]) AS [CountOfDB_ID] SELECT [Testing DB].State...

UPDATE - I must have been on something yesterday, because my resolution does not work today.:eek: Sadly, you cannot create an import specification for date/time fields that also dictates the treatment of the "AM/PM" portion of a field value as being part of a date/time format, from what I can...

In case you wanted to know... For those of you who want to know, I changed the format of the applicable date/time field that was having its values dropped upon import to... mm/dd/yyyy hh:nn:ss AM/PM and no longer have any lost date/time field values upon import to my table. Why I need to...

I had tried that before, and Access beeped at me that the query was "too complex to be evaluated" or some jazz. Must have been a syntax error. Thanks again for all your help!

So how do you force a section of a parameter to be static?

For the record... I've just been told on another forum to gut the time section to make the import work, but I've decided not to... I'll try something else and advise.

Thanks pbaldy Sorry about that, my internet connection died and when I got it back up, I posted that response to the wrong forum and the wrong thread...:o I got a response back from someone else on another forum saying to gut the time section, but I still don't see why "2007-04-30 12:00 PM"...

For anyone that might be able to help me out, I'd very much appreciate it, as this is now number 2 stupid workaround that I'd like to resolve before I need counselling...;) I have a Date/Time field that I'm importing into my database via .csv files. The field is setup like the example below...