For simplicity sake, here are the basics of the query I am stumped
on...
Type: Select query
Name: ColorCells
Below is a partial list of the "Cases" for the code (I did not think
there was a need to list all 21)
If Identifier = "A" then color Green
If Identifier = "B" then color Blue
If Identifier = "C" then color Red
The final "case" would be a case else. In other words If Identifier
=
to anything besides the previous 20 items the color = clear
Can anyone please assist me with formalizing this code?
Your help is greatly appreciated. I am enrolled in a Visual Basic
class in 4 weeks, but need to complete this before then.
Re: Excel Calcs in Access ... to sort the records into the order you need. ... certain that the query will find the correct "cell above" (i.e. the ... section identifier which is in the same column as the "D"s. ... (microsoft.public.access.modulesdaovba)
Re: Ubuntu book for "grandma" users ... use computers.... in Windows you have Notepad to do that". ... the basics of a user interface are more or ... Hence the query for simple basic textbooks. ... (Ubuntu)
Re: Importing from another database on same server using SQL Server Express ... otherwise identical database into a more recent copy. ... I tried a few different query techniques as suggested in historical ... The multi-part identifier "OldDatabase.dbo.Table.PK" could not be ... to another database within the same server instance or otherwise. ... (microsoft.public.sqlserver.msde)
Re: Advanced query issue ... To answer your questions the unique identifier of each table is jointly ... Note the second select is the query about finding unmatched ... I also used UNION ALL, ... (microsoft.public.access.queries)
Re: Advanced query issue ... To answer your questions the unique identifier of each table is jointly ... Note the second select is the query about finding unmatched ... I also used UNION ALL, ... (microsoft.public.access.queries)
