Trying to correctly create a DCOUNT for unique transaction IDs.

Best Microsoft Access Programmer Portland OR

Trying to correctly create a DCOUNT for unique transaction IDs.

https://i.redd.it/t3tl0wpmo5531.png

I’m stuck. So I have attempted to build a DCOUNT with the objective of telling me how many bins per transaction ID (wireless_trans_audit_hdr). I don’t need to know the bin_ids, just that there are 37 or however many unique bins associated with this transaction ID.

For sake of time, I won’t walk you through the different iterations I have attempted, but most have either resulted in needing a parameter value, invalid bracketing, or lack of an operator. Most of it seems to

Read More

Trying to correctly create a DCOUNT for unique transaction IDs.

Best Microsoft Access Programmer Portland OR

Trying to correctly create a DCOUNT for unique transaction IDs.

https://i.redd.it/t3tl0wpmo5531.png

I’m stuck. So I have attempted to build a DCOUNT with the objective of telling me how many bins per transaction ID (wireless_trans_audit_hdr). I don’t need to know the bin_ids, just that there are 37 or however many unique bins associated with this transaction ID.

For sake of time, I won’t walk you through the different iterations I have attempted, but most have either resulted in needing a parameter value, invalid bracketing, or lack of an operator. Most of it seems to

Read More

Limit records by specifying fields in query?

Best Microsoft Access Programmer Portland OR

I have 4 modules that I need to execute VBA in which loads records from a table and the loads various html files to match data and add data to the records. Each module is focused on particular fields in the database. Currently I’m selecting all fields from the table where two particular fields are Null.

So for example my statement is like this:

SELECT * FROM tblAssets WHERE assetType Is Null AND assetColor is Null

But couldn’t I just say:

SELECT assetType, assetColor,

Read More

Calculated field from a query and a text box.

Best Microsoft Access Programmer Portland OR

My Access is in Dutch and I don’t know all the names, but I’ll try.

I’m making a form where I want a field to calculate the total amount of websites devided by the amount of weeks.

I have a list with a single value in it which is a SELECT COUNT(*) query. Not sure if the thing is called “list”, but it’s the one to the right of the Combo Box icon.

The other field I have is a text box with a

Read More

Calculated field from a query and a text box.

Best Microsoft Access Programmer Portland OR

My Access is in Dutch and I don’t know all the names, but I’ll try.

I’m making a form where I want a field to calculate the total amount of websites devided by the amount of weeks.

I have a list with a single value in it which is a SELECT COUNT(*) query. Not sure if the thing is called “list”, but it’s the one to the right of the Combo Box icon.

The other field I have is a text box with a

Read More

Storing Username as variable upon login

Best Microsoft Access Programmer Portland OR

Created a login form that checks to a table to validate username and subsequent password and opens a form at the end of it all.

My thought was to store the username entered as a variable that i can call upon later to use that username ex:when entering a sale entry ill be able to call the variable to make note of who made the entry in a separate field and possibly run queries off that main sales database to filter sales by User/Person

Read More

Storing Username as variable upon login

Best Microsoft Access Programmer Portland OR

Created a login form that checks to a table to validate username and subsequent password and opens a form at the end of it all.

My thought was to store the username entered as a variable that i can call upon later to use that username ex:when entering a sale entry ill be able to call the variable to make note of who made the entry in a separate field and possibly run queries off that main sales database to filter sales by User/Person

Read More
Page 284 of 355
1 282 283 284 285 286 355