User Profile

Collapse

Profile Sidebar

Collapse
Darknight850
Darknight850
Last Activity: Aug 21 '07, 04:28 PM
Joined: May 23 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Darknight850
    started a topic IIF Statement In Query
    in Access

    IIF Statement In Query

    Hello Every One,

    I am having a problem with an IIF statement in a query I have going. Before I start I would like to say I have had some problems in the past with supplying enough information, if you need more information just ask and I'll try my best to give it.

    What i have is a query that is beeing used for a weekly report, this weekly report is broken down in weeks, using the following code "
    Code:
     CStr([Date Of Arrival]-Weekday([Date
    ...
    See more | Go to post
    • Darknight850
      replied to How to make number never go down?
      in Access
      Thank You. I thought that may be the only way to go about it....
      See more | Go to post

        Leave a comment:

      • Darknight850
        replied to How to make number never go down?
        in Access
        Any one know how to go about this ?
        See more | Go to post

          Leave a comment:

        • Darknight850
          replied to How to make number never go down?
          in Access
          I am sorry i can not give detailed information. But i can try to restate my question, maybe that will help. I will try to make this as simple as possible.

          The following tables are the tables that matter in this problem:

          tblAll:
          EmployeeID - PK
          Name
          JobTitle
          Has ID
          CardID - FK

          tblIDType:
          CardID - PK
          ID Type

          I have a report that has all these...
          See more | Go to post

            Leave a comment:

          • Darknight850
            replied to need help counting specific dates in query
            in Access
            Thank you very much that worked perfectly, I had tried a IIF statement like that befor but I had not done it in a while in the SQL and just did IF and didn't want to work. I am also sorry i do not provide so much data, i try just to provide enough to get the information threw, it is easier for me this way since i have to replace the real field names with fake ones.

            Thank you again...
            See more | Go to post

              Leave a comment:

            • Darknight850
              started a topic How to make number never go down?
              in Access

              How to make number never go down?

              Hello,

              This question I have may be alittle more difficault. I have a report that shows all of the type of IDs my company has given out. But when they are terminated from the company the number goes down. what i need is a field were the number never goes down, and always goes up, showing me the over all IDs I have issued out. I really have no idea were to start with this, so if any one could help me that would be great. Thank You.
              See more | Go to post
              • Darknight850
                started a topic need help counting specific dates in query
                in Access

                need help counting specific dates in query

                Hello all,

                I am having a rather simple problem that for some reason i can not get to work. i have a date field, and i want to simply count all of the current dates(as in today) in that field.

                What I have that is not working:

                Code:
                count([Date Field])=Date() as Date Field
                I know i am missing something, I think I read some were to sum it up, but I tried and that didn't work eather. If some one could...
                See more | Go to post
                • Darknight850
                  replied to Query Problem
                  in Access
                  It already works with the detail section, it gives me the totals for every job that is what i am looking to do, But, not having the off base records count. yet at the same time show the total of the off base records still be there, and not 0
                  See more | Go to post

                    Leave a comment:

                  • Darknight850
                    replied to Query Problem
                    in Access
                    SELECT tblAll.Jobs, Count(tblAll.Na me) AS CountOfName, Sum(tblAll.[Vacation])*-1 AS [SumOfOff Base], Sum(tblAll.IDCa rd)*-1 AS SumOfMNFIBadge, Count(tblAll.ID Card)+Sum(MNFIB adge) AS CountOfIDCard, Sum(tblAll.[Interview Complete])*-1 AS [Interview Complete], Count(tblAll.[Interview])+Sum([Interview]) AS [CountOfIntervie w Complete], Sum(tblAll.Temp orary)*-1 AS SumOfTemporary, Count(IIf([tblAll.IDCard]=14,[tblall.IDCard])) AS CountOfIDCard
                    FROM...
                    See more | Go to post

                      Leave a comment:

                    • Darknight850
                      replied to Query Problem
                      in Access
                      I need the detail amount, that is my main focus...
                      See more | Go to post

                        Leave a comment:

                      • Darknight850
                        replied to Query Problem
                        in Access
                        Thank you for your reply and sorry about not explaining it well. Truthfully I don't really know how to explain it to well. I do need the totals to be deducted as well, but my main purpose is the actual data in the detail section. I tried to put the code that you gave me in the detail section and take the same steps as in the footer, but i couldn't get it to work, kept giving me an error saying the code was wrong. I think the problem is that it couldn't...
                        See more | Go to post

                          Leave a comment:

                        • Darknight850
                          replied to Query Problem
                          in Access
                          Bump,Bump,Bump, Bump,Bump,Bump, Bump,Bump,Bump, Bump,Bump,Bump,
                          See more | Go to post

                            Leave a comment:

                          • Darknight850
                            started a topic Query Problem
                            in Access

                            Query Problem

                            Hello All,

                            I have just got thrown something at me for this Monster i have created :D. Well I am not exactly sure how to go about getting what I need in the report, but I know I have to do something with the query. What I have going is a full report of all jobs in my work place, in the report it shows Total workers per job, workers on vacation, works that have Permanent ID cards and workers that have temporary ID cards. What i want...
                            See more | Go to post
                            • Darknight850
                              replied to Report Sorting
                              in Access
                              That helped a lot thank you, sorry for such the long response time, i had been gone for awhile, but that worked great. thank you again.
                              See more | Go to post

                                Leave a comment:

                              • Darknight850
                                replied to Report Sorting
                                in Access
                                the field isn't in the query, only companiesID is. here is how my tables are set up:

                                tblAll:
                                EmployeeID - PK - Auto Number
                                Company- FK
                                Name
                                Job Title
                                Id Color - FK -
                                Date ID Issued
                                Date ID Expired
                                Date Started Work

                                tblCompanies:
                                CompanieID - PK - Autonumber
                                Company Name

                                tblIDtype:
                                IDTypeID - PK - AutoNumber
                                ID Type
                                See more | Go to post

                                  Leave a comment:

                                • Darknight850
                                  replied to Report Sorting
                                  in Access
                                  i can only sort by CompaniesID because that is whats linked to the companies table. then in the report i have the companiesId in a combo box with a width of 0".
                                  See more | Go to post

                                    Leave a comment:

                                  • Darknight850
                                    replied to Log On Box Access 2007
                                    in Access
                                    Thank You, That worked great, and was easy
                                    See more | Go to post

                                      Leave a comment:

                                    • Darknight850
                                      started a topic Report Sorting
                                      in Access

                                      Report Sorting

                                      Hello All,

                                      I have a question about sorting in a report. Right now I have multiple reports sorting off of my companies table that has two fields; CompaniesID, and Company Name. Well the problem I am running into is that I constantly add new companies into this table and the CompaniesID is an auto number that currently all the reports are sorting off of, what I want to be able to do is sort by Company name in a report rather then CompanyID,...
                                      See more | Go to post
                                      • Darknight850
                                        started a topic Log On Box Access 2007
                                        in Access

                                        Log On Box Access 2007

                                        Hello All,


                                        I have ran into a foolish problem using access 2007. I have made a database using 2003 with user-level security and for some reason when I start the database now that I have installed 2007 it is not asking me for a username and password, just like it would do if I was not logged into a workgroup. But there is now option to log into a work group in 2007. I have read up on 2007 quite a bit just to find how to solve...
                                        See more | Go to post
                                        • Darknight850
                                          replied to Creating A Multiuser databse
                                          in Access
                                          that is true, i had tested out both of them, and even though i loose a password with the replica, i do like the ease of the synchronization . i did get the startup forms to pop up as well, which is strange that they did not auto open when I tested, but they did when i started using it, so thats fair enough. thank you for your input, i think i will stay with the replication for now, it seems easier for every one this way.
                                          See more | Go to post

                                            Leave a comment:

                                          No activity results to display
                                          Show More
                                          Working...