Hi to all, I have an already query that uses SELECT ... UNION Statements to combine fields in tow different tables( infos about Imported and Exported boards)...

I have several fields in my query. i am trying to write this formula (2) / (total of the xFin column). Ill try and explain this the best I can. nMLO2 as a...

I have a query that looks like below and I want to add a new column that combines the projectID and another new column that numbers each entry incrementally by...

I ask this question earlier and I didnt make myself clear. Hope you can understant me this time. 2 with this expression i am trying to count the number of...

Good day, First, here is a list of tables, PKs and associated forms TblMuseum, MuseumID, frmMuseum TblArtifact, ArtifactID, sfrmArtifact TblSwipeDetails,...

I have a table called Contacts. I have another table called Insurance. I want to show in a query which Contacts have a particular insurance. If I query the...

I have a frminvoicepaymentssubform with the following controls: MaxPaymentDate =DLookUp("paymentdate","tblinvoicepayments","=" & & "And =" & ) MaxPaymentID...

I have a table in which I would like to combine two fields. The fields are LastName and FirstName. I would like to create a new field called FullName that...

I have a number of check boxes in a query, I would like to dynamically alter which check box will be displayed by using a combo box in a form. I am having a...

Hello, I have a tblCandidates. Calls are made to candidates. The date the call is made is stored. The result of the call is stored, i.e. "message" left. ...

I have a form with an input box that has a default value set. I then have a query that is using this value as criteria (Forms!frmTest!txtValue). When the...

ID SDate TenantID State Parm Notes 1322 19/09/2005 13:52:29 MRC Raise T1 0 Man: £2200,L141 1323 19/09/2005 13:52:36 MRC T1 Sent 0 Man: £2200,L141 1324...

Is there a way to use the LEFT() function to take all the characters until a space is encountered? I am trying to normalize data I imported from another...

I know it's going to be a real simple answer but I'm trying to exclude records based on the last three characters of an 11 character text string. I want to...

I'm using a Form to have the user enter/select search criteria, eg a property's address, then use the query criteria expression: Like "*" !! "*" , but the...

In my query there are a number of Check Box Fields. I would like to be able to filter out all the other check boxes when a check box is selected from a combo...

This is a complex query that shows debt agings for all our customers from CURRENT, 1-30, 31-60, 61-90, 91-181, 181-360, 360+ days. I have 2 tables joined,...

I have data stored with Date and TIME, but want to group by Calendar Date. Which fuction do I use in the calculated field? (since the query wants to group by...

I am trying to join a table and a query. The qryJulysales gives manager, acct, itemrange, sales, disconinv. The table has acct, item range, discoffinv. This...

Hello~ I am trying to create a form that would allow the user to select the fields they would like in a query and then to execute the query. The number...