Search results

I have a form for data entry - and have an unbound text box on the form - formatted as short date. So on the form it has the calendar control to select the date (this is Access 2013). See attached - checkout. Now I want to use a query to retrieve the values on the form - see attached - Query1...

I found this out there - and it seems to work - should be fine for the limited use this requires: Expr1: IIf(IsDate([CYC-DATE]),CDate([CYC-DATE]),Null)

Pat and David, Thanks for the replies - I understand the information you have provided. The CDate does work. The reason I was/am getting the data type mismatch is due to the fact that some records have no date - and currently they appear as 0/00/00. If I delete them the CDate query works. The...

I have tried: ODATE: Format([CYC-DATE],"Short Date") OCDATE: Format([CYC-DATE],"mm/dd/yy") If I try to use CDate I get - data type mismatch errors. The source is a text file - link table. The source is what it is. I link to it and then I make a table from it, then I query the table that was...

I know this has been brought up many times in various incarnations - however, despite much time spent Googling this the things I have tried thus far are not working. I have a link table that has a field that represents dates - but they are actually just text. It's a long story but the source is...

JHB, I changed the criteria on the underlying query - as per your instructions - and that does work. Thanks - that will save me some time.

Ok - see attached - and thanks for looking.

I have a weird one. I have a query that calculates days old (as in a number) of orders - that query look like this: DaysOld: Date()-[VORDDATE] That part (above) works fine. Now I am trying to make a report to allow the user to specify a parameter for number of days old to view on the report...

I must be missing something: If I use: Like "*[!A-Z0-9]*" it shows everything

These would not show because they contain no special characters. I only want to see records that contain any characters in the string that are not A-Z - 0-9 #@!%^&*()/\][ and the like

The query would need to show - any records in the field that had any characters that were not A-Z or 0-9 For example: Field1 ABC123 - don't show ABC/123 - I need to see this record ABC.123 - I need to see this record ABC$123 - I need to see this

Does anyone know if it is possible to query a field for special characters in a string? I want to find any records that have characters other than A-Z, 0-9 Thanks!

I have a relatively small database. It has in it data relating to orders. The orders table has maybe twenty customers and their corresponding open orders. The number of customers with open orders will fluctuate from month to month. I want to send via e-mail a PDF or Excel file - monthly -...

Not sure this is the best way to go with this - but could not think of a more applicable title for the post. Basically I have an access database that has a report for quoting projects/jobs/materials. It all works pretty well...however, I have discovered that the user would like a good way to...

John, Mark, Actually it looks like both of your solutions will work. I very much appreciate the assistance! Thanks!

I do want to round up to the nearest nickel. So - I want 10.97 to round up to 11.00 (as an example). I do understand that this: RoundUp: Round([MyField]/0.05)*0.05 works for rounding to the nearest .05 I am still not seeing how to get it to round 10.97 up to 11.00. It wants to round it to...

That is where i got the information for rounding to the nearest nickel - however I don't see how to round up to the nearest nickel.

This has me stumped so far - I need to round up to the nearest nickel, preferably in a query. Have figured out how to round to the nearest nickel, but cannot get it to round up. I round to the nearest nickel like this: RoundedNumber: Round(20*[MyField],0)/20 Any ideas?

I like the idea of checklists but - not sure how to make it work when new items will be added over the course of time. What you suggest might work fine, would like to see an example of how that would work. Thanks!

the checkboxes would just be there so the user can easily indicate on the form for each customer what pieces of literature they have. So the form would have basic customer info and also will show every literature SKU/description, there will be a checkbox next to each SKU/description - user...