Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
Top Bottom