I'm trying to call a "value" from a field in a table instead of the underlying number - Basically I have this: A table called Projects with seven columns...

Hi, I have data like this 03/14/05 13:09:42.0 0 CON 03/14/05 13:10:19.0 1 CON 03/14/05 13:10:21.0 2 CON 03/16/05 00:57:42.0 3 CON 03/16/05...

How do I multiply one field by another in an Access query? One field is Units on Hand with multiple numbers and the other field is price per unit.

Another Decimal issue. I an unable to toucv this table, which resides in MYSQL. Just attempting to open it in table view, much less use it in query, results...

Hello, I have the following SQL code: DECLARE draw_num2 int SELECT draw_num2 = max (draw_num)+ 1 --THIS LINE IS MY PROBLEM FROM hdx_housing_assign_master I...

Is there a way to have a field in a query which displays the current record / line number of each record in the queries' recordset. I want to avoid using...

First - I'm a newbie to Access. I have 4 files (representing 4 FY quarters) that I am trying to integrate into a single master file. I need to selectively...

how do i do this in a query if my field equals N then take another field and multiply by 1 else if field is a T then multiply by 1.2 i thought it would be...

I have a table of categories with Primary Category and Secondary Category and Category ID. Category ID is one to many with Product Table. Primary Category...

I have a really weird problem and not sure why. I have a calculation doing nested iif's seven of them. I kept getting an error message and it pointed to the...

I am new to access...I am need of help!! I have been working on this project for about a month trying to get it to work. This is the problem I am trying to get...

I have a field in my table that holds a value keyed from a list of numbers: 100-999. Each number has a corresponding "label" that I want to be displayed in my...

Can someone tell me if this is close and if it can be done IF ctl.control Source in CurrentDb.Querydefs("Maps and Plans Query") then Wherestr = Wherestr &...

I need help finding a way to do this. I have the addess in a field were addr1 is followed by a line feed then addr2 portion follows. I can identify...

Can I write a query instead of using the append funtion to add a range of dates to a table? If this can be done, what is the function for the query? Thanks

I have a parameter query with many criteria, such as ' Like !! & "*" ' I though it was working fine until I discovered that it only returned records where...

I need help with the fine details behind this idea: Need to pull a weeks worth of data from a database (Outbound - Total : Date) I have a date conversion...

Hi guys, I was recommended this site as the best place to find solutions for those problems that take ppl like me days to solve but you guys just seconds!! I...

Hi, I've coded a form which calculates and populates a text box on a form. To be clear, data entered into the Textbox is not done manually it is...

Simple question.. I think My query is showing the same name 2 times I want to only see the name one time Example Staff members Vacation Pay John Bill Tom Bill