I have a job sheet, report, 5 lines per customer(Name, Add, etc.) I have Last & Next Date fields, being scheduled job dates. How do I get these dates into the detail line of my report? Table ScheduleDates has RefNum(Customer) and SchedNum Key with the dates for the schedules ie 15/04, 12/05, 10/05. If rundate is 12/05 then last 15/04, next 10/05. I can get a query to return the result i want but cant get it into a form. I believe it should be simple. But Ive been at it for months. Please help, Im on the verge of tears, not a good look for 59 yo man.
Kevin Robertson
@Reply 2 years ago
Set the Record Source to the name of your Query. Then Add Existing Fields to add the fields to your Form/Report.
Jim CornwellOP
@Reply
2 years ago
Thanks for that, thats what to do but how do I do it?
Each detail line of the report has a different Customer, Schedule,
different dates.
How do I connect them? Of course 10/05 SHB 10/06, sorry.
My query, for last date, is
SELECT Max([Schedule_Dates].[JobDate]) AS LastJobDate
FROM Schedule_Dates
WHERE (Schedule_Dates.RefNum)=[Reports]![PrRunSheet].[RefNum]) AND (Schedule_Dates.SchedNum)=[Reports]![PrRunSheet].[SchedNum]) AND (Schedule_Dates.JobDate)<[Reports]![PrRunSheet].[RunDate])
ORDER BY Max([Schedule_Dates].[JobDate])
TextBox has no query connect.
SubReport while shows the query, shows no field.
I dont think I can do it in the main report query as each customer has different dates.
Maybe I do need to look there, have another date table for each of last and next, baybe it cant do at run time?
Many Thanks.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
