I have a database that keep records of vaccination for children. There are
two tables, tblMatser keeps the personal profile of children, tblVaccine
keeps the vaccination record such as date of vaccination, vaccine name &
vaccine dose number etc. The relation between tblMaster and ...

i have a list in a table of lots of products with several price types
like this  (example)
SKU    PriceType    Price
1234    Catalog    $10.49

I have a ten field query.  I have criteria on the first field to refine the
query, this brings back 500 records which works fine.  
I have another five fields which I need to add criteria to (Is not null and
not equal to 0).  When I add this criteria I lose the refined results ...

I have several queries I wish to combine to one query to creat a report.  
These queries are asking for info based on a date. If the result of one query
is empty (no results from the that date), then the combined query turns up
completely empty even though individually, the other ...

I am trying to get my Count field to show 0 even if there is no data.  
SELECT [Enter 120 Day Month Begin Date] AS [Date],
Count(tblExternalErrorReport.ACCT_000) AS [Count]
I tried the following and it did not work

I am trying to create an expression in a query using TABLE1Y and TABLE2T that
says, If TABLE2.IPQTY - TABLE1.IPQTY is null, then print TABLE2.IPQTY,
otherwise subtract TABLE1.IPQTY from TABLE2.IPQTY.  The data in the fields is
numeric, however fields are blank instead of having a ...

i have a list in a table of lots of products with several price types
like this  (example)
SKU    PriceType    Price
1234    Catalog    $10.49

How can I build a update query that removes all numeric characters in a
field?  I have a field that has data such as "3478 PRG Management", "Asc
Chiti Baa", "54 Oracle DBA"... they have from 0 to 6 leading numeric
characters, using the Left function with " " as the separator will ...

I am building a query where I would like to display everything but the left
seven part of the data field. I can do it where it only shows the left seven
but not the other way around. I am looking at this because the left seven are
all the same and everything after than can vary ...

(i hope its not a repeat im having trouble posting)
i have a list in a table of lots of products with several price types
like this (example)
SKU    PriceType    Price

I tried twisting an old code that hangs up with a new code, which gave
a JOIN SYNTAX error. I am a novice at access....can someone look down
at the new code and please tell me what I may be doing wrong.
Old - No error - HANGS UP

I have:
Table 1
Name    SSN    Vendor
Table 2

I've got a problem that I don't even know where to start for fixing it. I
have a Query, qryPortfolio which has a field MVbase. Another field Type can
be 'Equities' 'Cash' or 'Options'. If I filter on Options and group
everything to just get one figure for the sum of MVbase, it comes ...

I have a query that contains a text filed will all the project codes of the
clients we deal with. Most of them are three digit numbers (I.e. 707, 708,
709). However, if we are writing a proposal we stick the letter P before the
three digit code (i.e. P707, P708, etc). Therefore I ...

how do i create a query which will pull up a list of matching records. for
ex: If i enter "main street" in the address field it should list all the
records that contain "main street".
then i want to create a form to display this data?