Search results

I managed to get the form to fully populate my query criteria. Here is what I used IIf([Forms]![Payroll Report Form]![Frame28]=1,"PA",IIf([Forms]![Payroll Report Form]![Frame28]=2,"WV",IIf([Forms]![Payroll Report Form]![Frame28]=3,([Daily Time].[State]),""))). The IIF function probably wasn't...

ok so I was going about the procedure right, but I most of had some wrong syntax or something, but I still have one small flaw. I have success with my state field criteria as IIf([Forms]![Payroll Report Form]![Frame28]=1,"PA",IIf([Forms]![Payroll Report Form]![Frame28]=2,"WV","")). The last...

Once again I make progress and run in to an issue. Currently, I have a report that pulls data from a query. The query uses this criteria: EMPLOYEE FIELD, criteria Like "*" & [Leave blank or enter part or all employees name] & "*", WORK DATE FIELD, criteria Between [Enter Beginning Date:] And...

Thanks again Paul. You're great. :)

I currently have a query that has the user enter a starting date and an ending date. What I would like to do is use a form with two date pickers and have the query use the two date pickers for the criteria, but i'm not sure what the syntax would be in the criteria field in the query. If I new...

I used a query adding the "*" field from my table and "employee name" field. In the criteria for "employee name" I used, Like "*" & [Enter all or part of employees name] & "*". It works perfectly. Thank you.

That is a good option. My original plan was to bind the query to a button on the main switchboard so the user could easily click the button, enter the name in a prompt, and then have the form open to the record that matches the criteria that was entered in the prompt.

I was wondering, is it possible to open a form to a specific record base on criteria in a query? Right now I have a form with basic employee information. I can create a query to enter employee name as the criteria and it will open the record, but it opens in table view. I would like for it to...

Without having to use the conditional formatting wizard type thing can I add color to my IIF statement by adding some extra code to it so I can have it report "Expired" in red and "Expires Today" in orange perhaps?

Somehow my expiration date field got to text instead of date/time. Thank for the help.

I currently have a field in a table called expiration date in which a dates are stored. In a form I added a text box that has an IIF statement =IIf([Expiration Date]<Date(),"Expired",IIf([Expiration Date]=Date(),"Expires today","No")) When in form view the box always says Expired no matter...

Thank you. I'm sure I will post again. I was really efficient with Access 2003 and now I'm having to use Access again, 7 years later, and i'm using 2007. I'm having issues sometimes doing simple tasks that use to be easy.

So far I've made a form for the user to imput the hours, state, etc. Basically, I have a user using one of the largest excel spreadsheets i've ever seen to do payroll and keep track of jobs so they are use looking at tables. I think I will just do a form or report to where it will basically use...

If there is a bettery way to try to do this I'm open to options as well.

I've tried to put criteria for the dsum but I can't get it to prompt for a date range. That' really what I'm looking to do. I tried to use Between [Enter Beginning Date:] And [Enter Ending Date:] but when I do that it accepts the query as having no syntax errors, but it get blank results. The...

SELECT [Daily Time].Employee, [Daily Time].[Work Date], [Daily Time].State, [Daily Time].Hours, DSum("[hours]","Daily Time","[state] like 'wv'") AS Total FROM [Daily Time] WHERE ((([Daily Time].Employee) Like "*" & [Enter all or part of the employees name] & "*") AND (([Daily Time].[Work Date])...

Currently, I have a table that contains the fields [Employee Name][Date][Rig #][State][Hours]. I have started a query that asks for the employees name, then a date range, and then which state was worked and it will reply the correct information. What I would like to add would be a sum of the...