Help with Query

  • Thread starter Thread starter Dave2010
  • Start date Start date
D

Dave2010

Hi all

I'm new to Access, I've been using excel for a few years, now I need
more
power to my data analysis.

Using Excel 2007 and Access 2010

I've a table in design view field 9 Criteria, I've a search [Please
Enter
Name] I type say John which find all record for john. In Field 1 there
are
numbers, Question: How can I get the query to find all the same
numbers
"Records" in that field that John has. Question2: Also Field 7 has
numbers
how could make all records that have a 1 in them bold and maybe the
row
colour say Yellow.

Hope I've been clear in my questions.

Thanks in advance.
 
Hi all

I'm new to Access, I've been using excel for a few years, now I need
more
power to my data analysis.

Using Excel 2007 and Access 2010
Click to expand...

Well... Excel is a spreadsheet, best of breed. Access is a relational database
programming environment. THEY ARE DIFFERENT!!!

Access is emphatically *NOT* "Excel on steroids". It's a different program,
with a different structure, and requires a very much different mindset.
Treating it as "big Excel" is simply not going to work.
I've a table in design view field 9 Criteria,
Click to expand...

Tables are for data storage. You'll probably rarely need to ever even look at
a Table once you have your database set up. For one thing Tables don't have
criteria - Queries do.
I've a search [Please
Enter
Name] I type say John which find all record for john. In Field 1 there
are
numbers, Question: How can I get the query to find all the same
numbers
"Records" in that field that John has.
Click to expand...

You'll have to explain that. What does "Records" mean in this context? Could
you post a few rows of sample data and the desired result?
Question2: Also Field 7 has
numbers
how could make all records that have a 1 in them bold and maybe the
row
colour say Yellow.
Click to expand...

Not in a table, no; but very easy on a Form based on the table, or based on a
query referencing the table. Use Conditional Formatting.

Hope I've been clear in my questions.
Click to expand...

Here are some possibly helpful references to get you started:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
 
Back
Top