I have a crosstab query and, in the row heading, I have a "date" column. The
parameter I want to use is:

What is the best way to do this?

I have two queries. The second query is basically relating to the first
query. I want the second query to show a zero (0) if there are no matching
records. Please help...
The first query is:

I am currently working on a small database project that is very basic.  We
are basically tracking the usage of our 3 internet cafe's.  Each user is
required to sign the sheet when they login, as well as when they log out.  We
take this info and enter into acces, that way we can ...

I need to compare the count of an amount of matches in one column to a match
of a dataset in 2 columns- An example is best:
Column 1         Column 2         Result
     2                     1                  1

How do I pass a parameter with a null response in a CrossTab Query?
I have the following SQL.  I am unable to get the PARAMETERS right.
PARAMETERS [ENTER STORE NUMBER] Text ( 255 ), Like [ENTER STORE NUMBER] Is
Null Text ( 255 );

Two questions
1)  How can i permanently update all table values to Upper Case.  Right now
they are just formatted to upper case,but when the user selects a specific
cell, they revert to lower case.

I have a field of information that contains data as follows:
Example 1: 00000000000X03028
Example 2: 30028288
I need to remove the leading zeros in the first example and retain the

I have a field that contains information to extract.
i.e." billing change $12.16."    I want to only extract 12.16

This seems simple, but I can't figure it out! I have a large database that
lists about 200 employees and 20 schools. The employees have worked for some,
but not all of the schools.  Each employee indicated how many times they have
worked for a particular school - from zero on up. ...

I used to know what I was doing with Access but I'm really rusty and can't
find a way to solve this problem, so any help would be much aprreciated...
I've simplified things for this posting, so let's say I've got 10 records
and 5 fields (in practice there are a lot more but the ...

I have a list that stores an agent name and premium per policy.  I want to
find the top selling agent within the last 7 days.  I got the last 7 days
part but how do I only get 1 record.  I just want the results to be one agent
name and the premium.   Here is the sql.

I have several MDB files created in 2003 (XP) that ran fine.  After upgrade
to MS Office Enterprise 2007 these data bases no longer function.  I did use
the ConTool.msi without any comments.  I also did save the mdb to the new
2007 file.  When I start the data abse after ...

In my contacts database, I have FirstName, LastName, Company Fields. When
data is collected, many times all three of these fields are left blank within
the record.  I have tried the Select query where I put [is not null] without
the brackets under each of these three fields and ...

I have several queries that are linked to a table in my database.  I would
like to replace this table with a query containing the same fields.  However,
I'm afraid that I'm going to have to manually change the source of each field
in my origional queries.

I hope someone can help.  I have received data which appears as 01/01/2007
12:25:45.  I need to change the details to just read Date and not the time as
when I use this field in a query look up no data returns as the system is
looking for an exact match.  I want to produce ...