Recent content by Redous

ooooooh i think i have done it i will get back to you :)

Here is my database http://www.sphyx.com/Database.zip

I get a parse error with the above code without the )); i get an error This expression is typed incorrectly or it is too complex SELECT Datevalue(Incident_Start-0.25) AS DateShift, Downtime.Incident_Start FROM Downtime WHERE datevalue([Incident_Start]-0.25)=[Forms]![Downtime_Query]![DateShift]...

Still struggling :(

Okay is there any other way around doing this cause i am confused even more now I haven't changed anything at all exported the same document and the dates are formatted 01-Sept-15

The actual SQL was autogenerated from me creating the said query which is why its all over the place. I just saw that on the exported excel sheet the DateShift field actually looks like 21/09/2015 00:00 all the way down changing the date where it should. On my search form, how do I get the...

Hi Obeylele, I have tried but still can't get the search filter to work it shows up a blank record.

Hi, I just tried to supply you a copy of the database however I cant due to current post restrictions.

Okay, SELECT Format([Incident_Start]-0.25,"dd/mm/yyyy") AS DateShift, Downtime.Incident_Start FROM Downtime WHERE (((Format([Incident_Start]-0.25,"dd/mm/yyyy"))=[Forms]![Downtime_Query]![DateShift])) OR (((Format([Incident_Start]-0.25,"dd/mm/yyyy")) Between...

Okay so i went away and tried various things with no joy so far i got DateShift: Left(CDate([Incident_Start]-0.25),InStr(CDate([Incident_Start]-0.25)," ")) Am i going about it the right way? When displayed in the datasheet it looks fine but still getting the problem with the form filter?

Hi Spikepl, Can you explain further or show me an example of how the expression should be built?

I have an access database which is basically a downtime log holds information like date / start / end / duration / department / area / Okay, so I have a problem with the date part. In my query, I used an expression to abstract the date from the field start using...

Hi, I am hoping someone can help, I have use the above resource to get my report working with just one combobox Outcome: Report shows desired filtered records. I have multiple comboboxes that I want to have control the report. Is there a way that this can be done? In the Querie...