Recent content by LFC

Hi, I am making a chart that is grouping data by week with the weeks being the labels on the X axis. I have tried it as both a pivot chart and a chart wizard onto a form. Currently the labels look like, 47 '10, 48 '10, 49'10, etc. This doesn't really work that well for the people that will be...

There is one thing that is a problem though. In the SQL a message would pop up that would say No And operator in between expression :'LHW_All_Claims_IMP_tbl.[Process Date] Between CI_Calender_FY2010.Week_Star'. the sql looks exactly like the one pasted above. I corrected this by adding...

Ah. That works perfect. Thanks for the help.

Were you able to figure anything out with the lookup?

I pretty much just deleted everything but I think the basic idea is there. It's the Week_ID field in the LHW_All_Claims_IMP_tbl that has the lookup. Thanks.

It's still not working. It's doing the same thing as before, where I can select what I want from a combo box on each field but doesn't automatically populate them. Below is your SQL that I modified. It looks right to me but I have no idea. Any Idea's? SELECT CI_Calender_FY2010.Week_ID...

I have a table with a process date. I have another table in which each record has a start date and an end date. I was wondering how to make a field in the table with the process date that would tie back to the other table based on the date range. I've tried using SQL in the lookup for the...

Not really anything too useful. I was hoping for a quick way, so i'd been trying a huge IIF statement, but I'm thinking that is probably not the best way to go about it. IIF(([Day_Freq] ="Weekly" Or "Monday" Or "Tuesday" Or "Wednesday" Or "Thursday" Or "Friday")...

I have the field set up as text. The one thing that I question is what to do for the amount of days if it's supposed to be Tuesday/Thursday or Monday/Wed/Friday because the length would be messed up by the weekends(sorry i forgot to include these when i posted earlier. The other thing would...

haha...sorry, i had posted in the vba one and then realized it prolly should be posted in the queries one. My bad

I've been racking my brain trying to think of the best way to do this, but have no idea how. I have line items that get audited with different frequencies (i.e. Monthly, Mondays, Twice a week, Every 2 weeks). I'm trying to get a query that will show which ones have not yet been entered for a...

I've been racking my brain trying to think of the best way to do this, but have no idea how. I have line items that get audited with different frequencies (i.e. Monthly, Mondays, Twice a week, Every 2 weeks). I'm trying to get a query that will show which ones have not yet been entered for a...

I figured it out. For some reason someone put the date variable as text so it messed everything up.

Well, I have no idea what happened, but it's working like a charm now and i don't think I had changed anything. Thanks for the help.

SELECT Torque_Readings_tbl.Job_Order_Number, Torque_Readings_tbl.Audit_Date, Count(Torque_Readings_tbl.Job_Order_Number) AS CountOfJob_Order_Number, Torque_Job_Order_tbl.Day_Freq, Torque_Job_Order_tbl.Dept_Num FROM Torque_Job_Order_tbl INNER JOIN Torque_Readings_tbl ON...