Search results

  1. O

    Update Query confusion

    If [StockLabel] is text and you are trying to update a numeric field [LabelSaved] that wont work. Why are you trying to do this. If you need to show [LabelSaved] text instead of [LabelSaved] number you can do that with a query.
  2. O

    Find Max in crosstab

    [deleted]* not a solution
  3. O

    Query returns blank value to use different column

    as he said copy paste below code in empty column as in attached pic ColName: IIF(isnull([DateField]), [FieldWhenDateIsBlank], [DateField])
  4. O

    Duplicate records

    Can you post screen shot of your query or SQL. have you linked the tables in this query. ie. [Employee ID] from Employee Data table should be linked to [Employee ID] in Feedback Data table. also Table Pay Year should be liked to one of the other tables
  5. O

    Simple Query

  6. O

    Duplicate records

    The query you are describing should show single average for each EmployeeID. You must have another field grouping the results. are there any other fields in this query.
  7. O

    Access Criteria Problem

    So you tried both solutions at once as shown in your query.(attached pic) I think you should remove link to your db if you problem is solved..
  8. O

    Access Criteria Problem

    Have you tried this? I think you should try this
  9. O

    Between Dates inconsistency

    Based on that it is probably issue with your data. can you check equivalent filed in your original db to [Company] field from CustomerOrders table.
  10. O

    Between Dates inconsistency

    Based on your initial post I believe there is an issue with date format. try using this Between Format([Forms]![frmMain]![FirstDate],"m/d/yyyy") And Format([Forms]![frmMain]![SecondDate],"m/d/yyyy") as for the sample database you posted as other have posted there are number of issues. I am...
  11. O

    Change .getElementsByClassName with code

    Try Do if Not (IE.Document.getElementsByClassName("ftqbb ftqw2 pid-59-bid")(0)) Nothing then dd = IE.Document.getElementsByClassName("ftqbb ftqw2 pid-59-bid")(0).innerText exit Do elseif Not (IE.Document.getElementsByClassName("ftqbb ftqw2 pid-59-bid greenBg")(0) ) Nothing then dd...
  12. O

    Sorting on a calculated field producing unexpected results

    Try using DateDiff() function I missed that. Thats the proper way to get date difference. in your case it would be DateDiff("d", [delivery_date], [despatch_date]) as days_late refer to http://www.techonthenet.com/access/functions/date/datediff.php
  13. O

    Change .getElementsByClassName with code

    Try this: Do if Not IsNull(IE.Document.getElementsByClassName("ftqbb ftqw2 pid-59-bid")(0)) then dd = IE.Document.getElementsByClassName("ftqbb ftqw2 pid-59-bid")(0).innerText exit Do elseif Not IsNull(IE.Document.getElementsByClassName("ftqbb ftqw2 pid-59-bid greenBg")(0) ) then...
  14. O

    Sorting on a calculated field producing unexpected results

    First save the query as something like 'main_query' without where clause then give criteria to main query. You will have days_late in main query which you can use to order by.
  15. O

    Dynamic Query using VBA

    Without details I have to guess RetestLocation is a number field and you are passing value as string since you are using &'&.
  16. O

    Null Date Value and String vs Date and #Error

    Are you trying to add 5 days to date? if so try DateAdd function Field B = IIF(NOT ISDATE([A]), NULL, DateAdd ("d", 5, [A])) refer to this http://www.techonthenet.com/access/functions/date/dateadd.php
  17. O

    Multiple IIf Statement in Expression

    Try this =IIf([Code]='12356' And [description] Like '*abc*',1, IIf([Code]='78910' And [description] Like '*def*',1, IIf([Code]='23456' And [description] Like '*ghi*',1,0)))
  18. O

    DLookup for dates

    I was doing the same thing and stuck with this strange problem. your post made me realize it was a problem with date format and I did not have option to change systems date format. So used VB's Format function to change the date format. Just in case anyone needs to do that. holDate =...
  19. O

    display time remaining on the form

    thanks to ghudson the problem is solved but i settled for showing time starting from 0:00 to the time i want the quiz to end by using datediff of start time and now() not as a count down as i was trying before. And i think in this case it is better tho show time this way. But i would like to...
  20. O

    Filetering a field depending on another field

    May be this is what you want, Hope it helps you
Top Bottom