Search results

  1. C

    Query to return table name as a value?

    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...
  2. C

    Query to return table name as a value?

    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...
  3. C

    Query to return table name as a value?

    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...
  4. C

    Removing Duplicate Entries from Joined Tables in CrossTab Query?

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

    Nz or IIf(is null) to force a certain value?

    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
  6. C

    Removing Duplicate Entries from Joined Tables in CrossTab Query?

    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...
  7. C

    Nz or IIf(is null) to force a certain value?

    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...
  8. C

    Nz or IIf(is null) to force a certain value?

    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...
  9. C

    Delimited Date/Time Fields Being Deleted on Import?

    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...
  10. C

    Delimited Date/Time Fields Being Deleted on Import?

    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...
  11. C

    Parameter Query with "<=" losing values?

    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!
  12. C

    Parameter Query with "<=" losing values?

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

    Delimited Date/Time Fields Being Deleted on Import?

    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.
  14. C

    Parameter Query with "<=" losing values?

    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"...
  15. C

    Delimited Date/Time Fields Being Deleted on Import?

    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...
  16. C

    Parameter Query with "<=" losing values?

    Any possible solutions to this issue would be much obliged, it's one of two absolutely stupid issues that I'm just working around since I can't resolve... I have a parameter query set up on a Date/Time field that is returning results not including the last date entered as a parameter. So if...
  17. C

    'Alias' and 'Order By' Troubles with Union Query?

    Thanks Wayne!
  18. C

    'Alias' and 'Order By' Troubles with Union Query?

    Sidenote... Ignore 'Alias' in the title - I started a new thread instead and forgot to delete that
  19. C

    'Alias' and 'Order By' Troubles with Union Query?

    Hello all, Does anyone know (and would be willing to share) how one can order the results of a Union query in Access by something other than the returned values? I have a simple Union query that would work perfectly - if I could get the thing to order the results in a particular order...
Back
Top Bottom