Search results

Hi, When I open a form 'Project Details' it throws up a parameter box asking for an 'ID' I searched throughout the database but I can't seem to find the cause for the parameter. I've looked at my queries, forms and table and also relationships. I don't have a field that's linked to the form...

Apologies, I was missing the = This is now the desired result, once again sorry for the vague replies! I appreciate your patience and support. Thank you. Chris.

Same issue - still showing all records as 'No' This is the expression I'm now using Urgent: IIf([Allocated Date]>DateAdd("ww",4,Date()) And [Allocated Date]<DateAdd("ww",5,Date()),"Yes","No")

I could only fit so much data in, every record shows as 'No' - I've attached another screen shot in the dates that should show as 'Yes'

I apologise for the confusion and the vague description throughout. I now believe its the 'exact' expression I'm looking for. I've used the formula from your previous post: Urgent: IIf([Allocated Date]>DateAdd("w",4,Date()) And [Allocated Date]<DateAdd("w",5,Date()),"Yes","No") However, it's...

Does this expression look correct to have the ability to show record as urgent if the Allocated Date is greater than 4 week from the system date but less than 5 week. This will ensure Urgent is displayed next to all records that are exactly within 4 weeks Urgent: IIf([Allocated...

What about adding the Urgent field using the formula you gave and then use another query to pick out the fields that are urgent and where the Allocated Date is within 4 weeks of the Job Inputted Date? Would that work?

Hi, Thanks again for the support, I'm half way there to achieving the desired result. What I'm now looking to do, and I'm not entirely sure whether this would need a filter of not within the query. I'm only interested in Jobs that aren't booked in. The way that we indicate this is if the jobs...

Hi, Thanks for your reply. I've realised that it's not actually a report that I want the flagging up used on. Its a query that's displayed within a form as a datasheet (I've attached a snapshot). Would the formula you described in your response still be used if the query? If you see from the...

Hi all, I've been asked to edit a current report that lists our production in week number order. I need to look at way we can 'flag up' orders that are within a 4 week period from the current date. For example, 10 Orders in total in our database. 5 of which are due the drawings back within 4...

I think I've now managed to sort the report out and it now lists each week page by page. My only issue now is that some of the information doesn't show. I'm now sure If I've put the grouping in the correct place. I've placed the grouping of the expression just below the page header. Is this...

Ok, I've done this now. So the query now shows the week number when I run it. How to I now incorporate this in my report so that the report only show week by week pages, whilst still grouping by weekday also (already in place)

Hi, I've tried to use this in my query in a new field which Ive set up using the expression builder. DatePart (ww,[Jobs Inputted Date],2,) The query returns with the fields all showing #Func! Any ideas?

Thanks for your response. I'm not fully sure I understand your answer. Will this include me adding a week number field to the table. At present the query uses the input date from the tblJobs then sorts them by date. I've then included a format to show days of the week rather than the unique...

Hi, I've created a report based on a query that shows me the jobs that have been added to tblJobs between two selected dates. The report works fine and displays all the information I need, however other than being sorted by day of the week i.e. Monday, Tuesday, Wednesday etc. The records just...

Thanks for your reply. Could you guide me through this? Where do I start with setting this up? Thanks,

Hi, Where would I even begin with this? I'm not a big access user, the database I've built is pretty basic and we've been fine running queries to show outstanding dates. I'm just looking for better and more efficient way to handle this. Is there not a more simpler way to just allow the user to...

Hi all, Not sure if this is in the correct category... 2 options really... I want to set up an automated email feature, that will email just ONE person (the same person) according to call backs that are due on a certain date. For example. We enter quotations in to our system and input a 'Call...

Re: Formatting the date to show the day of the week [Solved] Brilliant, this worked! Thanks!