Results 1 to 5 of 5
  1. #1
    TheSpecialist is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2015
    Location
    Georgia
    Posts
    47

    entering numbers in the database

    Erikabase
    DTE 3 digit 3 digitmid 3 digiteve 4 digit 4 digit eve 4digit nite
    03/05/2018 399 875 555 9778 8453 4587
    03/04/2018 791 254 754 0618 6922 2185
    03/03/2018 556 683 819 7953 0788 6673
    03/02/2018 077 381 162 3187 6951 1804
    03/01/2018 191 631 653 8435 3559 5780
    02/28/2018 322 5633 483 1083 8642 7506
    02/27/2018 965 168 797 4974 1856 8022



    I Want to search for a specific three digit number in all three fields; (mid day, evening and nite) by using a parameter query. I Want the query to return every time that specific three digit number appeared either in the fields and the also show the 4 digit numbers for those same dates; and 2 days before and 3 days after.

    Is this possible?

    Last edited by TheSpecialist; 03-25-2018 at 07:26 PM. Reason: making it clear

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    This explanation is a bit scrambled ...
    Suggest that you provide details of the table name & field names - design view & datasheet view
    Give specific details of what output you want in your query(?)
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    TheSpecialist is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2015
    Location
    Georgia
    Posts
    47
    I have a database where I have one column with 3 digits in it and another column with 4 digits. This database also pulls 2 days before and 3 days after. However, I want to know how can I add on to this sql statement that if I put in 3 digits like 123 that it will pull all the times 123 came and it will also pull numbers like this for my 4 digit columns. I understand that my 4 digit column might pull something like 123...4..5 and so on but I want to know is this possible


    Ex. If I enter in my parameter 123 it will show me all the time 123 came and the numbers that came 2 days before and 3 days after and then for my 4 digit column it pulls also 123...(and whatever the number after the 3 digit number )

    This is my SQL statement so far

    SELECT Erikabase.DTE, Erikabase.Cash3mid, Erikabase.Cash3eve, Erikabase.3nite, Erikabase.4mid, Erikabase.4eve, Erikabase.4nite
    FROM Erikabase, qselLotDates
    WHERE (((Erikabase.DTE) Between [TargetDates]-2 And [TargetDates]+3))
    ORDER BY Erikabase.DTE DESC;





    Thank you in advance

  4. #4
    TheSpecialist is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2015
    Location
    Georgia
    Posts
    47
    Just updated
    thank you Ridders52

  5. #5
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Quote Originally Posted by TheSpecialist View Post
    I have a database where I have one column with 3 digits in it and another column with 4 digits. This database also pulls 2 days before and 3 days after. However, I want to know how can I add on to this sql statement that if I put in 3 digits like 123 that it will pull all the times 123 came and it will also pull numbers like this for my 4 digit columns. I understand that my 4 digit column might pull something like 123...4..5 and so on but I want to know is this possible


    Ex. If I enter in my parameter 123 it will show me all the time 123 came and the numbers that came 2 days before and 3 days after and then for my 4 digit column it pulls also 123...(and whatever the number after the 3 digit number )

    This is my SQL statement so far

    SELECT Erikabase.DTE, Erikabase.Cash3mid, Erikabase.Cash3eve, Erikabase.3nite, Erikabase.4mid, Erikabase.4eve, Erikabase.4nite
    FROM Erikabase, qselLotDates
    WHERE (((Erikabase.DTE) Between [TargetDates]-2 And [TargetDates]+3))
    ORDER BY Erikabase.DTE DESC;

    Thank you in advance
    I didn't understand the explanation in post 1 so repeating that is no help
    You example & SQL don't help much either

    To you it may be obvious what you mean but that isn't the case from here

    I know you have a field with 3 digits and another with 4 digits - but you actually have 3 fields with each number as part of the name so that doesn't help
    Your query appears to have a cartesian join between your table Erikabase and an unused select query qselLotDates.
    Is that correct? If so, why is the select query qselLotDates included?

    Which field are you wanting to filter e.g. using a parameter?

    Apart from that, all your query fields are in one table - as requested, please show me:
    a) the table design
    b) the table in datasheet view (or several records to explain the idea)
    c) the result you want from your query for those records
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 08-17-2017, 04:47 AM
  2. Record Users Entering and Exiting database
    By cbende2 in forum Access
    Replies: 11
    Last Post: 07-07-2015, 12:49 PM
  3. Replies: 1
    Last Post: 05-19-2012, 03:55 PM
  4. Replies: 3
    Last Post: 01-27-2012, 05:32 PM
  5. Entering 16 digit numbers into number field
    By chrismid259 in forum Access
    Replies: 7
    Last Post: 12-14-2010, 10:40 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums