Search results

OK still working on how to figure out how to use append queries. thanks so much

ok I got the above running great. The only problem is...In one project there can be up to 400 work items. For each work item there can be up to 15 disciplines and for every discipline/work item there can be up to 8 quotes. So I'm finding that I have to enter the discipline/work item 8 times for...

@jwzp22 Thank you that makes alot more sense. Here is an example of a typical bid. The projects are broken down by a work item number (123-12-1212), For each work item there could be up to 20 different disciplines that need to go out for a quote i.e. Stage-123-12-1212, Tank-123-12-1212...

I have one table for the quotes. The structure of the table is as follows. Sub Name 1, Quote Status 1, Hours 1, Material 1, Total 1...thru Sub Name 8, Quote Status 8, Hours 8, Material 8, total 8

The table that I need to make a query for is a quote table for subcontractors winning and competition quotes. I need to make a query that pulls the "Winning Bid" and "Winning Bid 2" from each row. The problem that I am having is that since there are 8 fields (Quote status 1-8)for the "Winning...

Is there a way to have a macro that builds a query? I use the same query over and over again. (only changing the criteria) I do not want to have to repeatedly build the same query using the query design. Any help would be great. Thank you

That was the answer I needed. Thank you so much

Right..from the design view how do I find the code? Thanks

Below is the code that needs to be changed to open the form in the datasheet view: I just don't know where to change the code. Can anyone help and advise how to find where to change the code? DoCmd.OpenForm stDocName, acNormal, , , , acDialog CHANGE TO::confused: DoCmd.OpenForm stDocName...

I have 50 forms on the switchboard. I would have to redo my entire switchboard to run macros and I dont really want to do that.....

Below is the code that needs to be changed to open the form in the datasheet view: I just don't know where to change the code. Can anyone help and advise how to find where to change the code? DoCmd.OpenForm stDocName, acNormal, , , , acDialog DoCmd.OpenForm stDocName, acFormDS, , , , acDialog

yes a button from the switchboard.

From the switchboard I can not get forms to open in the datasheet view. I have it set as the default view but it still opens in the form view. Does anyone know the code? and if so, where do I put the code. Thank you :confused:

Thank you so much! you were a great help:D

for the rates they each have default values of 6.4, 11.23, 48.55. that are not reading then...So do i have to enter the rates for every calculation??

i have attached a sample of the db.. the password is :SUBCONTRACTS all caps. the query in question is the qry_BAEComp. I really appreciate your help. Thanks

Ok yes I created it in the query designer. I pasted the verbiage into the sql view from the query designer. still getting the $0 answer......

I dont know what the sql query designer is?....I created the query in the design view and entered the formula by hand into the expression builder yes . Can you tell me where to locate the query designer so that I can paste it in. Thank you

SELECT tbl_BAEComp.[Reference Number], tbl_BAEComp.[WORK ITEM NUMBER], tbl_BAEComp.[SUB DISCIPLINE], tbl_BAEComp.[BAE LABOR HOURS], Round([BAE LABOR HOURS]*0.29,0) AS [Equates to 29%], [BAE LABOR HOURS]+[Equates to 29%] AS [Total Hours], tbl_BAEComp.[MATERIAL VALUE], Round([Total Hours]*1.6,0)...

no the values are not all 0 or null. some have dollar amounts in them. I removed the formula and this are the fields in the query: I reentered the formula. Still nothing.....getting the answer of 0 SELECT tbl_BAEComp.[Reference Number], tbl_BAEComp.[WORK ITEM NUMBER], tbl_BAEComp.[SUB...