Create table and Query (1 Viewer)

smtazulislam

Member
Local time
Today, 15:41
Joined
Mar 27, 2020
Messages
806
Hello,
We are a small business in local area. COVID19 effective in our business, now our head office to comminication all of branch and retail store by Zoom apps. We try to connection with all of Municipility/UnionParishad>Ward > Municipility area / Village Area > and each shop owner.

We are contact with shop owner/Keeper for two kinds issue: product complaint and our represatative they're follow up week product expiry date or not.
search query for depend each combo box
1. CboDistrict >
2. CboSubDistrict >
3. CboMunicipality/UnionParishad >
4. CboWardNo >
5. CboMunicipalityArea/UnionParishadArea >
6. Textbox ---
 
Last edited:

Jjaeger14

New member
Local time
Today, 15:41
Joined
Dec 26, 2020
Messages
15
So your question is how to create tables with the fields you list above? or is it how to create the database in general? To create a table, open access and start creating a table. Add the field names and choose the data types. close and save the table with the desired name. To go back and edit the table, right click the table, choose design. Edit the table.
 

smtazulislam

Member
Local time
Today, 15:41
Joined
Mar 27, 2020
Messages
806
So your question is how to create tables with the fields you list above? or is it how to create the database in general? To create a table, open access and start creating a table. Add the field names and choose the data types. close and save the table with the desired name. To go back and edit the table, right click the table, choose design. Edit the table.
Thanks for your reply
I already create table you see it first post. I want to query for search and relationship
 

mike60smart

Registered User.
Local time
Today, 12:41
Joined
Aug 6, 2017
Messages
1,899
Hi
Can you upload a zipped copy of the database?
 

Users who are viewing this thread

Top Bottom