Welcome to SPN

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

Sign Up Now!
  1. Guest ji, please consider donating today!   Become a Supporter    ::   Make a Contribution   
    Monthly (Recurring) Target: $300 :: Achieved: $95

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.
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page