Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

I've messed up big time.

Discussion in 'Information Technology' started by RTimberlake, Oct 29, 2005.

Tags:
  1. RTimberlake

    RTimberlake
    Expand Collapse
    Guest

    I have a query that I use to enter data for timesheets on. The query has
    worked great up until I started messing with it. Somehow the feild for
    TimeSheetID which is set to Autonumber, will not fill in the query. This has
    never been a problem before. Please help before I get fired.
     
  2. Loading...

    Similar Threads Forum Date
    Life Lessons I've Learned Inspirational Stories Jul 7, 2008

  3. Jeff C

    Jeff C
    Expand Collapse
    Guest

    Without you posting the query it will be difficult to assist

    "RTimberlake" wrote:

    > I have a query that I use to enter data for timesheets on. The query has
    > worked great up until I started messing with it. Somehow the feild for
    > TimeSheetID which is set to Autonumber, will not fill in the query. This has
    > never been a problem before. Please help before I get fired.
     
  4. RTimberlake

    RTimberlake
    Expand Collapse
    Guest

    Is that possible?

    "Jeff C" wrote:

    > Without you posting the query it will be difficult to assist
    >
    > "RTimberlake" wrote:
    >
    > > I have a query that I use to enter data for timesheets on. The query has
    > > worked great up until I started messing with it. Somehow the feild for
    > > TimeSheetID which is set to Autonumber, will not fill in the query. This has
    > > never been a problem before. Please help before I get fired.
     
  5. RTimberlake

    RTimberlake
    Expand Collapse
    Guest

    Here is the SQL statement for my query:


    SELECT tblTimeSheet.TimeSheetID, tblEmployees.[Employee ID],
    tblTimeSheet.PayPeriod, tblTimeSheet.DateWorked, tblTimeSheet.TimeIn,
    tblTimeSheet.TimeOut, (([TimeOut]-[TimeIn])*1440)/60 AS HoursWorked,
    tblTimeSheet.Vacation, tblTimeSheet.Personal
    FROM tblEmployees INNER JOIN tblTimeSheet ON tblEmployees.[Employee ID] =
    tblTimeSheet.EmployeeID
    WHERE (((tblEmployees.[Employee ID])=[Forms]![PASSWORDS].[cmbEmployeeID])
    AND ((tblTimeSheet.PayPeriod)=22) AND ((tblEmployees.[Employee
    Password])=[Forms]![PASSWORDS].[cmbPassword]));

    Thank you for your help.


    "Jeff C" wrote:

    > Without you posting the query it will be difficult to assist
    >
    > "RTimberlake" wrote:
    >
    > > I have a query that I use to enter data for timesheets on. The query has
    > > worked great up until I started messing with it. Somehow the feild for
    > > TimeSheetID which is set to Autonumber, will not fill in the query. This has
    > > never been a problem before. Please help before I get fired.
     
  6. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    Just how did you "mess with" the Query?

    I see nothing particular here that would prevent _only_ the TimeSheetID
    Field from being displayed, if indeed, that is the exact name of the Field
    and if that is what you meant by your question.

    But it appears to me that you have unbalanced parentheses in the WHERE
    clause.

    I'd suggest you restore the Query to its original form, and see if you can't
    accomplish what you want using the Query Builder instead of "messing with"
    the SQL itself.

    Larry Linson
    Microsoft Access MVP






    "RTimberlake" <RTimberlake@discussions.microsoft.com> wrote in message
    news:7106F2C0-A0DE-4CA6-9446-2A45651158F7@microsoft.com...
    > Here is the SQL statement for my query:
    >
    >
    > SELECT tblTimeSheet.TimeSheetID, tblEmployees.[Employee ID],
    > tblTimeSheet.PayPeriod, tblTimeSheet.DateWorked, tblTimeSheet.TimeIn,
    > tblTimeSheet.TimeOut, (([TimeOut]-[TimeIn])*1440)/60 AS HoursWorked,
    > tblTimeSheet.Vacation, tblTimeSheet.Personal
    > FROM tblEmployees INNER JOIN tblTimeSheet ON tblEmployees.[Employee ID] =
    > tblTimeSheet.EmployeeID
    > WHERE (((tblEmployees.[Employee ID])=[Forms]![PASSWORDS].[cmbEmployeeID])
    > AND ((tblTimeSheet.PayPeriod)=22) AND ((tblEmployees.[Employee
    > Password])=[Forms]![PASSWORDS].[cmbPassword]));
    >
    > Thank you for your help.
    >
    >
    > "Jeff C" wrote:
    >
    >> Without you posting the query it will be difficult to assist
    >>
    >> "RTimberlake" wrote:
    >>
    >> > I have a query that I use to enter data for timesheets on. The query
    >> > has
    >> > worked great up until I started messing with it. Somehow the feild for
    >> > TimeSheetID which is set to Autonumber, will not fill in the query.
    >> > This has
    >> > never been a problem before. Please help before I get fired.
     

Share This Page