Hi,
I have a form for inserting invoices, and on the subform I have a command button to print the labels, the label would contain the quantity of the product, so, for instance if the quantity is 11000 and package contains 2000 only so I have to print 5 labels with quantity 2000 and one label with 1000 qty what I need to do, is when I click the label cmd button to insert the records required to temp table to print the label
...
Projectnow
Last Activity: Jun 22 '13, 01:51 PM
Joined: Oct 9 '12
Location:
-
quantity per package label
-
thank you very much for your reply
I attached an image on my first post in this thread, I used unbound controls for this report, so I can't figure out how to handle coloring the column of the days off and holidays
any help would be appreciated
thank you very much -
thank you for your reply
one more question is there a way to color the column of the days offLeave a comment:
-
Dates Headings In Crosstab Report
hi,
I have a crosstab query that views all the vacation days for employees between two dates parameter,
the column headings of the query is the all the dates between the parameters even if they are nulls
I need to design a report for that query where the headings to be dynamic for dates in the headings and doesn't exceed 31 days.
...Code:PARAMETERS d DateTime, b DateTime; TRANSFORM Sum(Vaclist.Period) AS
-
Rabbit, Great!
you are genius!
thank you for your assistance and your patience
I ended with thisI really appreciate your helpCode:PARAMETERS d DateTime, b DateTime; SELECT * FROM qrycrosstab WHERE (((qrycrosstab.EmpID) Is Not Null));
thank you again and over againLeave a comment:
-
I really don't know how to filter out that row after the crosstab has already returned the data
I really need to accomplish this but there is something I can't understand with that query
thank you very muchLeave a comment:
-
when I use is not null as in the sql...Code:PARAMETERS d DateTime, b DateTime; TRANSFORM Sum(Vaclist.Period) AS SumOfPeriod SELECT Vaclist.EmpID, tbl_VacType.Vactype FROM (qryEmployeeWorkDates LEFT JOIN Vaclist ON (qryEmployeeWorkDates.DateOfPeriod = Vaclist.VacDate) AND (qryEmployeeWorkDates.EmpID = Vaclist.EmpID)) LEFT JOIN tbl_VacType ON Vaclist.VacTypeID = tbl_VacType.VacTypeID WHERE (((Vaclist.EmpID) Is Not Null) AND
Leave a comment:
-
Oh, yes that's true that just take me back to where I was,
now I am missing the dates where there's no vacation
but there could be nulls as a result of an outer join.
I can't see any nulls in query vaclist and qryemployeework dates
how can I trap that?
thank you very much...Leave a comment:
-
Hi,
there's no null empid in query vaclist
I just needed to change from left join to inner join between qryEmployeeWork Dates and vaclist
glad to get help from the experts like you Rabbit
thank you again and over againLeave a comment:
-
Ok, I did as you instructed me, but I get the first record in the crosstab with null values, in other words, the first record is blank, is there something I am doing wrong with that?
I ended with this lines:
...Code:PARAMETERS d DateTime, b DateTime; TRANSFORM Sum(Vaclist.Period) AS SumOfPeriod SELECT Vaclist.EmpID, Vaclist.Vactype FROM qryEmployeeWorkDates LEFT JOIN Vaclist ON (qryEmployeeWorkDates.EmpID = Vaclist.EmpID) AND
Leave a comment:
-
you do get all the dates between two dates even if any of the dates in the range has a null value?
how come the sql I posted doesn't work for thatLeave a comment:
-
Hi, Rabbit
thank you for your reply
I mean that all the dates between two dates parameters won't be a query headings
just the date which has a value will be viewed but not all the dates
I need it to be like that
...Code:5/1/2000 5/2/2000 5/3/2000 5/4/2000 5/5/2000 Name 8 Name 8 Name
Leave a comment:
-
Projectnow started a topic view all dates between two dates parameters in the crosstab query headingsin Accessview all dates between two dates parameters in the crosstab query headings
hi,
I need to view all dates between two dates parameters in the crosstab query headings
where I use this syntax
and it doesn't seem to work that wayCode:PARAMETERS d DateTime, b DateTime; TRANSFORM Sum(Vaclist.Period) AS S SELECT Vaclist.EmpID FROM Vaclist WHERE (((Vaclist.VacDate) Between [d] And [b])) GROUP BY Vaclist.EmpID PIVOT Vaclist.VacDate;
...
No activity results to display
Leave a comment: