Access Issues - Queries and null entries

[AccessInsane]

I have tables and queries set up in access that correspond to other forms and reports. The information I need is all there. I am trying to set up an employee PTO page that comes up as a form. I have it all set up so that you need to enter your Social Security number to pull up the individual's information, but right now if there is 0.00 for earned PTO or they have not used any to date, nothing comes up. What do I need to put in my criteria to make all values show up even if they are zero? the "" is not working.

 

[Ken Snell]

You don't give us any information about the table's structure nor the query
that you're using as the form's recordsource. Likely you need a change in
the query's criteirion or in how you're doing a join between tables, or
something similar, but you need to give us more information before we can
provide pointed suggestions.

--

Ken Snell
<MS ACCESS MVP>

I have tables and queries set up in access that correspond to other forms

and reports. The information I need is all there. I am trying to set up an
employee PTO page that comes up as a form. I have it all set up so that you
need to enter your Social Security number to pull up the individual's
information, but right now if there is 0.00 for earned PTO or they have not
used any to date, nothing comes up. What do I need to put in my criteria to
make all values show up even if they are zero? the "" is not working.

 

[FresnoITAssistant]

The query I created runs off a table that has employee profile data enter (ss#, name, etc.), a table that has pto earned for the year and pto carryover for the year along with their employee id that joins to the employee profile data. I also have two queries set up that calculate the entries we've made as far as pto and carryover used per day and that is subtracted from total pto/carryover available in another query to tell me what is remaining. When I try to create a form using those items, I cannot get employees with zero available or zero used to appear. The form is set up so that it searches by ss#.

 

[Ken Snell]

I'm sorry, but you still need to give more info. What is the SQL of the
query or queries that you've set up? What is the query that is the form's
recordsource? I'm guessing that the problem you have is caused by an
improper join between two tables in one of the queries, but without details
that is just a guess.

--

Ken Snell
<MS ACCESS MVP>

The query I created runs off a table that has employee profile data enter

(ss#, name, etc.), a table that has pto earned for the year and pto
carryover for the year along with their employee id that joins to the
employee profile data. I also have two queries set up that calculate the
entries we've made as far as pto and carryover used per day and that is
subtracted from total pto/carryover available in another query to tell me
what is remaining. When I try to create a form using those items, I cannot
get employees with zero available or zero used to appear. The form is set
up so that it searches by ss#.

 

[siya nikelo]

I'm sorry, but you still need to give more info. What is the SQL of the
query or queries that you've set up? What is the query that is the form's
recordsource? I'm guessing that the problem you have is caused by an
improper join between two tables in one of the queries, but without details
that is just a guess.

--

Ken Snell
<MS ACCESS MVP>

enter
(ss#, name, etc.), a table that has pto earned for the year and pto
carryover for the year along with their employee id that joins to the
employee profile data. I also have two queries set up that calculate the
entries we've made as far as pto and carryover used per day and that is
subtracted from total pto/carryover available in another query to tell me
what is remaining. When I try to create a form using those items, I cannot
get employees with zero available or zero used to appear. The form is set
up so that it searches by ss#. that have

 

[kerrpmb]

In access there should be no table. The one i worked with was Office 2002 or
2003. It is really a straightforward database where you query after putting
in Antoinette M. Kerr, but like i told a gentleman beforehand that it may be
financials you may be referring to. Thank you.