Search results

Yes, but to do that you need to store both IDs

A common problem, I would store both the category and sub category.

try SELECT COUNT(MyField) as CountOfMyField FROM myTable WHERE MyField=0

you need to sum the calculation SUM(IIf([ECV2 date]=1,1,0)+IIf([Pass2 date]=1,1,0)+IIf([TWC2 date]=1,1,0)+IIf([EVF2 Date]=1,1,0)+IIf([Medical2 date]=1,1,0)+IIf([Pic2 date]=1,1,0)+IIf([Police2 date]=1,1,0)+IIf([TT2 Recvd]=1,1,0)+IIf([Med2 Recvd]=1,1,0)) PS count is not a synonym of sum count...

add a fixed constant to your query and group on that. Here is an example of one constant field and a field from a table SELECT "Dummygroup" as Dummygroup , Field1 FROM TblTest. Then you create a group on the Dummygroup Field

Don't create new fields, use the Access functions Month(YourDate) and Year(YourDate) to return the month/year part of a date. You use these functions in your query.

You will have to re code the calculations as only the data will be imported.

the basic technique is to use a union query to merge the field you want to total, here is an example Select Myfield from Query1 Union all Select myfield from Query2 if this was called qryUnion then you can create a totals query on the union query select Sum(myField) as SumOfMyField FROM...

You could pass the string to a function, and test the ascii value of the first character. 'A' has an ascii value of 65 and 'a' has a value of 97

create a main form for your supplier. Then use the combo box wizard to create a combo box that list all the supplies and loads the selected supplier. Next create a sub form for the orders and link the parent/child keys which in your case is the Supplier ID.

the easiest way is to create another query without the where clause. The in after update event of the check box, test if true or not and set the record source of the form to the approriate query then requery the form.

your numbers are being displayed in scientific notation. E-2 means raise the number(Up to but not including the 'E') to -2 try formatting to one decimal place

DCrake if it's a pass through query to SQL then the date delimiter will be ' and not # which is the date delimiter for the Access Jet database Engine.

try experimenting with sorting and grouping, If necessary create a dummy group with a header and footer and place all the objects to be kept together between the group header and footer.

I suspect you have an alpha character in the field, therfore you cannot convert that value to a numeric, hence you cannot convert the column.

Click on the group header or footer and one of the properties you will see is 'keep together' set this to yes.

one of the properties of a sub form is parent/child links use that to link a subreport to a main report, just as you ca do with main form/sub form

It may be due to the fact that for date comparison the date should be in in mm/dd/yyyy format and not dd/mm/yyyy. Otherwise what I would do is try to determine where the error is by commenting out everything but the select statement, if it runs ok then add where clause. Another problem may be...

A query is a recordset and if it is from one table only then it is updatable. - experiment

I would create a seperate table to hold titles and create a combo box lookup on your data entry form. Otherwise if you have a text field you WILL end up with entries such as Mister, mr. Mr., miter - spelling mistake, not what you want if the title is included on a letter.