Dates showing up for multiple months (1 Viewer)

kloot1rr

Registered User.
Local time
Today, 07:10
Joined
Jun 10, 2015
Messages
39
I have a query that is supposed to be showing todays data (as it is labeled) but it keeps pulling today's number date (i.e. the 1st, or the 17th) for every month, when i only want June 18th not including jan/feb/march etc. 18th.

I started running this query in may, that's why it only shows may and june's data.

I'm thinking it's definitely a problem with the criteria but check out the attachments and let me know, thank you!
 

Attachments

  • pic100.png
    pic100.png
    23.9 KB · Views: 99
  • pic101.png
    pic101.png
    24 KB · Views: 107

plog

Banishment Pending
Local time
Today, 07:10
Joined
May 11, 2011
Messages
11,611
That's a real screwy query you have--how come the two data sources aren't linked?

To your issue: Your criteria should be this:

Date()

underneath the [Dates] field.
 

kloot1rr

Registered User.
Local time
Today, 07:10
Joined
Jun 10, 2015
Messages
39
I just needed to add 2 fields from another query

When i put date() as the criteria under my Dates field, I lose all of the data when I view it
 

plog

Banishment Pending
Local time
Today, 07:10
Joined
May 11, 2011
Messages
11,611
What field in your table tells you what the date is? That's the one you need to put Date() under.
 

kloot1rr

Registered User.
Local time
Today, 07:10
Joined
Jun 10, 2015
Messages
39
Yeah I put date() under Dates, which is used for my dates naturally, but when I view the query it shows nothing.
 

plog

Banishment Pending
Local time
Today, 07:10
Joined
May 11, 2011
Messages
11,611
That's because Dates probably isn't a date field. Can you post sample data, or your database itself?
 

kloot1rr

Registered User.
Local time
Today, 07:10
Joined
Jun 10, 2015
Messages
39
Dates is a date field. Pic855 shows what I am currently getting when I run the query. I'd like the data for just today, not May as well. Pic856 shows what my Master Estock Report fields look like. Pic857 shows what my Left in Estock Totals query looks like. Pic858 and Pic859 show what my query currently looks like set-up wise. I do not understand why it will not simply work? lol
 

Attachments

  • pic855.png
    pic855.png
    29.1 KB · Views: 95
  • pic856.png
    pic856.png
    19.3 KB · Views: 136
  • pic857.png
    pic857.png
    12.6 KB · Views: 83
  • pic858.png
    pic858.png
    22.6 KB · Views: 97
  • pic859.png
    pic859.png
    23.3 KB · Views: 93

plog

Banishment Pending
Local time
Today, 07:10
Joined
May 11, 2011
Messages
11,611
Then my solution should work. Use Date() underneath the Dates field.
 

kloot1rr

Registered User.
Local time
Today, 07:10
Joined
Jun 10, 2015
Messages
39
I get a blank screen when I run it lol. damn thing...
 

plog

Banishment Pending
Local time
Today, 07:10
Joined
May 11, 2011
Messages
11,611
show a screen shot of the design view with it.
 

kloot1rr

Registered User.
Local time
Today, 07:10
Joined
Jun 10, 2015
Messages
39
I think this part is messing something up
 

Attachments

  • 45.png
    45.png
    5.9 KB · Views: 85

plog

Banishment Pending
Local time
Today, 07:10
Joined
May 11, 2011
Messages
11,611
Weird. No records at all? Can you post the database?
 

kloot1rr

Registered User.
Local time
Today, 07:10
Joined
Jun 10, 2015
Messages
39
heres the master estock that im using
 

Attachments

  • 89.jpg
    89.jpg
    100.6 KB · Views: 103

plog

Banishment Pending
Local time
Today, 07:10
Joined
May 11, 2011
Messages
11,611
Wait, did you take out the other criteria? All you need is the Date() one
 

vbaInet

AWF VIP
Local time
Today, 12:10
Joined
Jan 22, 2010
Messages
26,374
May I add that your Date field is probably hiding a Time part which sometimes causes issues. Format() your date field within the query and use the Date() function as criteria again.
 

kloot1rr

Registered User.
Local time
Today, 07:10
Joined
Jun 10, 2015
Messages
39
figured it out...criteria needed was >=Date()

Thank you for the help!
 

Users who are viewing this thread

Top Bottom